+ Reply to Thread
Results 1 to 4 of 4

After applying a Data Filter and sorting the data, how can you revert back to original?

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    Shanghai
    MS-Off Ver
    Excel 2010
    Posts
    23

    After applying a Data Filter and sorting the data, how can you revert back to original?

    I'm using Excel 2010 and I applied a Data Filter to a simple table. I then messed around with the drop downs in each column, sorting the data by different criteria. After doing this, is there a simple way to get the table to revert back to its original order/form?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: After applying a Data Filter and sorting the data, how can you revert back to original

    I believe it's not possible, but I suggest you to duplicate the sheet by holding Ctrl+Click the sheet and drop it to the nearby sheet names and continue doing changes on the duplicate sheet and once the task is over then delete the duplicate and locate the Original sheet.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,006

    Re: After applying a Data Filter and sorting the data, how can you revert back to original

    ...or put in a helper column, numbering rows as 1, 2, 3, etc. When you're finished sort by that column.

  4. #4
    Registered User
    Join Date
    12-19-2012
    Location
    Shanghai
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: After applying a Data Filter and sorting the data, how can you revert back to original

    Simple.. I like

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1