View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default How can I delete a series of autoshapes in Excel in one hit?

On Dec 5, 5:30*am, Ian Richards <Ian
wrote:
I have a series of pictures in Excel made up of lines and autoshapes and want
to delete them in one hit rather than doing this individually. This is to
save time. Is there any way to do this?


F5 only if you want to select every single object in the worksheet. If
only some of your objects need to be deleted, CTRL-click to select
multiple. If you select several objects when they are first created
and Group them, they will be easier to select later to move or delete.

You probably have to Right-click on selected objects to Group them.
I'm not sure where else that particular Group command is located.