Create a Custom List to AutoFill
Custom lists in Excel do two things very well:
- They speed-up your data entry
- They ensure accurate data entry
In this video lesson, I demonstrate how easy it is to create and employ Custom Lists in Excel.
Here are the Steps to Create a Custom List in Excel:
- Type the values for your list in either a column or a row
- Select the list of values and Spell Check them (F7)
- From the TOOLS Menu select OPTIONS and the CUSTOM LIST in the Dialog Box
- Since we already have selected the list of values click IMPORT
You can now use your custom list for data entry in ANY worksheet and ANY workbook on your computer.
December 30th, 2009 at 11:06 AM
[...] 1) Create a “custom list” first (see prior lesson) [...]