how do generate a drop down list with no blanks

G

Guest

How do I generate a drop down list that has no blanks in it? I used data
validation to pull the list names from another column. However, the column
has blanks in it. It would be great if there were a way I could delete the
blanks in the drop down list and sort it by alpha.
 
G

Guest

How do I generate a drop down list that has no blanks in it? I used data
validation to pull the list names from another column. However, the column
has blanks in it. It would be great if there were a way I could delete the
blanks in the drop down list and sort it by alpha.
Click to expand...
 
G

Guest

I tried that. For some reason it didn't work. I have 2003. Is this a bug
or something?
 

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
Data Validation to exclude blank cells 6
Filter not showing blanks option 6
How to Delete blanks between a range and populate only the names inthe given range 2
Data Validation List with blanks 1
Blanks non blanks in filter 2
Suggested Improvement to Excel Filter Drop-Down 1
Data Validation 5

Top