How to Select Objects / Pictures in Excel & Google Sheets

This tutorial demonstrates how to select objects or pictures in Excel and Google Sheets.

 

 

The Selection Pane

1. In the Ribbon, select Home > Editing > Find & Select > Selection Pane.

 

 

2. Click on one of the object names to select that object.

 

 

3. Then, holding down the CTRL key, click on all the object names of the objects you wish to select.

 

 

4. To deselect an object, keep the CTRL key depressed and then click again on that object name.

 

 

5. Alternatively, you can deselect all objects by clicking back in the Excel sheet.

6. Click the Close button on the selection pane.

 

 

Select Objects Mode

1. In the Ribbon, select Home > Editing > Find & Select > Select Objects.

 

 

2. Your mouse pointer will then change to an arrow. To select the objects you require, click and hold the mouse button down while dragging a rectangle type area over the objects.

 

 

3. Release the mouse to select the objects.

4. To switch this mode off, click once again on Select Objects in the Find & Select drop down menu on the Ribbon.

Go to Special Menu

1. In the Ribbon, select Home > Editing > Find & Select > Go To Special.

 

 

2. Click Objects and then click OK.

 

 

3. All the objects in your current worksheet will be selected.

Keyboard Shortcut

You can also select multiple objects in your Excel sheet by clicking on one object and then, while holding down the CTRL key, click on the rest of the objects you wish to select.

How to Select Objects / Pictures in Google Sheets

In Google Sheets, you can select multiple objects by selecting one object and then, while holding down the CTRL key, click on the rest of the objects you wish to select.