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. 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

  1. 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.

Connect with an expert
Contact us
Expand your skills
Explore training

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.

×