Create Custom AutoFill Series List in Excel 20 | Excellent

27/09/2019
No Comments
Share

Create Custom AutoFill Series List in Excel

Create 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, 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 for any number of times, without retyping it. So, start them with different methods.

Method-1

Create Custom Autofil Series List:

  • 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 Office button (in 2010 and earlier versions).
Opening a file menu in excel

Image-1 on Create Custom AutoFill Series List

  • After opening a File menu or Office button, Select the “Options”, which appears at the bottom of the file menu to open the Excel options dialogue box.
Select options in file menu
  1. Select Advance under Excel options
  2. Then scroll down  using scroll bar till you get the Edit Custom List option
  3. After that a custom list dialogue box will open
autofil series list

Image-2 on Create Custom AutoFill Series List

  1. Now click on the import to import your data list from the cells
  2. Then click OK Excel Options dialogue box and then click OK.
Create custom autofil series list in excel

Image-3 on Create Custom AutoFill Series List

 
  1. Now enter one of the data lists that you have created
  2. Then drag the fill handle to create a list.
Drag fill handle to create a custom autofill series list in excel

Image-4 on Create Custom AutoFill Series List

Method-2

Create Custom AutoFil Series List:

  1. Go to the file menu in 2013 and later versions for office button in 2010 and earlier versions
  2. After opening a file menu or office button
  3. Select the options which appears at the bottom of the file menu to open the Excel options dialogue box
  4. Select advance under Excel options
  5. Then scroll down the editing options using scroll bar till you get the edit custom list option
  6. After that a custom list dialogue box will open
  7. Type the new list separately by pressing enter key under list entries
  8. Then click on the add and click ok and again press ok
  9. Now enter one of the data lists that you have created
  10. Then drag the fill handle to create a list.

Read More