1.

To begin, start Excel 2003 and open the file named Practice 13 in your Excel 2003 Practice folder.   File->Open

You should see a workbook that looks like this.

This company bases its financial figures on 2 year periods composed of Spring1, Summer1, Autunm1, Winter1, for the first year, and Spring2, Summer2, Autumn2, and Winter2 for the second year. We must now create a custom auto fill list for these period entries.

2.

To begin, choose Tools->Options from the Excel menu bar, and click the custom lists tab on the Options dialogue box.

3.

Here you can see the custom AutoFill list options that are available.

4.

In the large text area labelled List Entries, type Spring1 and press Enter. The term Spring1 should be visible in the list entries area. To continue, type Summer1, Autumn1, Winter1, Spring2, Summer2, Autumn2, and Winter2, pressing Enter after each word you type. You should now see this list of words in a column in the List Entries box. Click the Add button to add your list to the custom lists.

5.

Your Options dialogue box should look like this.

Click OK to remove the Options dialogue from the screen.

6.

In cell A2, type Spring1, and press Enter. Next, activate cell A1, and drag the thin cross pointer (+) down the column to cell A28.

You should have a worksheet that looks like this.

You can now use this custom AutoFill list in any row or column in any worksheet that requires these entries.

7.

Save your work and exit Excel.