There’s a ghost in your Excel spreadsheet. It’s that invisible text box you keep accidentally clicking, or the chart that refuses to be selected. Instead of losing your mind, use the Selection Pane, the hidden sidebar that reveals every object on your sheet so you can manage them with ease.
How to open and use Excel’s Selection Pane
The Selection Pane in Excel displays anything on your sheet that doesn’t live inside a cell, such as charts, illustrations, shapes, text boxes, and form controls.
It’s hidden by default, and unless you’re looking for it, you’re unlikely to stumble upon it. However, once opened, it acts as a crucial, dedicated sidebar that tracks every object floating above your cell grid.
If you prefer using your mouse, head to the “Home” tab, expand the “Find & Select” drop-down menu, and click “Selection Pane.”
If you already have an object selected, open the “Shape Format” or “Picture Format” tab and click “Selection Pane.”
The quickest route, however, is the Excel keyboard shortcut Alt+F10.
The Selection Pane docks to the right of your screen by default. To turn it into a floating window that you can move to a more convenient place, click and drag the pane’s header.
Manage your layers and stacking order
In Excel, every object you add sits on its own layer above the cell grid. When these objects overlap, they’re stacked like sheets of paper, making the objects beneath the top one harder to click. The Selection Pane solves this by letting you interact with layers directly without having to move anything out of the way.
The visual connection
When you click a name in the sidebar list, Excel highlights that specific object in the spreadsheet with a bounding box. Similarly, when you select an object on the grid, its name is highlighted in the sidebar.
This is the fastest way to identify which objects are useful, visual elements, and which are ghost objects you can delete.
How to reorder layers
The order of the names in the Selection Pane matches the physical stack on the grid—the object at the top of the list is at the very front of your spreadsheet (the one you inserted most recently), and the object at the bottom is behind everything else (the one you inserted first).
Instead of right-clicking an object on the grid and selecting “Bring to Front” or “Send to Back,” click and drag an object name up or down the list to move it forward or backward in the stack.
Alternatively, select an object name and use the arrows at the top of the pane.
How to Use the Navigation Pane in Microsoft Excel
You don’t have to struggle to find your sheets, tables, charts, or objects. Do it all in one accessible pane.
Hide objects to access the grid below
One of the most annoying things about using large charts or background shapes in Excel is that they physically block the cells behind them. If you need to edit a formula or a value tucked underneath, you have to physically move the object, make the edit, and move the object back again.
The Selection Pane offers a much cleaner workaround: the “eyeball” icon.
Toggle individual visibility
To the right of every object name in the Selection Pane, you can see an icon that looks like an open eye.
When you click this icon, the relevant object instantly vanishes from the grid. But don’t worry—it hasn’t been deleted; it’s just invisible.
Click the icon again to bring it back to exactly where it was.
Hide all the objects simultaneously
At the top of the Selection Pane, there are two useful buttons: Hide All and Show All.
If you’re performing heavy data entry, and the spreadsheet is cluttered with icons, text boxes, and images, clicking “Hide All” clears the desk instantly, leaving you with a clean, standard spreadsheet grid. Once you’ve finished with your data work, click “Show All” to restore all your visuals.
Rename and group objects for better organization
By default, Excel assigns generic names like “Rectangle 4” or “Textbox 12,” and these names tell you nothing. Luckily, the Selection Pane lets you rename them.
How to rename objects
To assign a custom name to an object, double-click it in the Selection Pane, type the new, descriptive name, and press Enter.
Taking this step has two major benefits:
- Easier auditing: When you use the eyeball icon or reorder layers, you’ll know exactly which objects you’re interacting with.
- VBA and Power Automate: If you write macros or use automation, having specific names for your objects is essential. Referring to “Sales Trend Chart” in your code is much more reliable than referring to “Chart 2.”
I Always Name Ranges in Excel, and You Should Too
Tidy up your Excel workbook.
Simplify your list by grouping
If your spreadsheet has a header with a logo, a title, and a background shape, your Selection Pane list can get crowded quite quickly. In these cases, you should group the objects to treat them as a single unit.
Instead of selecting objects on the grid itself, where you might accidentally click a cell and lose your selection so far, select them in the Selection Pane list simultaneously by holding Ctrl as you click them. Then, in the Shape Format or Picture Format tab, click “Group,” or press Ctrl+G.
If you’ve selected different types of objects (like a shape and a picture), you can use either tab—both contain the same Group tool.
Finally, rename the group by double-clicking it in the sidebar and typing a descriptive label.
The power of subgroups
Excel’s Selection Pane also allows for nested grouping, which is great for complex layouts. For example, you can group two shapes together, and then select that group plus a separate text box to create a new, larger group.
In the Selection Pane, this appears as a hierarchy: the main group has an arrow you can expand to see the nested text box and the subgroup of shapes.
Always rename a group before you add it to a larger group. While you can easily rename the top-level group at any time, in some versions of Excel, the nested subgroup name is locked as soon as you create it. So, if you leave it as “Group 1,” this confusing default name might stay intact unless you ungroup everything and start over.
While the Selection Pane in Excel is essential for managing floating objects, you can avoid a cluttered list by inserting your pictures directly into cells. This locks your images to specific data points without overlapping other objects or burying your cells, leaving the Selection Pane free for the charts and shapes that truly need their own layer.
- OS
-
Windows, macOS, iPhone, iPad, Android
- Free trial
-
1 month
Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more.
