ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Delete Multiple Pictures (https://www.excelbanter.com/excel-discussion-misc-queries/138317-delete-multiple-pictures.html)

Supe

Delete Multiple Pictures
 
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

Delete Multiple Pictures
 
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

Ron Coderre

Delete Multiple Pictures
 
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?


Supe

Delete Multiple Pictures
 
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



All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com