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.
