Skip to content

DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Fundamentals
  • Digital Marketing
    • WordPress
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
Menu

Home » Microsoft Excel » Create a Custom AutoFill Series List in Excel

Create a Custom AutoFill Series List in Excel

Posted on 27/09/201917/01/2022 by DigiRuns

Create a Custom AutoFill Series List in Excel

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.

Method-1

Create a Custom AutoFill 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
Opening a file menu in Excel
  • 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
Select options in the 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
autofill series list
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 a custom autofill series list in excel
Create a custom autofill series list in excel
  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
Drag fill handle to create a custom autofill series list in excel

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.
See also  How to Use Total Formula in Excel - 2022's Secret

Read More

  • Always Open Read Only in MS-Word, Excel, Ppt 2019
  • Freeze Panes in MS-Excel | Freeze Rows and Columns in Excel
  • Conditional Formatting in MS-Excel 2019 | New & Advanced
  • What are the Keyboard Navigation keys?
  • How to Delete a Blank Page in Microsoft Word 2020 Secret.

What are the benefits of the custom autofill series list?

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.

See also  [Fixed] Excel is Not Recognizing Numbers in Cells - 2022

Recent Posts

  • A Table Generator for Word and Office 360 – 2022’s Trick
  • How to Enable Missing Theme Editor and Plugin Editor in WP
  • How to Print a Word Document and Ppt Slides – 2022’s Master
  • (A-Z) Change Text Direction (Rotate, Flip or Mirror) in Word
  • How to Select Objects That are Behind Text in Word – 2022
  • How to Make a Transparent Text Box or Shape in Word