Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |