Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I save an Excel file form an companies web site and it has the companies logo
in several different places on the spreadsheet. Is there any way to delete all of these without clicking on each one and hitting delete? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If they're the only objects on the worksheet, you could get rid of all of them
by: Edit|Goto|special|click objects hit the delete key. Supe wrote: I save an Excel file form an companies web site and it has the companies logo in several different places on the spreadsheet. Is there any way to delete all of these without clicking on each one and hitting delete? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Great! Thanks.
"Dave Peterson" wrote: If they're the only objects on the worksheet, you could get rid of all of them by: Edit|Goto|special|click objects hit the delete key. Supe wrote: I save an Excel file form an companies web site and it has the companies logo in several different places on the spreadsheet. Is there any way to delete all of these without clicking on each one and hitting delete? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
Press the [F5] key......that's a shortcut for <edit<goto Click the [special] button and CHECK: Objects Click [OK] That will select the pictures (and any other objects) Press the [delete] key Does that get rid of them? *********** Regards, Ron XL2002, WinXP "Supe" wrote: I save an Excel file form an companies web site and it has the companies logo in several different places on the spreadsheet. Is there any way to delete all of these without clicking on each one and hitting delete? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete pictures in spreadsheet | Excel Discussion (Misc queries) | |||
delete pictures with a macro | Excel Discussion (Misc queries) | |||
Macro to delete pictures ? | Excel Worksheet Functions | |||
how do I delete thousands of pictures that are somehow embedded i. | Excel Discussion (Misc queries) | |||
can't insert, delete or move pictures | Excel Discussion (Misc queries) |