Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a dropdown look up box
How do I create a cell as a dropdownlookup box?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a dropdown look up box
what i usually do, is somewhere off the actual area of the sheet, i create a
list. so, over in z1, for example i enter January, z2 February, z3 March...and so on then, wherever you want the dropdown, let's say c1, click on c1, on the menu select data and then validation. click list from the allow dropdown and in the source, enter =$Z$1:$Z$12 or click the little icon to the right of the entry box and select the cells manually. click ok. then i usually hide the column i have the list in. others may do it differently -- Gary "Man Utd" wrote in message ... How do I create a cell as a dropdownlookup box? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a dropdown look up box
Thank you for your answer.
I got a complicated problem to me, as I am very new to Excel ! I need 2 columns have dropdownbox. The first dropdownbox displays the groups of people like manager, driver, secretary, cleaner.. The second dropdownbox displays the names of that group selected in the first dropdownbox. So if I selected the manager in the first dropdownbox, in the second dropdownbox will be filled up with the names of the manager grade. What would you suggest I can do ? "Gary Keramidas" wrote in message ... what i usually do, is somewhere off the actual area of the sheet, i create a list. so, over in z1, for example i enter January, z2 February, z3 March...and so on then, wherever you want the dropdown, let's say c1, click on c1, on the menu select data and then validation. click list from the allow dropdown and in the source, enter =$Z$1:$Z$12 or click the little icon to the right of the entry box and select the cells manually. click ok. then i usually hide the column i have the list in. others may do it differently -- Gary "Man Utd" wrote in message ... How do I create a cell as a dropdownlookup box? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a dropdown look up box
http://www.contextures.com/xlDataVal02.html
-- Gary "Man Utd" wrote in message ... Thank you for your answer. I got a complicated problem to me, as I am very new to Excel ! I need 2 columns have dropdownbox. The first dropdownbox displays the groups of people like manager, driver, secretary, cleaner.. The second dropdownbox displays the names of that group selected in the first dropdownbox. So if I selected the manager in the first dropdownbox, in the second dropdownbox will be filled up with the names of the manager grade. What would you suggest I can do ? "Gary Keramidas" wrote in message ... what i usually do, is somewhere off the actual area of the sheet, i create a list. so, over in z1, for example i enter January, z2 February, z3 March...and so on then, wherever you want the dropdown, let's say c1, click on c1, on the menu select data and then validation. click list from the allow dropdown and in the source, enter =$Z$1:$Z$12 or click the little icon to the right of the entry box and select the cells manually. click ok. then i usually hide the column i have the list in. others may do it differently -- Gary "Man Utd" wrote in message ... How do I create a cell as a dropdownlookup box? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown boxes make file size too large | Excel Discussion (Misc queries) | |||
Make dropdown item list in invoice sheet | New Users to Excel | |||
Make input in one column determine dropdown list in another. | Excel Discussion (Misc queries) | |||
How can I allow users to make multiple selections from a dropdown. | Excel Worksheet Functions | |||
how to make dropdown arrow disappear in vba | Excel Worksheet Functions |