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.

7 comments:

Webjen said...

Great Post!!!

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

Anonymous said...

Thank you! Very helpful site!

Anonymous said...

Fantastic - that one puzzled me forever!

GeorgeK said...

What if the Objects option is grayed-out in the Go To Special dialog?

Website Development In India said...

I actually enjoyed reading through this posting.

Post a Comment