Using VBA macro will help you delete all pictures in active worksheet quickly.ġ. This method will only delete pictures in active worksheet. If you do not want to delete other objects, you have to unselect other objects before pressing the Delete key.Ģ. This method will select all objects in active worksheet, such as pictures, charts, shapes etc. And then click OK button, all pictures are selected in active worksheet, press Delete key to delete all of them.ġ. Click the Special button, and get into Go To Special dialog box，then check the Object option. Press F5 key to open the Go To dialog box in Excel.Ģ. Work goes easy if we can select all pictures before deleting them.ġ. Using Go To command can select all pictures in active worksheet. The following tricks may ease your work to delete all pictures:ĭelete all pictures in active worksheet with Go To commandĭelete all pictures in active worksheet with VBAĭelete all pictures or other objects in active worksheet / whole workbook with Kutools for Excel If you want to delete all pictures from Microsoft Excel, it may be time-consuming to select each picture and delete them one by one. How to delete all pictures or other objects in Excel easily?
0 kommentar(er)
