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.
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
Link to this post!
[…] 1) Create a “custom list” first (see prior lesson) […]