Results 1 to 3 of 3

Thread: How to remove or sort the data order in Excel sheet

  1. #1
    Join Date
    Oct 2011
    Posts
    108

    How to remove or sort the data order in Excel sheet

    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.

  2. #2
    Join Date
    May 2011
    Posts
    448

    Re: How to remove or sort the data order in Excel sheet

    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.

  3. #3
    Join Date
    May 2011
    Posts
    410

    Re: How to remove or sort the data order in Excel sheet

    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.

Similar Threads

  1. Replies: 5
    Last Post: 25-02-2012, 11:09 AM
  2. Replies: 2
    Last Post: 23-02-2012, 05:55 PM
  3. How to insert HyperTerminal data into excel sheet.
    By Shaina Na in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 07:44 PM
  4. Parsing data in Excel Sheet
    By Ossi in forum Windows Software
    Replies: 4
    Last Post: 04-02-2011, 07:55 AM
  5. Identifying common data in an excel sheet
    By Hebrew in forum Windows Software
    Replies: 5
    Last Post: 25-12-2009, 06:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,614,283.00211 seconds with 17 queries