Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TomCon - 02 Apr 2008 21:08 GMT
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 - 02 Apr 2008 21:31 GMT
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
[quoted text clipped - 9 lines]
> Thanks,
> tom

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.