Excel How To: Retain The Original Sort Order In Excel

Revert back to the original order after you've sorted it, I have a really easy tip for you.

Enjoying this Excel tutorial from @ExcelCampus ? We have a TON of #msexcel tutorials for Excel beginners and experts (and everything in between!)

Are you always learning something new when it comes to Excel? We definitely are.

They'll help you master Excel so you nail that next interview, or at least find formulas, macros, VBA, and pivot tables a little less confusing...

[morenabalatseng]

You have no idea how much this simple trick is so handy. It just goes to show me that if I don't specialise in specific areas like you do, for example, it becomes important for me to keep watching your videos because there are gems that await me to help me become more productive. Thank you

[QLaHa]

Thank you 🙏🏻 so much!!! I always had troubles to get to the original back…. 😅 It was frustrating!!! But not anymore

[mymatemartin]

Been doing that and sharing it for 30 years. It's a great tip and a real lifesaver with financial data or any data where sequential event / transactional order is paramount.

[jackcurl]

Learned this technique the hard way. At least I could start from scratch (external data source).

Also extremely useful for deleting a sizable number of rows. I had a 50K-row table, and I needed to delete all the 0 amount rows (20-30%). Filtering, and deleting is PAINFULLY SLOW. Sorting first, though, to get all the records together provided a huge speed increase. An index field is not necessary in this case, but maintaining an original order makes it necessary. An additional benefit of the index field is serving as a unique key to the data.

[ristearazvann]

Even though it was right in front of us, thank you!! Genius!!

[ggggffhj]

wow, I never thought of this. Now I won't be afraid to use the sorting tool anymore :D

[akselwitsel]

I love you man, you saved me a lot of time ❤

[ericblouin]

I knew that one, I was hoping for something already integrated in Excel! Thanks anyway, it does the job!

[gferrerstyron]

Thank you so much for all HUGE INFORMATION that you share with all us!!! You are amazing, very easy to understand, you explain everything so well, let me know if you give classes 👍🤩

[isabellaify]

U r amazing! Solved my long time question

[LeahyPhoto]

Instead start in row 2 with the number 2 so that both are in agreement. You can put 1 in the header if you like, or just omit it.

[excel-chlef]

How can the filter function be used if the search for a number or letter can be in the first, middle, or end of the condition? For example, I want to filter all products that end with the number 5

[arpitmishra]

I have not done indexing now please guide how to get old sort order

[cruzinsweetsntreats]

Selecting multiple columns allows you to sort by multiple categories, say by Date, then item, or item, then date, etc, from whichever you column you select first.

[SilverWolf]

Is there a way to sort track numbers like 1., 2, 3, ...15., 21., etc but with a "." after the number. When I try to sort them, it puts "2." right before "20.", but after "15.".