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! :)
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: How to quickly work on shapes in Excel using the Selection Pane. This includes quickly pr...
Tutorial: How to enable the Analysis ToolPak in Excel. This is an add-in program that comes with Exc...
Tutorial: This is a simple way to get more space in Excel, reduce clutter, and streamline the inte...
Tutorial: Use the CONVERT function in Excel to switch between measurements, including distance, tem...
Tutorial: In Excel, you can add shapes, images, objects, photos, and all sorts of items to the sprea...
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)