Picture of the dropdown list item in the Data Validation dialog box in Excel
The choices available depend on the item selected in the Allow combo box.
EXERCISE: For example, you might type the following
Fall, Winter, Spring, Summer
to create a list of college semesters.
To use a range of cells with a defined name, type the equal sign (=) followed by the name of the range. To use cell references, select the cells on the worksheet and then press ENTER.
NOTE: If you use the ARROW KEYS in this edit area a selection rectangle moves in the worksheet from one cell to another in the background and the address of that cell shows up in the edit field. This is fine for selecting a list of values either from a single cell or a group of cells, but it may be easier to type in text values, depending on your goal. Just realize that if you are using a keyboard for input, pressing the arrow keys to edit and review the text you type does not work in this field, so exercise caution when typing so as not to use the arrow keys unless that is really what you intend to do.