I'm sorry...i guess i'm not understanding what i need to do.
I opened the worksheet that has all the columns and am not sure what it is
i'm to delete. For example...i have column 1 and there are about 10 cells of
information.
then of course blank cells after that for input if needed. I went in and
highlighted from the first blank cell and just pulled mouse down and then hit
delete.
i went back into my workout to test the drop down and it is still the same.

What am i not doing?
I'm sorry i'm nuts...just can't figure it out.
Thanks!

"Gord Dibben" wrote:

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???