Believe me, not many people do not know about this cool technique.

While sorting we may need to sort on a column in one scenario and in some cases we may require to sort multiple columns at a time.

I want to sort the sort based on the Units Sold column from largest to smallest.

If this box has ticked means, the selected data has headers otherwise; your will header will be treated as the data only.

By default, excel already selected the order a Smallest to Largest but we can change it according to our requirement.

Here employee name is one layer and department is another layer.

In this example, I have the data of sales across four regions at a different time frame.

By this sort, we easily get to know what is the highest revenue under each region.

Otherwise, our data will be shuffled and reports will go wrong.

Excel How Do You Sort From A To Z But Keep The Rows To The Left With The Sort How To Sort By

Here we discuss how to Sort by Number in Excel using practical examples and a downloadable template.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Excel For Mac How Do You Sort From A To Z But Keep The Rows To The Left With The Sort