Save Hours with the Selection Pane in Excel

Edit
Add to Favorites
Author: | Edits: don

How to quickly work on shapes in Excel using the Selection Pane.

This includes quickly preventing all shapes in a worksheet from resizing when columns or rows are resized.

This will save you hours of time when working with many shapes across many spreadsheets.

Shapes include many objects in Excel:

  • Charts
  • Pivot Charts
  • Slicers
  • Timelines
  • Buttons
  • Icons
  • Images
  • Almost everything else that overlays cells in the worksheet.

Question? Ask it in our Excel Forum


Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Excel File
Similar Content on TeachExcel
How to View the Selection Pane in Excel When there are No Visible Objects
Tutorial: The Selection Pane is a very useful tool in Excel that allows you to view all of the objec...
Print Preview Screen Display for The Current or Selected Worksheets in Excel
Macro: This free Excel macro allows you to display the print preview screen or window for the cur...
CHOOSE Function in Excel
Tutorial: Return a value from a list of values. This is like a mini-lookup function that contains a...
Print Selected Worksheets in Excel
Macro: This free excel macro will print all selected worksheets in Excel. If there are no ot...
Edit Multiple Worksheets at Once in Excel
Tutorial: How to edit multiple worksheets at the same time; this includes adding, editing, deleting,...
Exact Function - Case Sensitive Comparison in Excel
Tutorial: Case-sensitive comparison of two text strings or values in Excel. To do this, we use the E...