![]() ![]() 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 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |