| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down menus in excel
data validation?
lets say you have a list in D2:D10 select any other cell, eg B2, then from the DATA menu, select Data Validation from the Data Tools group in the data validation form, set Allow to LIST and the source to =D2:D10 if the table D2:D10 is rangenamed, eg dataList , then in the validation form source put =dataList click OK to close the data validation form. "Hairy" wrote in message ... Please Help as I am at my wits end I am new to the group and I am working on excel 2007 version. Could somebody PLEASE help me how to create dropdown menus in excel. -- Hairy Gerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
| Excel drop down menus | Excel Worksheet Functions | |||
| drop down menus in excel | Excel Discussion (Misc queries) | |||
| How do I link drop down menus to one another in Excel? | Excel Programming | |||
| Creating Drop-down menus in Excel | Excel Programming | |||
Threaded Mode
