Tuesday, June 2, 2009

Excel: Custom Lists

Click Office button > Excel Options > Popular tab > Edit Custom List
Type the new list in the List entries window > OK
To import a custom Auto Fill list from your spreadsheet
Highlight your list >Click the Office button > Excel Options > Popular tab > Edit Custom List
The range of cells you previously highlighted should be present in the Import list
Click the Import button and the new Auto Fill list appears in the Custom Lists window

1 comment: