You can sort data in Excel using simple one-click buttons for quick sorts or the full Sort dialog for more advanced multi-column sorting.

Basic single-column sort

To quickly sort a list by one column:

  1. Select any cell in the column you want to sort (make sure your data has no completely blank rows in the middle).
  1. Go to the Home tab and click Sort & Filter, or go to the Data tab and look for Sort & Filter / Sort.
  1. Choose one of:
    • Sort A to Z for text (A–Z) or numbers (smallest to largest).
 * **Sort Z to A** for text (Z–A) or numbers (largest to smallest).

Excel automatically applies the sort to the whole surrounding range so rows stay together, as long as there are no gaps splitting the dataset.

Sorting a full table properly

To avoid scrambling rows, it’s safer to select the whole table first:

  1. Click any cell in your data, then press Ctrl + A (or drag to select your entire table).
  1. Go to the Data tab and click Sort.
  1. In the Sort by dropdown, choose the column you want to sort (for example, “Name” or “Amount”).
  1. Under Sort On , leave Cell Values selected for normal sorting by the values in the cells.
  1. Under Order , choose:
    • A to Z / Z to A for text.
    • Smallest to Largest / Largest to Smallest for numbers.
    • Oldest to Newest / Newest to Oldest for dates.
  1. Click OK to apply.

This is the core “how to sort data in Excel” workflow for most everyday tasks.

Sorting by multiple columns (advanced)

If you want a more structured sort, like “Department A–Z, then Name A–Z within each Department”:

  1. Select your entire dataset.
  2. Go to Data → Sort to open the full Sort dialog.
  1. Set your first level :
    • Sort by: the main column (for example, “Department”).
    • Sort On: Cell Values.
    • Order: A to Z or Z to A.
  1. Click Add Level to add a secondary sort:
    • Then by: second column (for example, “Last Name” or “Agent”).
    • Choose the order again (A–Z, Z–A, Smallest to Largest, etc.).
  1. Add more levels if needed (for example, Department → Last Name → First Name).
  2. Click OK to sort; Excel will sort by the first column, and within each group it will sort by the next column, and so on.

This is called multi-level sorting and is great for reports, sales lists, or any grouped data.

Custom and special sorts

You’re not limited to A–Z or numeric order:

  • Custom lists : You can define your own order (for example, “High, Medium, Low” or “S. County, Central, N. County”) and sort according to that instead of alphabetically.
  • In the Sort dialog:
    • Under Order , choose Custom List… , type your sequence (e.g., High,Medium,Low), add it, then select it as the sort order.

You can also sort by formatting (like color or icon) using the Sort On options, then selecting “Cell Color” or “Font Color” in newer Excel versions.

Quick tip with filters

If you turn your list into a table or use filters, each column header gets a dropdown that includes sort options:

  1. Select your data and press Ctrl + Shift + L to toggle filters on.
  1. Click the dropdown arrow in a header (for example, “Name”).
  2. Choose Sort A to Z or Sort Z to A right from the dropdown.

This gives you sorting and filtering together, which is handy for large data tables.

TL;DR : Select your data, go to the Data tab, click Sort , pick the column and order (A–Z, Z–A, Smallest to Largest, etc.), and use Add Level if you need multi-column sorting.