Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Down lists
I have a drop down list that has source values taken from F1:F50, as
new values are repeatedly added I would like the source to refer to the whole F column (ie - =$F:$F), but my drop down list now shows many blank spaces. How can I make the drop down list ignore the blank spaces? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Symbols in 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) | |||
How do I change the appearance of my drop down lists? | Excel Worksheet Functions |