Prev: Password Protecting a workbook
Next: / keyboard key doesn't work in Excel 2007
From: anmaka57 on 14 Apr 2010 08:55
I am sent an Excel spreadsheet each week that I copy and paste and add to a
main worksheet. The size of the file is getting huge. I discovered the
reason for the size is the many unformatted shapes in this file. I would
like to delete them. The problem is because they are unformatted, they are
invisible. I only know they are there because I happened upon them
accidently. Is there way to make all these visible so I can delete them one
at a time? Or a way to delete all of them all at once?
From: John on 14 Apr 2010 09:11
Hi
Not sure if I understand but try this : in Excel 2003 or older...
Go to Edit > Goto > Press "Special" button and then select "Objects".
HTH
John
"anmaka57" <anmaka57(a)discussions.microsoft.com> wrote in message
news:3ADC0EC1-A15D-4724-A39E-D63B1900DD0C(a)microsoft.com...
>I am sent an Excel spreadsheet each week that I copy and paste and add to a
> main worksheet. The size of the file is getting huge. I discovered the
> reason for the size is the many unformatted shapes in this file. I would
> like to delete them. The problem is because they are unformatted, they are
> invisible. I only know they are there because I happened upon them
> accidently. Is there way to make all these visible so I can delete them one
> at a time? Or a way to delete all of them all at once?

 | 
Pages: 1
Prev: Password Protecting a workbook
Next: / keyboard key doesn't work in Excel 2007