In this tutorial we will look at the tool Excel offers called Selection Pane, that you can use to manage the objects in your worksheet.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Here I have a worksheet that has 9 objects on it – some pictures, shapes, a chart, etc.:
Excel offers a tool to help you manage those images called Selection Pane. You can access it one of three ways:
1) From the Home tab, go to the Editing Group at the far right and from the drop down arrow under Find & Select you will find Selection Pane
2) You can use the keyboard shortcut Alt + F10
3) You can use the key string Alt H FD P
Any of those will bring up the Selection Pane, which can be docked or you can drag it anywhere to make it free floating:
Notice that the list shows the objects listed with a generic name to help identify the items more easily. They are also numbered based on the order they were inserted on the worksheet. If I add another object, like an arrow, notice how it adds it to the top of the list and assigns number 10:
Down the right side of the Selection Pane you will see a series of “eye” icons that you can use to hide or display any of the objects. You can also choose the Hide All or Show All buttons to affect all the objects on the worksheet:
By holding down your Ctrl key you can select multiple objects, and from there you can delete them all at once, or using your cursor movement keys, re-position them in unison.
The order they are shown on the list will also indicate how they are layered on one another if they are stacked. For example, if I have several layered on top of each other, and I want to bring the triangle, for instance, forward to the top, I can select it in the Selection Pane, and using the arrow keys at the top, bring it forward:
Hopefully you will find this tool useful in managing the objects in your worksheet.
What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!