How to select all objects (pictures and charts) easily in Excel?

You can apply the Go To command to select all objects easily. You can do it with following steps:

Step 1: Press the F5 key to open the Go To dialog box.

Step 2: Click the Special button at the bottom to open the Go To Special dialog box.

Step 3: In the Go To Special dialog box, check the Objects option.

Step 4: Click OK. Then it selects all kinds of objects in active worksheet, including all pictures, all charts, all shapes, and so on.

Easily insert multiple pictures/images into cells in Excel

Normally pictures are inserted above cells in Excel. But Kutools for Excel’s Import Pictures utility can help Excel users batch insert each picture/image into a single cell as below screenshot shown.

It seems no easy way to select all pictures except manually selecting each one. Actually, VB macro can help you to select all pictures in active worksheet quickly.

Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

Step 2: Click Insert > Module, and paste the following macro in the Module Window.

VBA: Select all pictures in active worksheet

Public Sub SelectAllPics()
ActiveSheet.Pictures.Select
End Sub

Step 3: Press the F5 key to run this macro. Then it selects all pictures in active worksheet immediately.

VB macro can also help you to select all charts in active worksheet too.

Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

Step 2: Click Insert > Module, and paste the following macro in the Module Window.

VBA: Select all charts in active worksheet

Public Sub SelectAllCharts()
ActiveSheet.ChartObjects.Select
End Sub 

Step 3: Press the F5 key to run this macro. This macro will select all kinds of charts in active worksheet in a blink of eyes.

Sometimes, you may need to delete all pictures, charts, or shapes from current worksheet, current workbook or specified worksheets. You can apply Kutools for Excel's Delete Illustrations & Objects utility to archive it easily.

1. Click Kutools > Delete > Delete Illustrations & Objects.

2. In the opening dialog box, you need to:

(1) In the Delete section, please specify the types of objects you want to delete.

In our case, we want to remove charts and pictures, therefore we check the Charts option and Pictures option.

(2) In the Look in section, specify the deleting scope.

In our case, we want to remove charts and pictures from several specified sheets, therefore we check the Selected Sheets option, and then check the specified worksheet in the right box. See left screenshot:

Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now

3. Click the Ok button.

Then all charts and pictures are removed from the specified worksheets.

Delete all Pictures easily

Delete all charts Workbooks

Delete all Auto Shapes quickly

Delete all Text Boxes quickly