From Excel 2003 Help:
"You can use Auto Fill Options to choose options for how to fill the selection. For example, you can choose to Fill Formatting Only or Fill Without Formatting.
Format>autoformat>options

Also:
"If you've already entered the list of items you want to use as a series, select the list on the worksheet. On the Tools menu, click Options, and then click the Custom Lists tab. 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."


Ron