Microsoft Office Tutorials and References
In Depth Information
Creating a Drop-Down List in a Cell
In previous versions, the list of items were required to be on the same worksheet as the cell that
contains the drop-down list. With Excel 2010, that’s no longer the case.
If you plan to share your workbook with others who use an older version of Excel, make sure that
the list is on the same sheet as the drop-down list. Alternatively, you can put the list on any
sheet, as long as it’s a named range. For example, you can choose Formulas
Define Name to define the name MonthNames for E1:E12. Then, in the Data Validation dialog box,
enter =MonthNames in the Source box.
Figure 45-2: Using the Data Validation dialog box to create a drop-down list.