Cell Drop-down Menu

[theillknight]

Is it possible to create a drop-down menu in a cell? For instance,
would like a user to be able to click on a cell and choose what s/h
wants to enter

 

[Arvi Laanemets]

Hi

Select cell/range
From menu select Data.Validation, and then in Validation window allow List
and then type your list into source field, like:
Choice1,Choice2,Choice2

You can give the list as cell reference on same sheet, like
=$A$2:$A$10

When you want to refer to the range on another worksheet, then you have to
define this range as named range, and then you can refer to this named
range - like:
=MyRange

 

[Dan Elgaard]

Yes, ude Data Validation, and select the "List"-option.

 

[icestationzbra]

http://www.contextures.com has tutorials on making such lists