How to Sort Using a Custom List in Excel
What happens when you sort a list of Months in the Year in Ascending Order? You will get “April, August …, etc.” And that, I guarantee, is not what you want! So, how do you get the list to sort as “Jan, Feb, Mar, … etc.?
Sort Using a Custom List
Sort on Custom List
The months of the year and the days of the week are Custom Lists that are built into Excel by default. You can also create your own Custom Lists – e.g. a list of department in the order that you want to see them displayed. Once you have a Custom List saved in Excel, you can choose to sort using this order.
Watch this short video lesson to see how to create a Custom List and also how to Sort Using a Custom List in Excel.
High Definition, Full Screen Mode on YouTube
Here is the link to watch this video on my YouTube Channel – DannyRocksExcels
Click here to learn how to “Master Excel in Minutes – Not Months!”
