This article is part of the Microsoft Excel 2007 Introduction Course 

There are 4 lists set up by default within Excel 2007. Days of the week & months of the year, in full form ( Monday, Tuesday…) or short form ( Mon, Tue…).

This means if the Autofill is used on a cell which contains an item from one of these lists (e.g. Monday), the next item(s) on the list (Tuesday, Wednesday….) are completed.

To create a custom list, this will do the same on a list of your own:
1. Click the Office Button and then click Excel Options.

2. Click the Popular category, and then under Top options for working with Excel, click Edit Custom Lists.

3. In the Custom Lists box, select NEW LIST

4. Type in the items of the new custom list in entries box, starting with the first item.

5. Separate each item with a comma or press ENTER between items.

6. When the new custom list is completed, click Add. The new list is added to the Custom lists box.

If a list already exists in a workbook, it can be imported in to the custom lists.

1. Select the range to be imported as a custom list.

2. Click the Popular category, and then under Top options for working with Excel, click Edit Custom Lists.

3. In the Custom Lists dialog box, check the correct cell are shown in the Import List From Cells box, and then click Import.

4. The List selected are added to the Custom Lists box.