It’s easy to sort data in Excel alphabetically or numerically. But maybe you want to sort based on color, formatting, or a list like months of the year. We’ll show you different ways to sort data in Excel.
How to Create a Custom List in Microsoft Excel
Feb 17, 2021, 10:24 am EDT
| 2 min read
Reduce tedious data entry and the risk of errors by creating custom lists in Microsoft Excel. By setting up a list ahead of time, you can use autofill or add a drop-down selection for the items, saving you time.
Microsoft Excel comes with a few custom lists of its own. These include things like the days of the week and months of the year. This is what makes a feature like autofill so convenient. You simply enter one word, like Sunday or January, and drag the fill handle to complete the list.