How to View the Selection Pane in Excel When there are No Visible Objects

The Selection Pane is a very useful tool in Excel that allows you to view all of the objects, shapes, charts, pictures, etc. in an worksheet. It is really easy to get there when one of these items is visible: click the item, click the Format tab that appears, then click Selection Pane.

When no objects are visible, you can still get to the Selection Pane.

Go to:

Home Tab > Find & Select > Selection Pane

Page Layout Tab > Selection Pane

Once the Selection Pane is there, you can then hide or show or select all objects as needed.

I hope this tutorial helped! Dont forget to share it with your friends! :)