Sort data in a table

You can sort a range of cells, but did you know that a table is ready for sorting with its built-in arrows? You can quickly sort your data, and it lets you filter too.

  1. If your data isn't already in a table, it's quick to create a table. This will automatically add the sort arrow at the top of the columns.

  2. Click the sort arrow at the top of the column you want to sort on, and pick the sort order you want.

    Sorting a table column

  3. To undo a sort, use the Undo button on the Home tab.

    Undo button, on the Home tab

Note: In Excel Online, you can sort only a single column ascending (A to Z) or descending (Z to A); multi-column and custom sorting aren't supported yet.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.