Office times when you are working on spreadsheets in Excel, and you need to sort the data so that you know what is in a particular column. However, sometimes you accidentally sort the data and need to unsort the data to see if there are any patterns or trends.
Whatever the reason, unsorting data in Excel is a fairly simple task that only takes a few steps to accomplish.
Contents
What Steps are Go For Unsort in Excel?
When your data is unsorted, finding the information you need cannot be easy. Excel offers several sorting options to help you organize your data. Here are the steps to follow to unsort your data in Excel:
Solution 1
Step 1: For example, here we made a sheet with information about different country names and the population range. In the same way, you open your sheet and select your whole data.
Step 2: Press the keyboard shortcut Alt+H+S+U. Then open a shorter window.
Step 3: Here, you can shorten your data by Country. Select the Country option and click OK.
Here see the difference.
In this situation, if you want to unsort this sheet, then simply press the key of Ctrl + Z. But if you close your file and open it again and want to change it first or unsort that the key of Ctrl + Z is not working. Then what should we do?
Solution 2
For example, in our older sheet, here we create a new column. Its name is Helpercol. And enter the numbers 1,2,3 etc. Select all the numbers and scroll down.
Here the column is full of data.
Now select the three columns and press again keyboard shortcut Alt+H+S+U.
After opening the Sort window, select the country option. And click OK.
See the difference in the helpercol column.
To unsort this sheet, just open the sort window Alt+H+S+U. And select the Helpercol option. Then click OK.
Now you get your sheet unsorted. If you close your sheet and open it after a few hours or days, this trick will unsort your data.
Conclusion
If you’re working with data in Excel, you may find that you need to unsort it at some point. This can be useful if you’ve sorted the data in one way but then want to look at it in a different order. Now it’s not difficult after reading this topic.
