Spread the word

Monday, June 14, 2010

How to find embedded objects in a Microsoft Excel sheet or document

You can easily embed other documents within a Microsoft Excel document. Microsoft Excel incorporated that document within it. But many times it happens that you may have embedded some document within Microsoft Excel but you are not able to find it again. Many times the embedded document is placed in such a position where you may not be able to select that.

In that case you can select all the embedded objects in that Microsoft Excel document with it’s inbuilt feature to find embedded objects.
  1. Use the Go To option from the Edit menu or use the keyboard shortcut Ctrl + G to open the Go To dialog box.

  2. Click on Special.

  3. Select Objects in the Special dialog box.

  4. Click Ok.







Now you will find that all the objects which are embedded in that Microsoft Excel document will be highlighted and will be selected. All the objects in that file are selected now, wherever they are. Now you can move them, edit them or delete them easily.

13 comments:

Webjen said...

Great Post!!!

webhost said...

great post. It is something new for me.

OpenCart Templates said...

thanks for this great tips. Thanks a lot!

web design hampshire said...

Thanks for your techniques. This is very useful for me. Thanks

internet marketing melbourne said...

Interesting post, you bring up a few good things to think about. Good luck with the blog.

home businesses said...

When you want to create a dynamic link between the content of your document and the content in a Microsoft Office Excel workbook, insert the content as an object. Unlike when you paste content (such as by pressing CTRL+V), when you insert it as a linked or embedded object, you can work with it in the innovative program.

records management said...

Ahh.. Excel.. My arch enemy! thanks for the helpful post, I started using Excel a lot at work and I really need to start learning all those functions!

magento themes said...

Thanks dude for the magnificent post. Your post solved lots of my problems.

Alakmalak Technologies said...

Hello, I love reading through your blog, I wanted to leave a little comment to support you and wish you a good continuation.
website development in India

web hosting jaipur said...

But many times it happens that you may have embedded some document within Microsoft Excel but you are not able to find it again.

Web design Jaipur said...

it happens that you may have embedded some document within Microsoft Excel but you are not able to find it again

Web design Jaipur said...

My arch enemy! thanks for the helpful post, I started using Excel a lot at work and I really need to start learning all those functions!

Seo Company India said...

Wow It is nice posting. I like it. Thanks

Post a Comment