Showing posts with label Pictures. Show all posts
Showing posts with label Pictures. Show all posts

Delete all pictures or charts on Worksheet

This is a tip on how you can delete all pictures and/or charts on a worksheet without having to manually select each one and delete them.
So, you can use the F5 shortcut key on Excel to open the Go To dialog box.

GoTo1
Then click on the Special button on the bottom of the dialog box to open the Go To Special dialog box.

GoTo2

Select the Objects option and click the OK button to close the dialog box. Now you have all of the objects on your worksheet selected. Check if you don’t have any more objects on your sheet that you don’t want to delete, like a company logo or something, before you press Delete key to delete all of them at the same time.