Try creating a dynamic range for your list. Debra Dalgleish has some
excellent instruction on her site at
http://www.contextures.com/xlNames01.html#Dynamic

--
Regards

Roger Govier


"cribology - ExcelForums.com"
wrote in message
...
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?