MS Excel Tip — Make Your Quick Access Toolbar Even Quicker!
Use the ALT Keyboard Shortcuts
Sometimes you need the obvious pointed out to you. Shout out to Blake Galey (LinkedIn profile) for pointing out this tip!
ALT + [shortcut] invokes the Quick Access Toolbar item.
Here’s The Tip
Place your most frequently used QAT shortcuts at the very start of the toolbar!
The shortcuts start with number 1 — so, ALT + 1 invokes the first item on your QAT toolbar.
I modified my QAT to place SIX (I can actually remember and use 6 shortcuts … 😬) items right at the start.
ALT + 1 = Format Painter
ALT + 2 = Adjust All Column Widths Automatically (via macro in my personal.xlsb)
ALT + 3 = Refresh all Data Connections (Queries and Pivot Tables) in spreadsheet
ALT + 4 = Open Print Page Dialog Box
ALT + 5 = Open Name Manager dialog box
ALT + 6 = Activate Filters (Turn On / Turn Off)
What items on your QAT qualify to be right up front?
Let me know in the comments!
About Don
“It’s time for DIFFERENT”
Don is passionate about helping professionals and organizations keep up, develop and adapt to the changing business world that we operate in.
