drop down list shows first blank row after last list entry

G

Guest

When selecting the drop down list for my referenced list on another
worksheet, I get the blank row after the last list entry and have to page up
to find my selection. this doesn't happen on all columns with list
selections. Changing the name on the source worksheet or in the data
validation does not fix it, nor does copying the source data over to another
column and trying to rename it to the original name. Also, when doing this
this original named range disappears from the name range list, but when I go
to try and use it again it says it is already in use. this seems like a
simple thing, but like all things with Microsoft, nothing is simple
 
M

macropod

Hi Jerry,

I'm assuming this is a data validation list, in which case, if the list is :
.. typed into the validation dialogue box, you haven't added a comma after the last entry
.. referenced by a formula, the chosen range matches the list range.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down list starts from blank row 5
Filtered drop down list 2
Drop Down List Contains the List Header Row 1
drop down list 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop down list 2
Formatting a drop down list 2
Filter a Drop List ? 1

Top