any way to erase all "objects" within a selected cell range

[TomCon]

I pasted in a table from a web page. Wanted to to work with the numbers in
the web table, in Excel. Fine! But, it turns out there were also a bunch
of little objects in the web page. Totally small, a few pixels i think.
You don't even see them on the sheet, but i noticed them when mousing over,
and the mouse changed either to the 4-way pointer, or to a pointing hand.
Clear...all does not clear these objects; just clears the cells. So, i
moused [very slowly] around the cell area where i had done the paste, and
one by one, right clicked and deleted each one. Very tedious! Is there a
way to select a cell range, and tell Excel to remove all obejcts on the
sheet in that range?

Thanks,
tom

 

[Dave Peterson]

Can you get rid of all the shapes on the worksheet?

Edit|goto|special|objects
and hit the delete key.

You could also select the objects in a listbox by adding this to your favorite
toolbar (QAT???):

Tools|Customize|Commands tab|Drawing Category (xl2003 menus)
Drag "Select Multiple Objects" to your favorite toolbar.

I pasted in a table from a web page. Wanted to to work with the numbers in
the web table, in Excel. Fine! But, it turns out there were also a bunch
of little objects in the web page. Totally small, a few pixels i think.
You don't even see them on the sheet, but i noticed them when mousing over,
and the mouse changed either to the 4-way pointer, or to a pointing hand.
Clear...all does not clear these objects; just clears the cells. So, i
moused [very slowly] around the cell area where i had done the paste, and
one by one, right clicked and deleted each one. Very tedious! Is there a
way to select a cell range, and tell Excel to remove all obejcts on the
sheet in that range?

Thanks,
tom