Adding a dropdown list to a cell

I have a spreadsheet with a list of values in H3:H25 as a named range. Im column D rows 25-99 I would like to select one of the values in the named range to enter into the cells in column D, like the drop down list in Excel. How dfo I do this?

1 Like
  1. select your range D25:D99, then menu Data->Validity

  2. In dialogue Validity select from drop-down list variant ‚ÄúCell range‚ÄĚ, and bottom set ‚ÄúSource‚ÄĚ (your H3:H25)

  3. Push OK

That did it! Thanks

mark my answer as Correct (checkbox left from answer)