how do i remove sort and see the original order of the data?
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'm in Excel 2007. |
Answer: how do i remove sort and see the original order of the data?
How to Remove Sort and See Original Order in Excel 2007
How to Add a Column for Original Order in Excel 2007
I hope that helps! |
how do i remove sort and see the original order of the data?
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. -- Thanks, Praveen Potturi "elinka" wrote: 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'm in Excel 2007. |
how do i remove sort and see the original order of the data?
Excel doesn't store the original order, unless you still are able to undo the
action. Which can be done in xl2007 after a save is done. "elinka" wrote: 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'm in Excel 2007. |
All times are GMT +1. The time now is 05:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com