Therefore, I have a third method, another hybrid shortcut, which I find slightly faster. The second shortcut (using the Menu Key) also requires me to put my right hand on the keyboard, which I find disruptive as well (since my right hand is usually on the mouse). The first one requires me to type “O” either by moving my left hand all the way across the keyboard, or by taking my right hand off the mouse, which is also disruptive. I’m not entirely happy with either of these shortcuts.
Sort Smallest to Largest (keyboard): MK-O-S (MK stands for Menu Key) Therefore, a good keyboard-only shortcut for sorting smallest to largest is as follows: If you want to do this fully with the keyboard (and not use your mouse at all), just remember that hitting the Menu Key (typically somewhere to the right of the spacebar) does the same as right clicking. Sort Smallest to Largest (hybrid): RC-O-S (RC stands for Right Click) Therefore, after right-clicking, you can simply type “O” and then “S” to select “ Sort Smallest to Largest.” I call this a “hybrid” shortcut because it combines both the mouse and the keyboard: While O is the shortcut key for “S ort” in the main context menu, S is the shortcut key for “ Sort Smallest to Largest” in the sub-menu. Put another way, O is the shortcut key to bring up the sub-menu (note: sometimes other menu options share the same shortcut letter - in which case you’ll need to keep hitting that shortcut letter until you get the choice you want, and then simply hit the spacebar to select it). Notice in the left context menu above that the letter O is underlined in “S ort.” This means that if you type “O” the sub-menu will appear. One way is to simply click on the menu options with your mouse, but here are some other methods: To provide just one example of how you can derive some shortcuts, let’s say you just want to sort from smallest to largest (the first option). Excel Sort Shortcuts Using The Context Menu Once the context menu above appears, you can use either the mouse or the keyboard to make your menu choice. Following these two steps brings up the menu below, which includes multiple quick sort options: Excel Sort Using The Mouse & The Context MenuĪnother option is to (1) right click within the range that you want to sort in order to bring up the context menu, then (2) select the “Sort” option in the context menu. Here’s the Data Tab where at least you don’t have to click down another level (here I’m hovering over the “Sort A to Z” icon):īecause I use sorting fairly frequently, and I’m not happy with the Ribbon placement, I put it on my QAT to make it more accessible (as you can see above). Here it is on the Home Tab (far right end of it), where you actually need to click on the Sort & Filter drop-down to get the sort options: That post contains a video within it - or on my YouTube channel. Note: See my other post on Excel Sort Shortcuts Using The Alt and Menu Keys. Sorting is an essential task in Excel, and one that you might perform often, so it makes sense to become efficient at the basics.ĭespite being a common task, Excel puts the sorting icons slightly out of the way - on the far right side of the Home tab and in the middle of the Data tab. Excel Sort Via The Ribbon & Quick Access Toolbar
0 kommentar(er)
