Here’s our hack to getting that much closer to freeing the mouse in Excel ?
We all have our go-to little mouse clicks in Excel. For some of us it might be clicking to apply a specific border style and for others it could be constantly turning numbers into percentages for presentations. Regardless – there are buttons that we are forced to click because we only memorized Ctrl+C and Ctrl+V (maybe Ctrl+B, but like, why?).
Time to stick this hack in ?? your ?? fanny-pack ??! We love this easy modification to set up a shortcut to a shortcut.
(Don’t worry! Scary macros for another day ??)
We are going to show you how to:
1: Customize your Quick Access Toolbar with your own favorite shortcuts. 2: Use keyboard shortcuts for your new customized shortcuts (shock & awe).
Customizing your Quick Access Toolbar (‘QAT’ – pronounced “kahxth,” surely….)
- Click on the small down arrow to the right of the last icon on the Quick Access Toolbar. ?
- A drop-down will appear, click on the 2nd to last option titled “More Commands”
- A pop-up will come up titled “Excel Options”. In the left column are all of your choices for functions to add to your Quick Access Toolbar. The right column shows you the functions and their order on your Quick Access Toolbar.
Understanding the Quick Access Toolbar Shortcuts
Now, you have shortcuts to your most used icons. You can easily just click on the icon in your Quick Access Toolbar and apply the function. But as you know, we are looking for a shortcut within a shortcut… cue the Extra lights! ✨✨
Have any additional questions about a data hack? Feel free to email us at hello@dumbblondedata.com and we will work hard to help you!
