I have a simple 5 row chart that I sorted by date. Then it was saved. I want to remove the sort and see the data in its original data entry order. How do I return the data to the original state after its been saved with a sort. I am in Excel 2007.
I have a simple 5 row chart that I sorted by date. Then it was saved. I want to remove the sort and see the data in its original data entry order. How do I return the data to the original state after its been saved with a sort. I am in Excel 2007.
Select the A1 cell. Then type the below keys in order and they will be automatically get unsorted ctrl, D, D. If above solution doesn't work then try the below Ctrl+A, right click on the screen, click on unhide.
I don' think there is a option for that. If the file is still open you can press Ctrl + z to get your old format back. You must be a bit careful about data formatting or doing all this stuff. This might cause serious damage in data manipulation which is very confusing to restore.
Bookmarks