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

Select all objects in active worksheet
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.

Select all pictures in active worksheet

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.

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.

Select all charts in active worksheet

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.

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.