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
