Save Hours with the Selection Pane in Excel

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.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
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.)

View Course

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: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Case-sensitive co...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
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.)

View Course