This tutorial demonstrates how to undo a sort in Excel and Google Sheets.
Undo a Sort With the Undo Command
As a result, records are again sorted by month and product. However, this option has constraints, as you can use it just after the sort. If you save or close the file, there is no option to use the undo button to undo the sort.
Undo a Sort Using Index Column
The alternative way to enable to undo a sort in every moment is to initially add one column at the beginning of the data set and use it as a unique index for every row.
- Right-click on the Column B heading, then left-click Insert.
- Enter a unique number for each row (e.g., 1, 2, 3, etc.).
- Now sort data by SKU (Column C).
- To undo a sort, just sort data again by Index (Column B). Click anywhere in the index column (B2:B17), and in the Ribbon, go to Home > Sort & Filter > Sort Smallest to Largest.
Finally, data is again sorted as initially (by month). Using this method, you can undo a sort at any time.
NOTE: VBA code can also be used to undo a sort in Excel.
Undo a Sort in Google Sheets
You can use either of the methods above to undo a sort in Google Sheets.