Calculation Issues

How to Restore an Excel List After Sorting Prices Incorrectly

John Wilson Oct 13, 2026 870 views

Question details

The user needs to recover the original order of a business price list where items were sorted alphabetically but prices remained stationary, resulting in mismatched data. The file was saved and closed, making the Undo function unavailable.

How to Restore an Excel List After Sorting Prices Incorrectly

Product: Excel
Device & OS: not provided
Scenario: Attempting to recover a saved and closed workbook after an incorrect partial-column sort caused data misalignment.
Observed behavior: Item names are sorted alphabetically, but corresponding prices did not move with the items. The Undo action (Ctrl+Z) cannot be used because the workbook's undo history was cleared upon closing.

Before you start

Immediately stop making further changes or saving the current file to prevent overwriting any remaining temporary backups or cloud version history.

Solution 1Recommended

Recover the Original List Using Cloud Version History

If your file was saved on OneDrive, SharePoint, or a similar cloud service, you can restore a previous version of the document from before the incorrect sort occurred.

Cloud storage services automatically save snapshots of your files as you work. This allows you to roll back to an exact moment before the data became misaligned, even if the file was closed.

Open the file properties online

Navigate to your OneDrive or SharePoint web interface and locate the affected Excel file.

Access Version History

Right-click the file and select 'Version history' from the context menu. A pane will appear showing previous saves.

Restore the correct version

Identify a timestamp from before you performed the incorrect sort, click the three dots next to it, and select 'Restore'.

Recover the Original List Using Cloud Version History

Desktop App Recovery: If you have the file open in the Excel desktop app and AutoSave is on, you can also click the file name at the top of the window and select 'Version History' to view and restore past versions directly.

Solution 2

Restore Using Windows File History (Local Drive)

If your file was saved locally and you have Windows File History or system backups enabled, you can extract an older copy of the workbook.

Solution 3

Prevent Incorrect Sorting by Formatting as a Table

To avoid future sorting errors where rows become disconnected, format your entire data range as an official Excel Table before sorting.

Manage and Auto-Backup Spreadsheets with WPS

Use WPS Spreadsheet for Safe Sorting and Auto-Backups

WPS Spreadsheet provides intuitive sorting features that automatically expand to include adjacent data, preventing mismatched rows. Plus, with WPS Cloud, your file version history is automatically saved, so you can always revert accidental changes even after closing the file.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx price list.
2. Select the entire data range: Click any cell within your data range before attempting to sort.
3. Apply intelligent sorting: Navigate to the Data tab and click Sort. WPS will automatically detect and include adjacent columns like prices.
4. Enable Cloud Backup: Turn on WPS Cloud synchronization to automatically save file versions, ensuring you can undo saved mistakes in the future.

Intelligent sorting automatically expands selection to adjacent columnsWPS Cloud provides robust version history for easy file recoveryFully compatible with Microsoft Excel (.xlsx) files and formatsFree to download and lightweight for quick data processing

microsoft office alternative - wps office

Frequently Asked Questions

Why did Excel sort my items but not my prices?

This happens when only one column is selected before applying the sort command, and the warning prompt to 'Expand the selection' is ignored or disabled. As a result, Excel only sorts the highlighted column, leaving the adjacent unselected columns in place.

Can I use Ctrl+Z (Undo) to fix the sort after closing?

No. Once an Excel workbook is saved and closed, the entire Undo history is permanently cleared from your system's memory. You cannot use Ctrl+Z to reverse actions after reopening.

How can I lock columns together when sorting?

The safest method is to format the entire data range as a Table (Ctrl+T) before sorting, which binds the row data permanently. Alternatively, you can manually highlight all columns you want to keep together before clicking the Sort button.

Excel & Data Problems