Microsoft Office Tutorials and References
In Depth Information
Create a Custom Fill List
Chapter 3: Customizing Worksheet Presentation
The Custom Lists dialog
5 Click NEW LIST.
6 Type an entry for the
7 Press Enter.
8 Repeat steps 6 and 7 to
define all the list entries.
9 Click Add.
Excel adds the list.
0 Click OK.
Did You Know?
You can save time by entering the custom
fill list values in advance on a worksheet.
Once you have done that, select the
range that contains the custom list
entries, and then follow steps 1 to 4 to
open the Custom Lists dialog box. Click
the Import button to add the list, and
then click OK.
If you no longer want to use a custom fill
list, you should delete it. Follow steps 1 to
4 to open the Custom Lists dialog box.
Click the list you no longer need, click the
Delete button, and then click OK when
Excel asks you to confirm the deletion.
Click OK in the Custom Lists dialog box
when you are done.