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 he

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 he

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 he

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