Create a Custom List to AutoFill

Custom lists in Excel do two things very well:

  1. They speed-up your data entry
  2. 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:

  1. Type the values for your list in either a column or a row
  2. Select the list of values and Spell Check them (F7)
  3. From the TOOLS Menu select OPTIONS and the CUSTOM LIST in the Dialog Box
  4. 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.

NEW! Download the Excel practice file I use in this lesson: create-custom-lists

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Videos

Related Excel Videos

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. […] 1) Create a “custom list” first (see prior lesson) […]

Speak Your Mind