How do a set a parameter in cell - choose A or B options?

C

cara8236

I have an Excel Spreadsheet. I want to create a form where in a designated
cell - another user can only choose pre-designated options to type into that
cell. How do I do that? Example: Cell A1 - User can choose to type in:
SSTL or ALUM or COPPER. The user would not be able to type any other value
in cell A1.
 
P

Peo Sjoblom

Data>validation,allow list and put

SSTL,ALUM,COPPER

in the source box, that will actually give you a dropdown to select from, if
you just want to validate against typing something else you need to
de-select in cell dropdown from the validation dialogue box

note that this is case sensitive, if you don't want that use custom from
allow then in the source use

=OR(I7="SSTL",I7="ALUM",I7="COPPER")

which is not case sensitive

all this can be bypassed by copying and pasting other values
 
Top