View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Praveen Potturi Praveen Potturi is offline
external usenet poster
 
Posts: 8
Default 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.