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

How do you select all objects, such as all pictures, and all charts? This article is going to introduce tricky ways to select all objects, to select all pictures, and to select all charts easily in active worksheet in Excel.

Select all objects in active worksheet

Select all pictures in active worksheet

Select all charts in active worksheet

When you need to edit, resize, or delete all pictures, delete all charts, and object, tasks go easy before you can select all of them.

Select all objects in active worksheet

Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

Learn more Free download

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.

Related Articles:

Delete all Pictures easily

Delete all charts Workbooks

Delete all Auto Shapes quickly

Delete all Text Boxes quickly

Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.