create a drop down menu

[legolas]

hello all,

is it possible to create a cell with a drop down menu where only certain values
with in this menu can be choosen and nothing else ?

please see atatched

thanks

[royUK]

Use Data Validation

[legolas]

fine, but how if i need to hide the source of items in the drop down menu from the main sheet
?

[royUK]

The article explains that the list can be on a different sheet which can be hidden

[JMax]

Use Data Validation

Great article. Very helpful, thank you!

[Amy Miller]

Here's another article you might find useful: http://office.microsoft.com/en-us/ex...357.aspx?CTT=1