I have data validation on fields tied to lists, but when opened the last line
of the list (in my case a blank as entire column defined) is displayed, and
the user would always have to arrow up to see the list items.
I have data validation on fields tied to lists, but when opened the last line
of the list (in my case a blank as entire column defined) is displayed, and
the user would always have to arrow up to see the list items.
Instead of including blank cells, you could use a dynamic range as the
list source. There are instructions here:
http://www.contextures.com/xlNames01.html
LynnSouthan wrote:
> I have data validation on fields tied to lists, but when opened the last line
> of the list (in my case a blank as entire column defined) is displayed, and
> the user would always have to arrow up to see the list items.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Thank you so much. Not sure where things got crossed between names and lists
and ..... but this looks better. Appreciate your help.
"Debra Dalgleish" wrote:
> Instead of including blank cells, you could use a dynamic range as the
> list source. There are instructions here:
>
> http://www.contextures.com/xlNames01.html
>
>
> LynnSouthan wrote:
> > I have data validation on fields tied to lists, but when opened the last line
> > of the list (in my case a blank as entire column defined) is displayed, and
> > the user would always have to arrow up to see the list items.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>
You're welcome. I'm glad it looks better now.
LynnSouthan wrote:
> Thank you so much. Not sure where things got crossed between names and lists
> and ..... but this looks better. Appreciate your help.
>
> "Debra Dalgleish" wrote:
>
>
>>Instead of including blank cells, you could use a dynamic range as the
>>list source. There are instructions here:
>>
>> http://www.contextures.com/xlNames01.html
>>
>>
>>LynnSouthan wrote:
>>
>>>I have data validation on fields tied to lists, but when opened the last line
>>>of the list (in my case a blank as entire column defined) is displayed, and
>>>the user would always have to arrow up to see the list items.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks