How to Create a Custom List in Excel

One useful feature of Excel is that it automatically fills a row with the names of months or weekdays when you type in the first few items in the row. To do this, you select the cells and drag the "fill handle" at the lower right corner of the selection to extend the series. Although this works for common lists like days, months, numbers,and so on, if you have a series of words or names that you frequently enter by hand, you also have the option to create a custom autofill list.Click on File, then Options, and then Advanced. Scroll down almost to the foot of the Advanced menu. Under the General heading, click Edit Custom Lists..., and in the Custom List dialog, click New List and enter your list of words.