In this topic, you will Sort data in Excel.


  1. Sorting One Column

    Step 1
  2. Click the down arrow, located in the column header, of the column to be sorted.

    Step 2
  3. Select the Sort order, ascending (A-Z) or descending (Z-A).  In this example, click Sort A to Z.

    Step 3
  4. The data has been sorted, in ascending order, by City.

    Step 4
  5. Sorting Multiple Columns


    You can sort up to 64 fields at one time.

    Step 5
  6. Click the Data tab.

    Step 6
  7. Click the Sort... button.

    Step 7
  8. Click the Add Level button to add additional levels.

    Step 8
  9. Under Column, select the fields you want to sort. 

    Step 9
  10. Click the State list item.

    Step 10
  11. Click the list.

    Step 11
  12. Click the Last Name list item.

    Step 12
  13. Click the OK button.

    Step 13
  14. The data is first sorted by State, then by Last Name.

    Step 14

After completing this topic you are able to sort data in Excel.