Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

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

Excel Sort Shortcuts With Alt Key & Menu Key

August 23, 2016 by terp 2 Comments

Fast Excel Shortcuts For Sorting — Using the Alt Key

In an earlier post I talked about some Excel Sort Shortcuts using the Right-Click or Context Menu.

Here I’ll talk about some really fast Sort shortcuts using the Alt key, or “keyboard accelerators” or “key tips.”  As a bonus, I’ll reveal some fast ones using the Menu Key as well.

Below is a brief video showing you how fast these shortcuts are:

[Read more…]

Filed Under: Alt Shortcuts, Sort Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts, Sort

Excel Alt-A Shortcuts For Your Left Hand

March 8, 2016 by terp Leave a Comment

Alt-A Shortcuts For Lazy People — Bring ’em On

Excel’s Data tab has lots of great tools, like Filtering, Sorting, and the ability to Refresh a pivot table (among others).

So how can you access it quickly, with keyboard shortcuts?  Simple: by typing Alt-A, and then the keyboard accelerator letter for your selection.  (If you’re not familiar with Excel’s Alt shortcuts, you type the letters in succession, not all at once).

But if you’re lazy like me, you avoid moving your right hand onto the keyboard when possible (because you like it on the mouse).  This is a central principle of my whole approach to Excel shortcuts.  I will never become a keyboard-only user, because the mouse is quite often just as fast as the keyboard.  But I digress…

Once you’ve typed Alt-A, which keyboard shortcuts can you complete using only your left hand?  See the options circled in red below:

Excel-Alt-A Shortcuts

[Read more…]

Filed Under: Alt Shortcuts, Excel Shortcuts, Filter, Keyboard Shortcuts, Sort Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts, Filter, Sort

Excel Sort Shortcuts

December 8, 2015 by terp 4 Comments

Excel Sort Via The Ribbon & Quick Access Toolbar

Sorting is an essential task in Excel, and one that you might perform often, so it makes sense to become efficient at the basics.

excel-sort-shortcuts

[Read more…]

Filed Under: Sort Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts, Sort

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