Save Hours with the Selection Pane in Excel - Excel Quickie 80

Excel Quickie Playlist: • Excel Quickies
Make Cool Buttons for Excel: • Make Cool Buttons for ...
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.
Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
Slicer Power Analysis in Excel: • Slicer Power Analysis ...
Excel Courses:
VBA/Macro Course: www.teachexcel...
Building Professional Forms: www.teachexcel...
TeachExcel.com
#msexcel #excelquickie #tutorial

[@simona7517]

Wow, fantastic tip, surprised I didn't know this before. Thanks!!

[@wayneedmondson1065]

Cool! Also worth mentioning that if you have multiple objects on a worksheet, you can select any one and then press TAB to select the next, TAB again for the next, and so on. Further, if you click on one object and then press CTRL+A, it will select all the other objects. You can also do the same via CTRL+G, Special, Objects, OK. So, if your aim is to execute a common setting across all objects, click (on one) and CTRL+A is a pretty fast way to select all and then move on to your formatting. Thanks for sharing your tips :)) Thumbs up!!

[@gerbherb8215]

Nice clear and calm tutorial. TIP: instead of remembering "Page Layout > Selection Pane", try remembering Alt + F10 to turn the selection pane on and off.

[@stoleethatsme]

Thank you for posting this video!

[@nadermounir8228]

Thank you very much for this great video 📹

[@gregorytaylor2749]

Great tip! Thanks.

[@hsaghbari]

Great tip Thanks

[@mymatemartin]

Very handy

[@carlo_migliari81]

Very useful, isn't it