Quickly delete all floating picture in Excel sheet
I have a lot of photos in my Excel sheet.
I want to delete them all - currently Ctrl-A just select all cells.
How can I select all photo objects?
Solution 1:
I find a quick step as below, refered from this post
- Hit F5 to open
Goto
box - Hit `Special
- Hit
Objects
- All photo objects are now selected
We are done.
Solution 2:
Quickly -
- Hit Alt+F11 to bring up the VBE
- hit Ctrl+G to bring up the immediate window
- type
activesheet.shapes.selectall
- hit enter
- Go back to sheet and all will be selected, so you can delete OR
- If you didn't want to go back to the sheet, just type
selection.delete
and hit enter
Solution 3:
You cannot quickly select all floating pictures in an Excel sheet.
But you can do a workaround.
- Create a new sheet.
- Then use CTRL-A to select all.
- Copy all cells
- Go to the new sheet
- Paste, and verify that this is acceptable and contains everything you need
- Delete the old sheet.