Sort Data in Excel
You can sort your Excel data by one column or multiple columns. You can sort in ascending or descending order.
Sort by One Column
To sort by one column in Excel, execute the following steps.
1. Click any cell in the column you want to sort.
2. To sort in ascending order, on the Data tab, in the Sort & Filter group, click AZ.
Result:
Note: to sort in descending order, click ZA.
Sort by Multiple Columns
To sort by multiple columns in Excel, execute the following steps.
1. On the Data tab, in the Sort & Filter group, click Sort.
The Sort dialog box appears.
2. Select Last Name from the 'Sort by' drop-down list.
3. Click on Add Level.
4. Select Sales from the 'Then by' drop-down list.
5. Click OK.
Result: records are sorted by Last Name first and Sales second.
If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.
