Ask Your Question
0

Adding a dropdown list to a cell

asked 2018-09-06 20:28:47 +0100

cpat gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-09-06 21:58:51 +0100

kompilainenn gravatar image
  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

edit flag offensive delete link more

Comments

That did it! Thanks

cpat gravatar imagecpat ( 2018-09-06 23:43:21 +0100 )edit

mark my answer as Correct (checkbox left from answer)

kompilainenn gravatar imagekompilainenn ( 2018-09-07 08:27:39 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-06 20:28:47 +0100

Seen: 1,239 times

Last updated: Sep 06 '18