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, 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 a 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).
Create a 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 Advance under Excel options
- Then scroll down using scroll bar till you get the Edit Custom List option
- After that a custom list dialogue box will open
Create a Custom 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
- Now enter one of the data lists that you have created
- Then drag the fill handle to create a list.
Create a Custom AutoFill Series List
Method-2
Create a Custom AutoFil Series List:
- Go to the file menu in 2013 and later versions for office button in 2010 and earlier versions
- 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 advance under Excel options
- Then scroll down the editing options using 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.
Read Also:
- Microsoft Excel Spreadsheet Environment: A Starter Guide
- How to Wrap Text in Excel Spreadsheet 2019, 2016, 2013, 2010, and 2007.
- Mathematical Operators in Paste Special in Microsoft Excel.
- How to Select Text Vertically in MS-Word_No:1 Trick.
- Customize the Quick Access Toolbar in MS-Word 2019, 2016, 2013, 2010, and 2007.