This will add incrementing numbers to all the cells
This will insert a blank column at the left of your dataset Suppose you have the dataset as shown below and you want to sort it based on the country name in an alphabetical order.Īnd how do you unsort this data (say after 2 days)?īelow are the steps to unsort the data in Excel: To be able to unsort a dataset, you need a reference that you can use to go back to the original dataset.
Unsort Data Using a Temporary Column in Excel There is a simple fix to this ‘un-sorting’ problem. Or you did some other stuff after sorting the data and you only want to undo the sort and not the rest of the things you did. … but what if you closed the workbook and opened it to the next data and Control Z doesn’t work. Of course, there is Control Z that undoes your previous steps… Data sorting is one of the most common tasks people do in Excel.īut what if you want to un-sort in Excel – i.e., is to revert back to the original data that has not been sorted.
