Excel drop down menu help

[jimbogarner]

Hello,

When i have an excel cell, i want to add a drop down menu for that cell so that somebody can select only the options i give them on that drop down.

Is this possible? and how can i do it?

Many Thanks

James

 

[JamesW]

Hi there,

Try data validation:

Data -> Validation -> Allow: List -> Source: xxx, yyy, zzz etc

 

[Andrew Poulsom]

Here's a tutorial:

http://www.contextures.com/xlDataVal01.html

 

[jimbogarner]

Amazing! Thanks for the speedy reply!