Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up a drop down menu for a validation list?
I am looking to set up validation lists with data in a large excel
spreadsheet so that people can only type the values that I choose. I would although like them to be able to choose the choices that i offer from a drop down menu so all information is consistent. Each cell that I would like validated should have a little drop down arrow at the right. Any ideas on how to do this?? |
#2
|
|||
|
|||
Hi
see: http://www.contextures.com/xlDataVal01.html -- Regards Frank Kabel Frankfurt, Germany "UisNike" schrieb im Newsbeitrag ... I am looking to set up validation lists with data in a large excel spreadsheet so that people can only type the values that I choose. I would although like them to be able to choose the choices that i offer from a drop down menu so all information is consistent. Each cell that I would like validated should have a little drop down arrow at the right. Any ideas on how to do this?? |
#3
|
|||
|
|||
Datavalidationallowlist (then refer to the list either by putting in the
range or name it and use the name), the dropdown won't be visible until you select teh cell though. If you want that you need to use a combobox Regards, Peo Sjoblom "UisNike" wrote: I am looking to set up validation lists with data in a large excel spreadsheet so that people can only type the values that I choose. I would although like them to be able to choose the choices that i offer from a drop down menu so all information is consistent. Each cell that I would like validated should have a little drop down arrow at the right. Any ideas on how to do this?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto scroll down data validation list | Excel Discussion (Misc queries) | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
list validation using list validation... | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |