How to Create a Custom AutoFill Series List in MS Excel

Do you often waste your time by listing product names, country names, state names, currency names, employee names, or your family names in an Excel worksheet?  So, the custom Autofill series is a solution for you to stop typing repeatedly and wasting your time.

Once you create a custom AutoFill list, you can use the list any number of times, without retyping it. So, start them with different methods.

How to Create a Custom AutoFill Series List in Excel

There are two ways to create a custom AutoFill list in Excel, These are explained below.

Method 1:

Prepare the list of data that you want to create a custom AutoFill series list

Go to the File menu (in 2013 and later versions) or the Office button (in 2010 and earlier versions).

Opening a file menu in excel
Opening a file menu in Excel

After opening a File menu or Office button, Select “Options”, which appears at the bottom of the file menu to open the Excel options dialogue box.

Select options in file menu
Select options in the File menu

Select Advance under Excel options

Then scroll down  using the scroll bar till you get the Edit Custom List option

After that, a custom list dialogue box will open

autofill series list
Autofill series list

Now click on the import to import your data list from the cells

Then click OK Excel Options dialogue box and then click OK.

Create a custom autofill series list in excel
Create a custom autofill series list in excel

Now enter one of the data lists that you have created

Then drag the fill handle to create a list.

Drag fill handle to create a custom autofill series list in excel
Drag fill handle to create a custom autofill series list in excel

Method 2:

Go to the File menu in 2013 and later versions for the office button in 2010 and earlier versions

After opening a file menu or Office button

Select the options which appear at the bottom of the file menu to open the Excel Options dialogue box

Select advance under Excel options

Then scroll down the editing options using the scroll bar till you get the edit custom list option

After that, a custom list dialogue box will open

Type the new list separately by pressing enter key under list entries

Then click on the add and click ok and again press ok

Now enter one of the data lists that you have created

Then drag the fill handle to create a list.

Video Tutorial

What are the benefits of the custom autofill series list?

Listing the product names, country names, state names, currency names, employee names, or family names in an Excel worksheet is a time taking process.  So, here is the custom autoFill list solution for you to stop typing repeatedly and wasting your time.

Share