Dropdown Menu in a cell

[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

 

[Andy B]

Hi

Have a look at Data/Validation

Andy.

 

[Frank Kabel]

Hi
have a look at 'Dat - Validation'. see the Excel help or the following
site for more details:
http://www.contextures.com/xlDataVal01.html

 

[That's Confidential]

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

 

[Andy B]

OK

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

Andy.

 

[firefytr]

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

 

[That's Confidential]

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