Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
|
|||
|
|||
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!
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to restore the original data order | Excel Discussion (Misc queries) | |||
Sort Data Into Numerical Order..! | Excel Discussion (Misc queries) | |||
Sort data into order of product | Excel Discussion (Misc queries) | |||
Sort data into order of product | Excel Worksheet Functions | |||
Sort order : Excel vs imported data | Excel Discussion (Misc queries) |