How to Create Custom AutoFill Lists in Excel 2013
Click the cell with the first entry in the custom series and then drag the mouse or Touch pointer through the range until all the cells with entries are selected.
The expanded cell cursor should now include all the cells with entries for the custom list.
Select File→Options→Advanced (Alt+FTA) and then scroll down and click the Edit Custom Lists button located in the General section.
The Custom Lists dialog box opens with its Custom Lists tab, where you now should check the accuracy of the cell range listed in the Import List from Cells text box. (The range in this box lists the first cell and last cell in the current selected range separated by a colon — you can ignore the dollar signs following each part of the cell address.)
To check that the cell range listed in the Import List from Cells text box includes all the entries for the custom list, click the Collapse Dialog Box button, located to the right of the Import List from Cells text box.
When you click this button, Excel collapses the Custom Lists dialog box down to the Import List from Cells text box and puts a marquee (the so-called marching ants) around the cell range.
If this marquee includes all the entries for your custom list, you can expand the Custom Lists dialog box by clicking the Expand Dialog box button (which replaces the Collapse Dialog Box button) and proceed to Step 3.
If this marquee doesn’t include all the entries, click the cell with the first entry and then drag through until all the other cells are enclosed in the marquee. Then, click the Expand Dialog box button and go to Step 3.
Click the Import button to add the entries in the selected cell range to the List Entries box on the right and to the Custom Lists box on the left side of the Custom Lists tab.
As soon as you click the Import button, Excel adds the data entries in the selected cell range to both the List Entries and the Custom Lists boxes.
Select the OK button twice, the first time to close the Custom Lists dialog box and the second to close the Excel Options dialog box.
If you don’t have the entries for your custom list entered anywhere in the worksheet, skip Step 4 and instead take three additional steps.
Click the List Entries box and then type each of the entries for the custom list in the order in which they are to be entered in successive cells of a worksheet.
Press the Enter key after typing each entry for the custom list so that each entry appears on its own line in the List Entries box, or separate each entry with a comma.
Click the Add button to add the entries that you’ve typed into the List Entries box on the right to the Custom Lists box, located on the left side of the Custom Lists tab.
Note that when Excel adds the custom list that you just typed to the Custom Lists box, it automatically adds commas between each entry in the list — even if you pressed the Enter key after making each entry. It also automatically separates each entry on a separate line in the List Entries box — even if you separated them with commas instead of carriage returns.
Click the OK button twice to close both the Custom Lists box and Excel Options dialog box.
After you’ve created a custom list by using one of these two methods, you can fill in the entire data series by entering the first entry of the list in a cell and then dragging the Fill handle to fill in the rest of the entries.