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?