Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a drop down box in a column with specific entries ?
Help!
I am trying to create a drop down box in a column, it needs to have 3 - 10 specific answers to click on in each box. I can't figure out how to do this. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a drop down box in a column with specific entries ?
Look up Data Validation in Help. Come back if you need more. Otto
"Peri" wrote in message ... Help! I am trying to create a drop down box in a column, it needs to have 3 - 10 specific answers to click on in each box. I can't figure out how to do this. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a drop down box in a column with specific entries ?
Go to an area of the sheet that you are not using. Create all the answers
that you want, one per cell (i.e. yes, no, maybe, never, occasionally, etc). I find it easier to list them one on top of the other, but it doesn't matter. Now go back to the cell that you want to have the list of answers, click it and select "data" and then "validation" from the upper menu. Change the value from "any value" to "list". Click in the "source" box and then select all the answers you want to use. Click OK and it should work. Hope this helps! Neil M Help! I am trying to create a drop down box in a column, it needs to have 3 - 10 specific answers to click on in each box. I can't figure out how to do this. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I select from drop down menu I would like the next column to populate a specific cost. | Excel Worksheet Functions | |||
Create Windows Directories from column entries? | Excel Discussion (Misc queries) | |||
Create Windows Directories from column entries? | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
How do I create a column that has a 'drop box' | Excel Worksheet Functions |