Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel, how to set up 1 down boxes in a column
I understand how to set up Validation and enter a formula identifying the
cells for the contents of the drop down box. However, when I go to the column and attempt to click on the cells/drop down boxes, the number of options/items in the drop down box items decreases by one as I move down a cell at a time until there are no contents in the cell at all. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel, how to set up 1 down boxes in a column
It sounds like you used relative references to the list range. Try using
absolute references. Example: use Source: =$G$1:$G$10 instead of Source: =G1:G10 (the dollar signs "lock" that part of the reference) Alternatively, you could assign a Range Name to the list and reference that name. Does that help? (Post back if you have more questions) *********** Regards, Ron XL2003, WinXP "KentJ" wrote: I understand how to set up Validation and enter a formula identifying the cells for the contents of the drop down box. However, when I go to the column and attempt to click on the cells/drop down boxes, the number of options/items in the drop down box items decreases by one as I move down a cell at a time until there are no contents in the cell at all. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating percentages based on the number of checked boxes in a column | Excel Worksheet Functions | |||
How do I put items from a list or column into other boxes in Excel | Excel Worksheet Functions | |||
insert a column of check boxes into a in excel | Excel Discussion (Misc queries) | |||
Column of check boxes | Excel Worksheet Functions | |||
Check boxes in a column | Excel Discussion (Misc queries) |