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?
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.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
...or put in a helper column, numbering rows as 1, 2, 3, etc. When you're finished sort by that column.
Simple.. I like
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks