drop down list

[Beenz75]

Is it possible to have a cell that has the drop down arrow so you could
select (for example) yes or no, like you can in word or access? I have
a worksheet and this would prevent repetitive data entry. Thanks

 

[Norman Jones]

Hi Beenz,

See Excel's Data validation feature.

Visi Debra Dalgleish's Contextures site for a Data Validation tutorial:

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

 

[Beenz75]

Thanks Norman, that was exactly what I was looking for That was
great link too, very simplified to understand