Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 698
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete pictures in spreadsheet seedman Excel Discussion (Misc queries) 4 July 30th 06 04:21 PM
delete pictures with a macro Noel Rietman Excel Discussion (Misc queries) 1 March 20th 06 04:43 PM
Macro to delete pictures ? Steve Excel Worksheet Functions 8 October 18th 05 10:09 PM
how do I delete thousands of pictures that are somehow embedded i. Jim Harris Excel Discussion (Misc queries) 4 February 25th 05 02:24 PM
can't insert, delete or move pictures parker Excel Discussion (Misc queries) 1 February 18th 05 01:03 AM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"