Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Down LIsts
Hey.
I am using several drop down lists in a worksheet. Some of the drop downs show the items starting at the top of the list, others start half way through a list. Can i make then all start with the first item on the list? Thanks :) |
#2
|
|||
|
|||
Is the drop-down list via cell references? To check, click in the first cell
with the drop-down and, from the menu bar, select Data / Validation. On the Settings tab, does the Allow drop-down say List? If so, what is in the Source text box? I'm guessing it says something like =C1:C6. If that validation were autofilled to the next cell down, the next cell's validation source would be =C2:C7; you're effectively scrolling off the list of values. To keep from scrolling, change the first cell's validation list source to absolute references, something like =$C$1:$C$6. Then you can autofill, and the validation list source will remain constant. "excelnewbie" wrote: Hey. I am using several drop down lists in a worksheet. Some of the drop downs show the items starting at the top of the list, others start half way through a list. Can i make then all start with the first item on the list? Thanks :) |
#3
|
|||
|
|||
Hi bpeltzer.
I have a named array in the source text box rather than just cell references. The named array has absolute references i.e. $c$1:$c$50 I have several empty cells included in the array to allow for additional values later. The cells that have information in them are at the top of the array tho...? Any suggestions? Thanks again. "bpeltzer" wrote: Is the drop-down list via cell references? To check, click in the first cell with the drop-down and, from the menu bar, select Data / Validation. On the Settings tab, does the Allow drop-down say List? If so, what is in the Source text box? I'm guessing it says something like =C1:C6. If that validation were autofilled to the next cell down, the next cell's validation source would be =C2:C7; you're effectively scrolling off the list of values. To keep from scrolling, change the first cell's validation list source to absolute references, something like =$C$1:$C$6. Then you can autofill, and the validation list source will remain constant. "excelnewbie" wrote: Hey. I am using several drop down lists in a worksheet. Some of the drop downs show the items starting at the top of the list, others start half way through a list. Can i make then all start with the first item on the list? Thanks :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down lists | Excel Discussion (Misc queries) | |||
unrestricting drop down lists | Excel Worksheet Functions | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
multiple drop down lists | Excel Discussion (Misc queries) | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) |