How To Retain Or Revert Back To Original Sort Order In Excel

In this video I explain how to retain the original sort order of a range or table so you can revert back to it after sorting other columns.

This is handy when the data does not have a column of sequential values and you want to make sure you can restore the original order of the data after sorting or modifying it.

In the video I present one solution using an index column. However, there are probably other ways to go about this. Please leave a comment below with any suggestions you have for solving this problem. Thank you! 🙂

Additional Resources:

[LoganTheGoat.]

Thank you for this :) Seems so simple but here we all are looking for the answer!! :) Thanks.

[zfg]

People wondering how to do this unsorting if you haven't included an index column beforehand, follow these steps:
File -> Info -> Version History -> (Select the required version, where we have the initial sort) -> click Restore.

[istantalentss]

Didnt even thought of this! Thanks for the tips!

[sachinteja]

It is a simple solution, but works!! Thank you

[arief]

Thank you so much, Sir. This simple way is very helpful.

[dhdcdgkhan]

Thanks Jon, Nice technique.. I like it

[RetailOpsEJ_GreatTeam]

Thank you so much! Finally i know this trick. Plus I learned about that series fill.

[mantingzhao]

Thank you very much, fix lots of troubles.

[dianasherer]

Thank you so much! So simple, even I can do it. Plus I learned about that series fill.

[ignaciodebustamantefort]

Hi jon, I use the same technique to unsort a database in excel. I think it's the simplest technique and to keep things simple is the best you can do in Excel .

[pauls]

Thanks Jon. That's a great help. I do this all the time but dragging the numbers down...and down....and down to the end of the list. I never though of just putting 1 at the top, double clicking the corner and using fill series. The hours I could have saved!!

[johnr]

I was the 1000th like 🥳 this saved me hours of work, thank you kind wizard

[molokoramotshela]

Thank you so much, your video really helped me to make my work much easier

[kiltrofilms]

2021 and you still cant unselect the a-z arder button

[vanilla]

Hello Jon, TQ very much, u saved my life. Otherwise I have to redo all my works.

[librakg]

Absolutely GREAT .... Thanks a lot Man!!!!

[GauRAAVIkas]

Hello Jon, Its really great that you have shared. But in my case, I forget to add index Row and I have applied A to Z sorting. I need help on that how can resume the original sequence.

[tommym]

Hey Jon, great advice! I've been doing this for many years, ever since I messed up my first database and had to start all over.

[seema]

I can't thank you enough sir..♥️♥️♥️

[abomohnd]

Full respect to the effort, and the nice idea 😍