Can’t Remove Sort in Excel? Restore the Original Order

Clearing a sort in Excel won't return the rows to their original order. Try Undo while that sort remains in history. Otherwise, you'll need a stored sequence column, an earlier copy, or a backup containing that order.

A filter is different: clearing it shows hidden rows, but doesn't reverse sorting. That's why removing a sort symbol or deleting its rule can leave every row exactly where it is.

1. Undo the sort while its history is available

If the workbook is still open, check the Undo control or press Ctrl+Z to reverse the latest undoable action. On a Mac, use Command+Z. If sorting was the latest action, its previous row order should return.

If you've edited cells since sorting, those newer actions come first in the undo history. Check what Undo will reverse before continuing, particularly if those edits contain work you need to keep.

Diagram separating Excel Undo, an original-order column and an earlier copy as three ways to recover row order

Saving doesn't automatically make Undo unavailable in desktop Excel. The Office undo instructions explain that saved changes can still be undone within the available history.

That corrects a misleading point in the old Excel 2010 discussion, where an accepted reply treated saving as the cutoff. Check whether the sort is still in Undo history, even if you've clicked Save.

After recovery, compare familiar records and their neighboring values. Names, dates, and amounts should still belong together. Reversing a single-column sort matters more than hiding its symbol.

When Undo is unavailable or no longer reaches the sort, don't keep reversing unrelated work. Move to a stored order value or an earlier copy. Excel can't infer the original sequence from a sort indicator alone.

2. Sort by an order value that already existed

Look for a column that preserves the intended sequence, such as a record number or a reliable creation date. It must have existed before the unwanted sort, and its values must actually represent the order you want.

An employee ID isn't automatically a joining-order number. Check a few known records before using it. Likewise, a date column shared by many records may restore groups without recovering the exact order inside each group.

Select all columns belonging to the records. In Data > Sort, choose the sequence column under Sort by and its ascending or oldest-first order. Check the header setting before applying it.

When Excel offers to expand your selection, keep the related columns together. Sorting just the original-order numbers while leaving names and amounts in place would break the very relationship you're trying to recover.

The Excel date-sorting guide covers a date-based order. Use that only when the date represents your intended sequence, rather than selecting any available date because the original order is missing.

After sorting, compare recognizable records from both ends of your list. If the sequence is correct, save a copy under a clear name. If none of your existing columns can restore the old order, try an earlier version next.

3. Recover the sequence from an earlier copy

Keep the current workbook before opening backups. An earlier copy may contain the right row order but lack later corrections, formulas, or new records. Restoring it over your current file can trade one problem for another.

For a OneDrive or SharePoint workbook, open the file's Version History controls. Inspect a version from before the sort and confirm it contains the sequence you need before choosing any restore action.

For a file on a company server, ask IT for a backup from before the sort. Give them the full file path and the approximate date and time. Backups on the server are different from recovery options on your own computer.

In the original Excel 2010 report, the asker found no available previous versions and had a month-old copy with substantial later work missing. They didn't report recovering the order from a backup.

If the older workbook has the right sequence, it can serve as a reference instead of replacing the current data. Match records by a unique identifier, preserve the old sequence in an order column, and check unmatched new records separately.

For an unfamiliar sheet, compare copies with IT or the person who manages it. Duplicate names aren't safe identifiers. Match by reliable IDs to keep current amounts with the right people while recovering their sequence.

4. Clear filters only when rows are hidden

If the problem is missing records rather than changed order, click inside the list and choose Data > Clear in the Sort & Filter group. That removes filtering so records excluded by filter conditions can show again.

Removing filter buttons through Data > Filter also doesn't reconstruct a previous row order. Those buttons and indicators show the available controls or current sort. They don't store the sheet's earlier row order.

Microsoft says clearing a sort won't restore old row order. Deleting a sort level changes the rule, not the arrangement that existed before the rule ran.

The Excel filtering guide covers narrowing a list without rearranging its records. Choose filtering when you want to show a subset while keeping the list's stored sequence intact.

5. Preserve the order before the next sort

Once you've recovered the intended sequence, add an Original Order column. Enter 1 and 2 in the first two data rows, select both cells, and fill the series through the remaining records.

Keep those as fixed numbers that move with each complete record. A formula that displays the current row number won't preserve the old sequence when the records move. Include this column in every later sort.

New records need their own unused sequence values when they're added. Then sorting the complete list by Original Order, smallest to largest, lets you restore that order without relying on Undo history.

Without usable history, a stored sequence, or an earlier copy, the exact original order may be lost. Ask the data owner for an original export. Reinstalling Excel can't recreate an order the workbook didn't retain.

The Short Version

Try Undo first, even if the open workbook was saved. Otherwise sort the full list by an existing sequence value or recover that sequence from an earlier copy. Clear removes filters; it doesn't reverse a completed sort.

Checked November 17, 2026.

If you have any business, I can build it online

Hi, I’m Hamza. I’ve been building websites and online shops for business owners since 2019, and I also built this site you’re reading.

Tell me what business you have or what you’re working on. I’ll look into how much it can grow online, and then we talk. You don’t have to buy anything or hire me first.

Chat with me on my site and I’ll show you proof of businesses I’ve helped and how they’ve grown.

Written by Isaac Smith

Isaac Smith is the founder and editor of PC Glance, a website that covers computers, laptops, and technology. He is a tech enthusiast and a computer geek who loves to share his insights and help his readers make smart choices when buying tech gadgets or laptops. He is always curious and updated about the latest tech trends.

More from Isaac Smith

Leave a Comment