Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do generate a drop down list with no blanks
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do generate a drop down list with no blanks
On the Data Validation window select 'list'. You will see a tickbox with
the 'ignore blanks' option. tick the box and you should be right "GMRJEN" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do generate a drop down list with no blanks
I tried that. For some reason it didn't work. I have 2003. Is this a bug
or something? "lizM" wrote: On the Data Validation window select 'list'. You will see a tickbox with the 'ignore blanks' option. tick the box and you should be right "GMRJEN" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation - clear blanks from drop down | Excel Worksheet Functions | |||
generate a selective list | Excel Discussion (Misc queries) | |||
How do I generate Errors for Drop-Down Lists? | Excel Discussion (Misc queries) | |||
clearing blanks in drop-down list | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |