how do i remove sort and see the original order of the data?

E

elinka

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.
 
P

Praveen Potturi

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.
 
J

JNW

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I remove the top half of a block interval? 1
Original Sort/Data Entry Order 20
external data table sort order 0
Returning to original view. 4
Remove date format? 3
Sort Contiguous Columns - Danger 3
How do I clear a form? 0
'Trick' to restore original sort order after data modified? 3

Top