Print Shortlink

Delete all pictures or charts on Worksheet (Ms Excel)

Method:1

Step 1:  Open the workbook

Step 2: select that worksheet

Step 3: hit alt-f11 to get to the vbe

step 4: hit ctrl-g  to see the immediate window

step 5:  Type this and hit enter:   Activesheet.pictures.delete

 

Method:2

Step 1:  Open the workbook

Step 2: select that worksheet

Step 3: hit alt-F5 shortcut key on Excel to open the Go To dialog box.

excel_delete

 

step 4: Then click on the Special button on the bottom of the dialog box to open the Go To Special dialog box.

excel_image

step 5:  Select the Objects option and click the OK button to close the dialog box.

step 6: 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.

Share this!!!!!!!!!!!!!!!!

Leave a Reply


four × = 16

Read previous post:
Basic DOS commands

occasionally on your Windows computer, you may need to perform a procedure by typing in commands at the 'Command Prompt'....

Close