Custom Lists

Using custom lists in Excel

Let’s fill data by using custom lists in Excel called fill series

To make entering a particular sequence of data (such as a list of employee names) easier in Excel, you can create a custom fill series. A custom fill series can be based on a list of existing items on a worksheet, or you can type the list from scratch. Use a custom fill series based on a new list of items

On the Tools menu, click Options as shown in the training video.

Then click the Custom Lists tab.

In the Custom lists box, click New list, and then type the entries in the List entries box, beginning with the first entry.

Press ENTER after each entry.

When the list is complete, click Add.

On the Excel worksheet, click a cell, and then type the item in the custom fill series that you want to use to start the list.

Drag the fill handle across the cells that you want to fill.

Refer to the training video to see the complete process in action.

Use a custom fill series based on an existing list of items

On the worksheet, select the list of items that you want to use in the fill series.

On the Tools menu, click Options, and then click the Custom Lists tab.

Verify that the list of items that you selected is displayed in the Import list from cells box, and then click Import.

On the Excel worksheet, click a cell, and then type the item in the custom fill series that you want to use to start the list.

Drag the fill handle across the cells that you want to fill.

The items in the list that you selected are added to the Custom lists box.

Remarks  A custom list can contain text or text mixed with numbers. To create a custom list that contains only numbers, such as 0 through 100, first select enough empty cells to contain the list. On the Format menu, click Cells, and then click the Number tab. Apply the Text format to empty cells, and then type the list of numbers in the formatted cells. Select the list and then import the list.

You cannot edit or delete a built-in fill series (such as a fill series for months and days), but you can edit or delete a custom fill series.

On the Tools menu, click Options, and then click the Custom Lists tab.

In the Custom lists box, select the list that you want to edit or delete.

To edit the fill series, make the changes that you want in the List entries box, and then click Add.

To delete the fill series, click Delete.

Leave a Reply

Your email address will not be published. Required fields are marked *