| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i assure a pull down list begins at the top of the range?
I am using a range to validate and entry but the pull down always goes to the
bottom of the range. How do I get it to start at the top? Thanks, BCW |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i assure a pull down list begins at the top of the range?
If the cell with the data validation list is blank, and there is a blank
cell at the end of the source range, that's what will be selected when the list is opened. You could use a dynamic range as the list source. There are instructions he http://www.contextures.com/xlNames01.html BCW wrote: I am using a range to validate and entry but the pull down always goes to the bottom of the range. How do I get it to start at the top? Thanks, BCW -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i assure a pull down list begins at the top of the rang
Thanks,
It might be time for me to take my skills to the next level. Thanks for your link. Blanton "Debra Dalgleish" wrote: If the cell with the data validation list is blank, and there is a blank cell at the end of the source range, that's what will be selected when the list is opened. You could use a dynamic range as the list source. There are instructions he http://www.contextures.com/xlNames01.html BCW wrote: I am using a range to validate and entry but the pull down always goes to the bottom of the range. How do I get it to start at the top? Thanks, BCW -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull-down List | Excel Discussion (Misc queries) | |||
| Pull value of a range within a range of data | Excel Discussion (Misc queries) | |||
| Ho to pull inmormation from a list? | Excel Worksheet Functions | |||
| delete from pull down list | Excel Discussion (Misc queries) | |||
| How do I set up a cell with a pull down list? | Excel Discussion (Misc queries) | |||
Linear Mode
