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

Описание: Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...

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:

Beginner's Guide to Excel Tables:    • Excel Tables Tutorial: Beginners Guide for...  

How to Quickly Delete Rows by Sorting First: https://www.excelcampus.com/tips/sort...

4 Ways to Sort Drop-down Lists Automatically:    • 4 Ways to Sort Drop Down Lists Automatical...