Drop-down boxs

E

Eric C. Vogel

Looking for ease of use for boss's.

Is there a way to create a drop-down box without having to link to cells on
the same sheet or different sheet?

I am looing for one to work exactly like the one in word form when un-locked
you double-click to had your choices.
 
B

Bob Phillips

Do you mean Data Validation?

Select a cell, go to Data>Validation, select List from the options, then
type in your values.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top