Microsoft Excel:  Create a Custom List

A custom fill series is a set of data that is used to fill a column in a repeating pattern; for example, North, South, East, West. You can create a custom fill series from existing items that you’ve listed on a worksheet, or you can type the list from scratch.

1. Select an existing list and then go to the Tools menu and select Options.
2. On the Custom Lists tab, you’ll see the cell range of your list. Click Import to add your list to the custom lists.
3. Click OK when finished.

Edit a custom list or enter a new list:

1. Go to the Tools menu, select Options and the Custom Lists tab.
2. If editing an existing list, select the list on the left under the Custom lists.
3. Edit the list to the right by under List entries: Press [Enter] after each entry.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.