Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel how do I find unformatted shapes that are invisible?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel how do I find unformatted shapes that are invisible?
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
How do I find invisible objects contributing to excel file size? | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) |