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.

Comments

Post a comment




Remember Me?