3. Click the Import button in the Custom Lists dialog in order to import your custom list.
Figure 102 Import the list from a range.
Note that if you later change the flavors in this list, you can edit the list in this dialog. Make sure to click the Add button to commit the changes..
After you add the custom list, you can type any item from the list in a cell and then drag the fill handle. Excel will fill in the remaining items from the list. If you go too far, the list will repeat.
Additional Details: Say that you want to store a list of names, and the first name in the list is a really long name, such as John Jacob Jingleheimer Schmidt. Rather than having to type this name to start the list, you could make the first item in the list the heading. So, perhaps you could type Class1 or MktgDept and drag the fill handle to get the correct list.
Additional Details: The custom list is flexible with regards to case. If you type the first item in all caps, the list will fill as all caps. If you use lower case, the list will fill as lower case.
Additional Details: Custom lists are stored in your computer’s registry. It is therefore very difficult to transfer a list from one computer to another. One method is as follows:
1. Set up a custom sort using your custom list. (See How to Sort a Report into a Custom Sequence)
2. Move the workbook to the new computer.
3. Do a sort on the new computer. In the Order column, select Custom Lists. Click Add.
Since the above process is fairy convoluted, it might be easier to copy the lists into a blank workbook on the old computer, and then import the lists on the new computer. If you have Excel 2003 installed, you can use the Office Save My Settings Wizard to save custom lists.