V Vampire542 Sep 6, 2003 #1 I understand how to create a custom list. I just don't know how you use the list. Please Help
G Gord Dibben Sep 6, 2003 #2 Vampire Custom lists are used when you are auto-filling down a column or across a row. Examples of Custom Lists are months, days, alphabet and of course, your own created list. Basic use..........Enter first object in the list then drag to get the rest of the list auto-filled. i.e. Enter January in A1. Grab fill handle at bottom right corner of A1 and drag down the column. Gord Dibben Excel MVP XL2002
Vampire Custom lists are used when you are auto-filling down a column or across a row. Examples of Custom Lists are months, days, alphabet and of course, your own created list. Basic use..........Enter first object in the list then drag to get the rest of the list auto-filled. i.e. Enter January in A1. Grab fill handle at bottom right corner of A1 and drag down the column. Gord Dibben Excel MVP XL2002