Sorting data in Excel is quite a common task to do. There are multiple ways available both to sort and undo sort data in Excel. After applying the sort command to your data, by default, they don’t revert back to their original state. In this tutorial, you can learn to undo sort in Excel with 3 exclusive methods.
How to Undo Sort in Excel (3 Easy Methods)
1. Use CTRL + Z to Undo Sort in Excel
One quick way to sort your data in Excel is by using the Sort command from the DATA tab.
If you did so and want to undo sort then,
❶ Just press CTRL + Z immediately after sorting your data.
This shortcut key will instantly undo a sort and revert back the data to its original state.
Read More: Auto Sort in Excel Without Macros
Similar Readings
- How to Sort in Excel by Number of Characters
- Excel Sort by Column Without Header
- Excel Sort Column by Value
- How to Sort Multiple Columns in Excel Independently of Each Other
- How to Sort Alphabetically in Excel with Multiple Columns
- How to Add Sort Button in Excel
- How to Sort by Last Name in Excel
- How to Perform Custom Sort in Excel
- How to Sort Excel Sheet by Date
- Sort IP Address in Excel
- Random Sort in Excel
- How to Sort Duplicates in Excel
2. Use Clear Command to Undo Sort in Excel
Another way that you might have followed to sort your data in Excel is that,
❶ You’ve selected your data.
❷ Then click on Filter from the DATA tab, under the Sort & Filter group.
❸ Then you’ve clicked on the drop-down icon.
❹ And selected any of the options,
- Sort A to Z
- Sort Z to A
If you’ve followed the above method to sort your data in Excel, then you undo sort by using the following method.
❶ Go to the DATA tab first.
❷ Under the Sort & Filter group, you will find the Clear command. Just click on it.
You can also find the Clear command by following,
HOME > Editing > Sort & Filter > Clear
Read More: Excel Auto Sort when Data is Entered
Similar Readings
- Excel Auto Sort when Data Changes
- How to Sort Data in Excel by Value
- How to Sort Data in Alphabetical Order in Excel
- How to Put Numbers in Numerical Order in Excel
- How to Sort Alphanumeric Data in Excel
- How to Sort Multiple Columns in Excel
- How to Auto Sort Multiple Columns in Excel
- How to Sort Birthdays in Excel by Month and Day
- How to Sort Excel Tabs
- How to Sort by Color in Excel
- How to Remove Sort by Color in Excel
3. Undo Sort and Revert Back Data to the Original State in Excel
If you follow the second method of this article to undo sort in Excel, it will not revert back the data to its original state.
However, following this method will do.
To undo, sort, and revert back data to its original state, you will need an additional tracker column.
This additional column will keep track of the serial number of the individual rows. Thus after undoing the sort, if we sort the tracker column, our data will consequently revert back to their original state.
Anyways, follow the steps below to do so,
❶ Add an additional column to the data table that stores the serial number of the rows in your data table.
❷ Now go to the DATA tab. Then select FILTER from the Sort & Filter group.
❸ Click on the drop-down icon of any of the table headers.
❹ Select Sort A to Z or Sort Z to A and hit the OK button to sort your data.
Now you will see that the data have been sorted and the serial numbers of the rows have been messed up.
❺ To undo a sort, go to the DATA tab. From the Sort & Filter group, select Clear to undo sort.
So you have undone the sort successfully. But if you look at your data, you can see that they didn’t revert back to their original state.
❻ To take your data back to its original state, click on the drop-down icon of the tracker column and select Sort Smallest to Largest, and hit the OK button.
This will rearrange the serial number of the tracker column. And you can see that your data have been reverted back to their original state.
Remove Filter and Revert Back Data to the Original State
But if you want to remove the Filter command from your data and then revert back your data to the original state, then
❼ Go to the DATA tab and click on Filter.
This will remove the Filter command from your data.
❽ Lastly, select your data then go back to the DATA tab. From the Sort & Filter group, click on the A to Z icon.
So after following all these steps, you will have your data reverted back to their original state as in the picture below:
Read More: How to Sort and Filter Data in Excel
Similar Readings
- How to Sort Two Columns in Excel to Match
- Excel Sort by Row not Column
- How to Sort Rows in Excel
- Excel Sort Rows by Column
- How to Sort Alphabetically in Excel and Keep Rows Together
- How to Sort by Date in Excel
- How to Sort Data in Excel Using Formula
- How to Sort Dates in Excel by Year
- Excel Sort by Date and Time
- How to Sort Numbers with Letter Suffix in Excel
- How to Sort Dates in Chronological Order in Excel
- Advanced Sorting in Excel
- Excel Sort Unique
- How to Sort Numbers in Excel
- How to Auto Sort Table in Excel
- Advantages of Sorting Data in Excel
- Difference Between Sort and Filter in Excel
- How to Sort by Month in Excel
Things to Remember
- The second method doesn’t revert back the data to its original state.
- The first method only works immediately after applying the sort command.
- If you want to revert back your data to the original state, use the third method.
Download the Practice Workbook
You can download the Excel file from the following link and practice along with it.
Conclusion
To sum up, we have discussed 3 methods to undo sort in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries. And please visit our website Exceldemy to explore more.
- How to Remove Sort in Excel
- Excel Sort Not Working
- How to Sort Drop Down in Excel
- How to Sort Merged Cells in Excel
- How to Sort Merged Cells of Different Sizes in Excel
- Sorting Columns in Excel While Keeping Rows Together
- How to Use Excel Shortcut to Sort Data
- How to Sort by Ascending Order in Excel
- [Fix] Excel Sort by Date Not Working
- Excel Sort and Ignore Blanks
- How to Sort Columns in Excel Without Mixing Data
- How to Arrange Numbers in Ascending Order with Excel Formula
- How to Sort Dates in Excel by Month and Year
- Sort and Filter in Excel Not Working
- Excel Not Sorting Numbers Correctly
- Excel Sort by Cell Color Not Working
- Excel Sort Largest to Smallest Not Working
- How to Sort by Name in Excel
Kindly help me, Yesterday I have worked in excel work sheet and not dine any kind of serial number and then i have applied filter on product names but by mistake I have not done filter on quantity and worksheet Ihave closed worksheet when again I have opened the sheet my product quantity and products does not tallying, kindly tell me any solution about how I can revert to my orgnal data table state Thanks
This should not happen with Filter. As soon as you clear the Filter, everything should be normal again. I suppose you SORTED the Products instead, excluding the Product Quantity. Then this becomes a complicated scenario.
I don’t know which Excel version you are using but you may try the following solutions. However, I can’t guarantee whether they will work for sure.
1. For Office365: Open the workbook. Go to File > Info > Version History. Check for any previous versions listed there. If not, then go to File > Info > Manage Workbook > Recovered Unsaved Workbooks. This will take you to the recovery folder for excel files. Look for a file with your workbook’s name.
2. For Excel 2019-2016: Open the Workbook. Go to File > History. Hopefully, you will find the previous versions listed there.
3. You can also check for any previous version using File Properties. Go to the file location. Right-click on the file name. Go to Properties > Previous Versions. Check for any previous versions listed there.
4. To manually check the recovery folder, go to File > Options > Save > Save Workbooks. Then copy the AutoRecover File Location and paste it on the File Explorer address bar.
You may visit this blog post from Microsoft for more >> https://support.microsoft.com/en-us/office/view-previous-versions-of-office-files-5c1e076f-a9c9-41b8-8ace-f77b9642e2c2
I hope you will be able to recover the file. Best of luck!
Thanks & Regards,
Md. Shamim Reza (ExcelDemy Team)
Thanks!!!!
Dear Gerry Conroy,
You are most welcome.
Regards
Shamima | Project Manager | ExcelDemy