Remove or undo a sort on a column

In Excel Online, you can use the Undo command on the Home tab to undo any sorting you've applied to a list or a table. This example shows data in a list that was originally arranged by city in ascending order and then was sorted on population in descending order. The undo action restored the original order (city).

Undoing a sort on a range

In a table, columns have filter arrows, so you can use them to sort in addition to filtering. In the example below, notice the down arrow next to the filter for the Population column that shows it's sorted in descending order. After sorting on the City column, notice the up arrow next to the filter for City.

Just like with a range, you can undo sorting on a table by using the Undo command on the Home tab. This example shows both the result of an undo action that restores the original order, and using the filter to sort on the city.

Undoing a sort on a table

For news about the latest Excel Web App updates, visit the Microsoft Excel blog.

For the full suite of Office applications and services, try or buy it at Office.com.

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

×