Data Sorting in Excel - Essential Excel skills series
1. Select a cell with the data.
2. Select Home>Sort & Filter
3. Select one of the following options:
Sort A to Z - Sorts the selected column in ascending order
Sort Z to A - Sorts the selected column in descending order
Custom Sort - Sorts data in multiple columns by applying different sort criteria.
Here is how to do the custom sort option:
Select Custom Sort
Select the Column you want to sort by from the drop-down menu, then select the second column you want to sort by. Sort by Department and Then by Status, for example.
For Sort On, select Values.
For Order, select a following option: A to Z, Smallest to Largest, or Largest to Smallest.
For each additional column that you want to sort by, repeat steps 2-5.
Check the My data has headers checkbox, if your data has a header row.