Excel > Excel 2003 Foundation > Creating a workbook

Custom Lists

Custom lists are an excel feature to save time when entering data.

In the example below Monday is entered in cell B4. Using the autofill feature explained previously to copy the cells contents, it fills the other cells with the remaining days of the week and then repeats.

Filling the days of the week

This works because the days of the week are stored as a custom list. To view the custom lists click Tools > Options and then click the Custom Lists tab. Notice that there are lists setup for abbreviated days of the week and months too.

Custom lists

It is possible to create your own custom list. Simple type the items of the list in the List entries box separating them by pressing Enter, or select a range of cells that contain the list entries and click Import. The image below shows both methods.

Creating a custom list

Follow us on

Facebook  Twitter  You Tube