Create, change, or delete a custom fill series

Microsoft Office Excel 2003

  1. If you've already entered the list of items you want to use as a series, select the list on the worksheet.
  2. On the Tools menu, click Options, and then click the Custom Lists tab.
  3. Do one of the following:
    • To use the selected list, click Import.
    • To type a new list, select New list in the Custom lists box, 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.

    Note  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.

ShowChange or delete a custom fill series

You cannot edit or delete the built-in lists for months and days.

  1. On the Tools menu, click Options, and then click the Custom Lists tab.
  2. In the Custom lists box, select the list you want.
  3. Do one of the following:

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

    To delete the list, click Delete.