×
英语
很抱歉。本文没有你的语言版本。

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.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×