View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default data validation list box help

Remove the blank cells from the bottom of the list range.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:06:02 -0700, LTOSH
wrote:

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???