A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers.

Once you have set up this Excel feature, you can easily fill a range of cells with your own lists, like department names, clients, age ranges, and any other list you might need.

Let’s look at how AutoFill works and how you can create your own custom lists in Excel.

First, we will look at an example of a built-in list.

  1. Type Sun into cell B2.

  1. Select cell B2, click on the lower right corner of cell B2 and drag it across to cell H2.

How does Excel know this?

  1. On the File tab, click Options.
  2. Under Advanced, go to General and click Edit Custom Lists.

Here you can find the built-in ‘days of the week’ lists. Also notice the ‘months of the year’ lists.

  1. To create your own custom list, type some list entries, and click Add.

Note: you can also import a list from a worksheet.

  1. Click OK.
  2. Type London into cell C2.

  1. Select cell C2, click on the lower right corner of cell C2 and drag it down to cell C5.