drop down list
 

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


--
Beenz75
------------------------------------------------------------------------
Beenz75's Profile: http://www.excelforum.com/member.php...o&userid=30471
View this thread: http://www.excelforum.com/showthread...hreadid=501339

drop down list
 

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

---
Regards,
Norman


"Beenz75" wrote in
message ...

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


--
Beenz75
------------------------------------------------------------------------
Beenz75's Profile:
http://www.excelforum.com/member.php...o&userid=30471
View this thread: http://www.excelforum.com/showthread...hreadid=501339

drop down list
 

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


--
Beenz75


------------------------------------------------------------------------
Beenz75's Profile: http://www.excelforum.com/member.php...o&userid=30471
View this thread: http://www.excelforum.com/showthread...hreadid=501339