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.