Dropdown Menu in a cell

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I learnt how to kinda do this last week, but it has totally slipped my mind!

Could anybody please tell me how to create a drop down menu in a cell? I
want the cell to ask me "Male" or "Female."

Thanks in advance

Neil
 
I'm looking but don't seem to be getting anywhere. Tried a few options but
no joy!
 
OK

Data / Validation. On the settings tab select List and in the source box
below that enter Male,Female

Andy.
 
data validation is done easiest (imho) with named ranges. create you
list, name the range (insert -> name -> define), data -> validation -
list -> source: =YourNamedRange

i always keep a space in my named ranges, so i can select a 'null
value, plus if you insert a value in the middle, range should move dow
(i would do defined range ie $a$1: a10).

HT
 
My problem was that I didn't know how to seperate the different words in the
list. Now, however I know that you use a comma to seperate each word!

Thanks
 
Back
Top