Microsoft Office Tutorials and References
In Depth Information
Tip 58: Creating a Drop-Down List in a Cell
If your list is short, you can avoid Step 1. Rather, just type your list items (separated by commas) in
the Source box in the Data Validation dialog box.
If you plan to share your workbook with others who use Excel 2007 or earlier, 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 ➜ Defined Names ➜ Define Name to define
the name MonthNames for E1:E12. Then, in the Data Validation dialog box, enter =MonthNames in
the Source box.
Figure 58-2: Using the Data Validation dialog box to create a drop-down list.