Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

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: https://youtu.be/fJnJTff4Na8

How to Quickly Delete Rows by Sorting First: https://www.excelcampus.com/tips/sort-data-before-deleting-rows/

4 Ways to Sort Drop-down Lists Automatically: https://youtu.be/bVbbgdWAJSY