Slider

How to Sort Data in Excel by Single Condition

Date:2019-7-9 Author:Cordelia

The content you input in Excel sheets manually may be unordered and messy, which is not conductive to view or comparison. It’s necessary to sort the data especially when you are editing a ranking table.

Sorting refers to rearranging one or several fields in the table according to a specific rule. Let’s see how to achieve it in Excel 2016.

Assuming I’m editing a grade table as below, and I want to sort these data in descending order. What can I do?

How to Sort Data in Excel by Single Condition

It’s quite simple. Just place your cursor at any of the cells in Grade column, then switch to Data tab, click the icon of Sort Largest to Smallest in Sort & Filter section.

How to Sort Data in Excel by Single Condition

Now the data has been sorted in descending order.

How to Sort Data in Excel by Single Condition

If you want to sort these data in ascending order, then click A-Z icon which means Sort Smallest to Largest.

How to Sort Data in Excel by Single Condition

If you find our content useful, donations are always welcom. we'll keep going and hold more giveaways in the future.

Windows 10: Run Troubleshooter to Fix Network Connection Problems
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *