View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default how to delete multiple autoshape or objects in excel

Hi Ron,
you should be able to select them all in one go by first clicking on
the selection arrow that is on the Drawing tool bar, then starting off
anywhere on the sheet that is above and to the left of all the shapes,
left click (hold down mouse button) then drag to the right then down so
that the selection rectangle (dotted lines) contains all of the shapes
to be deleted. Each selected shape will then have visible handles and
pressing the delete key will delete them.
If the Drawing toolbar is not visible then go ViewToolbarsDrawing.
The selection arrow is just to the right of the Draw button.

Ken Johnson