How to remove a picture box from an Excel 2007 spreadsheet.


S

SMG

I cut & paste a lot of stuff into Excel spreadsheets form web pages that
include boxes or icons you either check (to update or delete), or click on
(to enter, edit or display), enter data into or hold the mouse over (to
open/display an information blurb box).

In Excel 2003 these boxes & icons paste in as picture boxes.
These boxes are not riley in any cell but kind of hover over a cell or cells
in the spread sheet, so if you highlight everything and delete it the picture
boxes move to the beginning of the rows but are not deleted.

In excel 2003 if I moved my curser over the box it gave me a 4 way arrow. If
I clicked on (select) the picture box it added 4 little circles to the
corners of the box. Then I could just hit the delete key and delete the
picture box.

In excel 2007 it dose not give me the 4 way arrow or let me click on
(select) the box. So I can not delete it.
 
Ad

Advertisements

S

Shane Devenshire

Hi,

You can add the Select Multiple Objects button to the QAT. You could have
done something similar to this in 2003, to save you time:
2007:
1. Choose Office Button, Excel Options, Customize tab. From the top left
drop down choose Commands Not in the Ribbon, scroll down to Select Multiple
Objects. Add it to the QAT and click OK
2. Click your new button and Select All, OK. And press Delete. If you want
to delete all the little buggers.
 
Ad

Advertisements

S

Shane Devenshire

Hi,

I think I will add an additional piece of info to my previous post. If the
data you copied into Excel had active X controls they won't be removed as
described previously, instead:

1. Click the Developer tab (if you don't have a developer tab choose Office
Button, Excel Options and on the Popular tab turn on Show Developer tab in
ribbon, OK
2. Activate the Developer tab and click the Design Mode button.
3. Click your Select Multiple Objects button we added in the previous
email, choose Select All, OK, and press Delete.
4. Click Design Mode to turn it off.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top