How to Create a Custom List in Excel Tutorial
If you type “jan” in one cell and use fill handle and drag down, the subsequent cells will be filled with feb, mar … so on. Similarly, one cell B1 below has “Sunday” and if we use fill handle Monday comes into the next cell. Where does the sequence comes from in excel.
Using fill handle to get next value from custom list
If we write one of the employee name and use fill handle, can we get the remaining employee names in the subsequent cells?
Yes. It is possible by using “Custom Lists” in excel.
In excel 2013, Custom list can be accessed from FILE > Options (from left pane)
Select “Advanced” in the Excel Options box left pane. Scroll down through right scroll bar and go to “General” section where we can find “Edit Custom Lists….”
Select the “Edit Custom Lists….”
From the above box, custom lists can be created in two ways.
To add one by one, we can select “NEW LIST” from “Custom lists” and type the values to be added into “List entries”. (can be separated by giving enter after each entry of by comma separation)
Then select “Add”
The second way is to use the list in work sheet by “Import”
Select the list in worksheet by using the import list option and click “Import”. OK.
Now, when one of the value is written in a cell and use fill handle and drag down.
The next value in the list will come into the next cell.
Note: After the last value in the list first value will be repeated. (values list is cyclic )
- Typing the values one by one (in new line or comma separated)
- Selecting the data list which is there in a worksheet.