They derive from the Home menu - see graphic below - and therefore begin with Alt-H instead of Alt-A. If you have both hands on the keyboard, you might like these instead - but they’re about the same speed.
#Sort excel for mac full#
Here are the full shortcuts - and they use only your left hand (you type one key at a time, releasing each one before typing the next):Ĭustom Sort Dialog Box: Alt-A-S-S (no, that’s not a joke…)Īlt-H Sort Shortcuts - Using The Home Tab So Here Are The Full Alt-A Sort Shortcuts To pull off the shortcut, after typing Alt-A to get to the Data tab, you just type in the final keys of your selection. Here’s a picture of the Sort (or Custom Sort) dialog box: SS for Sort (brings up the sort dialog box - called “Custom Sort” when you access it via right-clicking).SD for Sort Descending - sorts in descending order.
SA for Sort Ascending - sorts in ascending order.That takes me to the Data tab (see below), where I see three sort options and their corresponding keyboard accelerators: Since the Sort options are available on the Data tab, I’ll hit the A key after I hit (and release) the Alt key. (In the case of the Quick Access Toolbar, the effect is as if you clicked on the QAT icon). Those keys are called “keyboard accelerators.” When you type one, you go to the ribbon tab it’s centered over - just as if you clicked on that tab with your mouse. When you hit the Alt key, your keyboard lights up with a bunch of letters called “key tips” - see below.
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.īelow is a brief video showing you how fast these shortcuts are: In an earlier post I talked about some Excel Sort Shortcuts using the Right-Click or Context Menu. Fast Excel Shortcuts For Sorting - Using the Alt Key
0 kommentar(er)
