In my last blog post, Excel’s Greatest Time Saver: Autofill, I spoke about how useful the Autofill tool is when working with data. Excel is very smart and has already programmed lists that help in completing a series of entries such as days of the week and months of the year. These lists are not only used for filling data, but also to sort data.

What if you have other lists that you frequently use such as states of a country, store locations or departments in a business? You could copy and paste your data every time it’s needed, but that is not going to allow you to sort by that order later, so it’s not the best solution. This is where custom lists come into play and in the above QuickTuts video, I’ll demonstrate how to create these lists in Excel 2013.