You may have a shape, text box, or image in Excel that you cannot click on or move. This often happens when objects are locked or layered behind others. The Selection Pane is the tool that lets you see and manage every object on your sheet, even if they are locked or hidden.
This article explains how to use the Selection Pane to select locked shapes. You will learn how to open the pane, identify objects, and change their visibility and order.
Key Takeaways: Selecting Locked Shapes in Excel
- Home > Editing > Find & Select > Selection Pane: Opens the panel that lists all shapes, charts, and text boxes on the current sheet.
- Click an object name in the Selection Pane list: Selects the object on the sheet even if it is locked or behind another shape.
- Eye icon next to an object name: Hides or shows the object on the sheet without deleting it.
What the Selection Pane Does in Excel
The Selection Pane is a management panel for objects. Objects include shapes, icons, text boxes, charts, and pictures. When you add these items to a worksheet, Excel stacks them in layers. The pane shows a complete list of every object on the active sheet.
A shape can become difficult to select for two main reasons. First, it might be locked via the sheet protection feature. Second, it could be placed underneath another object. The Selection Pane solves both problems. It allows you to select items by name from the list, bypassing the lock or the layer.
You do not need any special add-ins to use this feature. It is available in all modern versions of Excel for Windows and Mac. Before you start, ensure your sheet contains at least one shape or image.
Steps to Open and Use the Selection Pane
- Open the Selection Pane
Go to the Home tab on the ribbon. In the Editing group, click Find & Select. From the dropdown menu, choose Selection Pane. A new pane will open on the right side of your Excel window. - View the object list
Look at the list in the Selection Pane. Each object has a default name like “Rectangle 1” or “TextBox 3”. The list order shows the layering. The top item in the list is in front of all others on the sheet. - Select a locked or hidden shape
Click directly on the object’s name in the Selection Pane list. Excel will select that object on the sheet. A selection box will appear around it. This works even if the sheet is protected or the shape is behind another object. - Hide or show objects
Next to each object name is a small eye icon. Click the eye icon to hide that object on the sheet. Click the empty space where the icon was to make the object visible again. This is useful for temporarily removing clutter. - Change the layering order
With the Selection Pane open, use the up and down arrow buttons at the bottom of the pane. Select an object name first. Click the up arrow to bring it forward one layer. Click the down arrow to send it backward one layer. - Rename objects for clarity
Double-click an object’s name in the Selection Pane list. The text will become editable. Type a new, descriptive name and press Enter. This helps you identify objects in complex sheets.
Common Mistakes and Limitations
Selection Pane is Empty or Grayed Out
If the Selection Pane appears empty, your sheet may not contain any objects. It only lists shapes, charts, pictures, and text boxes. It does not list cells or data ranges. Add an object like a shape from the Insert tab to see it in the pane.
Cannot Move a Selected Shape
Selecting a shape is different from unlocking it. The Selection Pane lets you select a locked object. But you still cannot move or edit it if sheet protection is on. To move it, you must first unprotect the sheet via Review > Unprotect Sheet.
Objects Disappear When Scrolling
Objects in Excel have a property called “Print object” and “Move and size with cells”. If an object seems to vanish, check its formatting. Right-click the object, choose Format Shape, and go to the Properties section. Verify the options are set correctly for your needs.
Selection Methods Compared
| Item | Direct Click on Sheet | Using Selection Pane |
|---|---|---|
| Primary use | Selecting unlocked, visible objects | Selecting locked, hidden, or layered objects |
| Works on protected sheets | No | Yes for selection, no for editing |
| Visibility control | No | Yes, via hide/show eye icon |
| Object renaming | No | Yes, directly in the pane |
| Order management | Limited right-click options | Direct up/down arrow buttons |
You can now manage every object in your workbook using the Selection Pane. This tool is essential for working with complex diagrams or protected templates. For more control, explore the Format Shape pane to lock aspect ratios or anchor objects to cells. Remember that pressing the F6 key can cycle focus between the worksheet, ribbon, and panes like the Selection Pane for faster navigation.