Excel AutoFill recognizes certain values (for example, January, Sunday, Quarter 1) as part of a larger list. When you drag the Fill Handle from a cell containing one of these values then Excel fills the cells with the appropriate series. However, you're not stuck with just the few lists that Excel recognized out of the box. You're free to define your own AutoFill lists, as I showed in the following steps:
Office Buttonon left top of Excel window and then
click Excel Optionsto display the Excel Options dialog box.
Popularand then click
Edit Custom Liststo open the Custom Lists dialog box as shown in figure below.
In the Custom Lists box, click New List. An insertion point appears in the List Entries box.
Type an item from your list into the List Entries box and press Enter. Repeat this step for each item. (Make sure that you add the items in the order in which you want them to appear in the series.)
If you already have the list in a worksheet range, click
Import List from Cellsedit box and enter a reference to the range and then click the Import button to add the list to the
Custom Listsbox. See the following figure.
Click Add to add the list to the Custom Lists box, click OK and click OK again to back to worksheet.
If you need to delete a custom list, select it in the
Custom Listsbox and then click the