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-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
Видео How To Retain Or Revert Back To Original Sort Order In Excel канала Excel Campus - Jon
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
Видео How To Retain Or Revert Back To Original Sort Order In Excel канала Excel Campus - Jon
excel excel campus sort excel column data excel revert to original sort order excel retain sort order excel restore sort order excel sort table excel sorting data in multiple columns excel sorting data excel fill series excel fill list of numbers excel fill series of numbers excel sequential list excel add row numbers
Комментарии отсутствуют
Информация о видео
15 марта 2019 г. 22:01:45
00:03:03
Другие видео канала