| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank top line in a drop down box
I want the first line in the drop down box to be blank - can anyone tell me
how to do this? -- Regards ~ tates |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
blank top line in a drop down box
For a Data Validation drop-down, just make sure the first cell in the
validation list is blank. -- Gary''s Student - gsnu200823 "tates" wrote: I want the first line in the drop down box to be blank - can anyone tell me how to do this? -- Regards ~ tates |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
blank top line in a drop down box
I went to INSERT/NAME/DEFINE and changed Refersto: to include a blank line
plus the cells with the list I do want. Then I tried typing the word BLANK - changed the type to white so it wouldn't show, that didn't work either. -- Regards ~ tates "Gary''s Student" wrote: For a Data Validation drop-down, just make sure the first cell in the validation list is blank. -- Gary''s Student - gsnu200823 "tates" wrote: I want the first line in the drop down box to be blank - can anyone tell me how to do this? -- Regards ~ tates |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
blank top line in a drop down box
It might be there, but not easily recognizable. Try putting the blank as the
second item in the list, not the first. What happens? -- Gary''s Student - gsnu200823 "tates" wrote: I went to INSERT/NAME/DEFINE and changed Refersto: to include a blank line plus the cells with the list I do want. Then I tried typing the word BLANK - changed the type to white so it wouldn't show, that didn't work either. -- Regards ~ tates "Gary''s Student" wrote: For a Data Validation drop-down, just make sure the first cell in the validation list is blank. -- Gary''s Student - gsnu200823 "tates" wrote: I want the first line in the drop down box to be blank - can anyone tell me how to do this? -- Regards ~ tates |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
blank top line in a drop down box
I added a Validation Rule and got the blank line. Thanks for your help
-- Regards ~ tates "Gary''s Student" wrote: It might be there, but not easily recognizable. Try putting the blank as the second item in the list, not the first. What happens? -- Gary''s Student - gsnu200823 "tates" wrote: I went to INSERT/NAME/DEFINE and changed Refersto: to include a blank line plus the cells with the list I do want. Then I tried typing the word BLANK - changed the type to white so it wouldn't show, that didn't work either. -- Regards ~ tates "Gary''s Student" wrote: For a Data Validation drop-down, just make sure the first cell in the validation list is blank. -- Gary''s Student - gsnu200823 "tates" wrote: I want the first line in the drop down box to be blank - can anyone tell me how to do this? -- Regards ~ tates |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you drop the line in a line graph? | Charts and Charting in Excel | |||
| insert a blank in every second line of a row | Excel Discussion (Misc queries) | |||
| How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions | |||
| If cell is not blank, then line out row | Excel Worksheet Functions | |||
| Drop line in Line Chart | Charts and Charting in Excel | |||
Linear Mode
