Create your own Autofill List to Quickly fill Series!!

Custom list is useful when you have to use some data repeatedly in your work. With the help of Custom list you can easily fill the range of data. There is no need to type the whole list again and again. It also helps reduce errors.

We already have some default list in Excel like January, February, March and so on…

Example:

Type January in A1 cell, drag the cell.

To create this kind of custom list follow the below steps:

Steps:

1. Click on the File tab – options.

2. Select the Advance option and click on Edit Custom Lists under General group.