Buzz
While using Excel, entering data or performing calculations may result in unordered data. Sorting entered and processed data is crucial for easy searching and editing. Excel supports sorting tools for customizable data sorting options. You can use the sorting tool to arrange data within your Excel document.
This article guides you on how to sort data in an Excel 2010 spreadsheet.
Step 1: Select the data range you want to sort, then go to the Home tab and choose Sort & Filter, and select the type of sorting you prefer.
- If you wish to sort a column of text data, when choosing Sort & Filter, you will have sorting options: Sort A to Z (sort from A to Z), Sort Z to A (sort from Z to A).
+ If you choose Sort A to Z, the data will be sorted as follows:
+ If you choose Sort Z to A, the data will be sorted as follows:
If you are sorting a column of numerical data, then when selecting Sort & Filter, you will see sorting options: Sort Smallest to Largest (sort from smallest to largest) and Sort Largest to Smallest (sort from largest to smallest).
+ If you select Sort Smallest to Largest, the sorted result will be as follows:
+ If you choose Sort Largest to Smallest, the result after sorting will be:
Step 2: You can customize the sort by selecting the data range to be sorted, choosing the Home tab -> Sort & Filter -> Custom Sort.
In the Sort dialog, you choose some information:
Choose the column you want to sort.
Sort On: Decide on the aspect to base the sorting.
Order : Select the sorting order, either ascending or descending, A -> Z or Z-> A…
Then press OK to execute the sorting.
The outcome will be arranged according to your preferences.
For Excel 2007 or Excel 2013 versions, you follow a similar process. Now you know how to organize data in Excel. Wishing you success!
