Drop Down lists

  • Thread starter Thread starter cribology - ExcelForums.com
  • Start date Start date
C

cribology - ExcelForums.com

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?
 
Thanks for the feedback although it doesn't completely work as my lis
with the values for the drop down is linked to another spreadsheet, s
values from say F51 to F60 are zeros. These zeros appear in the dro
down list as well and even when I alter the formula to hide zer
values, the drop down list shows them a blank options in the dro
down list. I am using Excel 97 by the way
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Drop down list reference 1
Linking drop down lists to another list 4
Excel Excel: How do I put a formula in a drop down list 11
Formatting a drop down list 2
Drop Down List 2
Using one source list for two depends drop-down list 2
Drop down list ???? 1

Back
Top