Excel: Make a DropDown List in a Cell
You can place Dropdown Lists in cells to allow for data selection. Here is how …
- Position on the cell to receive the dropdown.
- Data menu > Validation …
- In the Data Validation dialog box, select the Settings Tab
- In the Allow: box, select List
- For the Source: you can type a list of values separated by commas, or you can select a range of cells where your list has been entered beforehand.
- Be sure that In Cell Dropdown is checked
- Choose OK
To copy this Dropdown list to other cells…
- Place your pointer on the cell containing the dropdown
- Copy the cell to the clipboard.
- Select the desired cells
- Edit menu > Paste Special…
- In the dialog box, select the Validation radio button, and click OK.
Only the data validation will be pasted in the receiving cells.

