| 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) | |||
Linear Mode
