Cell Drop-down Menu

T

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
 
A

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
 
Top