Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

Use The Quick Access Toolbar (QAT) To Create Custom Excel Shortcuts

November 11, 2015 by terp Leave a Comment

What and where is Excel’s Quick Access Toolbar?

If you have certain formats that you use a lot but for which there’s no easy shortcut, you can put them on your QAT or Quick Access Toolbar.  This is the skinny toolbar that by default sits above the Ribbon – but that I move to below the Ribbon for easier access – see below:

excel-quick-access-toolbar-qat

You’ll notice that, while I use Bold, Italics and Underline a lot, I don’t have them on the QAT.  Why?  Because I already have Ctrl-2/3/4 or B/I/U.  If I change cell colors and font colors a lot, I can put those on the QAT (as I’ve done above).  This way they’re within easy reach no matter which Ribbon tab I’m on.

But another benefit of putting them on the QAT is that you give yourself the option of basically creating your own new customized keyboard shortcuts.  If you hit the Alt key you’ll see the Ribbon and the QAT light up with keyboard shortcuts:

excel-quick-access-toolbar-qat-shortcut-key-tips

How do I create my own custom Excel shortcuts using the Quick Access Toolbar?

The ones on the left of the Quick Access Toolbar are fairly easy to type in with your left hand – e.g., Alt-1 for Commas.  I like to have my numbers formatted with commas but no decimals, and the fastest way I’ve found is to place the Comma and Decrease Decimal icons in the number 1 and number 2 positions so I can just type Alt-1-2-2 to (1) add the Comma formatting (which also puts in two decimals) by typing “1” and then (2) remove the two decimals by typing “2” twice.

Unlike with the Ctrl shortcuts, Alt shortcuts don’t require you to keep the key depressed (though you can if you want).  For example, to use Comma formatting you can hit Alt-1 (press Alt and then, while keeping it down, type “1” – the same way you would type Ctrl-1 for the Format Cells dialog box) – or you can let go of Alt before you type “1” (using the QAT in the illustration above).  In my number formatting example (comma and no decimals) I can go faster by keeping the Alt key depressed, as this saves me from re-typing Alt for each shortcut – meaning I type Alt-1-2-2 instead of Alt-1, Alt-2, Alt-2.

Depending on the keyboard you might be able to type Alt-1 through Alt-6 without lifting your left hand, meaning the 1 though 6 positions on the QAT are prime real estate for creating your own shortcuts.  I recommend that you reserve these slots for tasks you will use frequently and that have no better shortcut alternatives.

If you have a short-term project with intensive usage of a certain Excel task – say, wrapping text or merging and centering – you may want to place the shortcut for this command on the far left on a temporary basis.  In effect, you’ll have a temporary custom shortcut.  When the project is done, you can move it back to its “normal” position.   Don’t be afraid to modify the Quick Access Toolbar as needed to save you time.  It’s fast and easy.

Filed Under: Format Cells, Keyboard Shortcuts Tagged With: Excel Keyboard Shortcuts, Excel Shortcuts, Format Cells, Quick Access Toolbar - QAT

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel