Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down menus in excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down menus in excel
You may refer the below link
http://www.contextures.com/xlDataVal01.html If this post helps click Yes --------------- Jacob Skaria "Hairy" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down menus in excel
In the ribbon ?, in a cell ?
What do you want to do with them ? Tim "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down menus in excel
This may help:
http://video.google.com/videosearch?...itle&resnum=4# 2007? http://office.microsoft.com/en-us/ex...316081033.aspx One mo http://www.homeandlearn.co.uk/excel2...l2007s8p3.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Tim Williams" wrote: In the ribbon ?, in a cell ? What do you want to do with them ? Tim "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 |
#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 |
Reply |
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 |