Other Links

This webpage is an extract of the

Tutorial on Excel
from the basic to the extraordinary
The most useful and powerful tools in Excel

The drop-down lists in Excel

Lesson 2-2: Excel Drop-Down Lists and Data Validation
(Level: Beginner, Intermediate and Advanced)

Part 3:

Third method

In the source text box you can enter a the name of a named field (lesson 3-2) preceded by an equal sign. ex(=nfMyList). This approach will be indispensable if you want to set your lists on a sheet other than the sheet where the DDlist is. Indeed if you follow the procedure and try to go to another sheet when it is time to specify the source Excel doesn't allow you to move away from the sheet. So you first name the field on the other sheet and then submit it in the source as shown above. Don't forget the equal sign.

In Part 1 you will discovered how easy it is to create a drop down list in Excel
In Part 2 you will discover how to use a range of cells as Excel drop down list
In Part 3 you will discover how to assemble all your lists on a single sheet to maintain them easily and how you can refer to a list on another sheet to feed a drop down list. (In the downloadable tutorial)
In part 4 you will discover how to create cascading drop down list where the values offer in the second drop down list depends on what has been selected in the first one. (In the downloadable tutorial)
In Part 5 you will discover how to modify, extend and delete your drop down lists
In Part 6 you will discover different applications that you can develop with Excel drop down lists including a report that completely changes when you select a value in the drop down lists

This webpage is an extract of the

Tutorial on Excel
from the basic to the extraordinary
The most useful and powerful tools in Excel