Microsoft Office Tutorials and References
In Depth Information
Making a List—Personalizing a Drop-Down Menu
Select the range of cells where you want to use the drop-down menu (this is a
different range from the one containing the options). That is, you want to select
the cells in which the menu will actually appear when you click in any of its cells.
In the figure below we’d select the cells in the Department column (you’ll see this
collection of data again in Chapter 7), but you can really select any column of cells
to illustrate the point.
Figure 2–45. These cells will exhibit the drop-down menu.
Click Data Validation. Select List in the Allow field.
Figure 2–46. Here’s where you select the data that will appear in the drop-down menu.