Any way I can make it stay showing
when I click off of the cell?

For a Data Validation drop down, you can't make the drop arrow always
visible but you could use some formatted borders or a fill color on that
cell that will make it stand out.

Another option is to use a Combo box from the Forms toolbar. It's similar to
a Data Validation drop down but the drop arrow is always visible.

Biff

wrote in message
oups.com...
Ok, so the filter picks one row and makes all the others disappear and
the list does the same but from a hidden list, correct? I guess I'm
asking if I did it right because I kind of figured it out by myself and
just want to make sure I did it right and just didn't find a back door
that might come back and limit me in some way in the future. My list
works fine for what I need except if I give it to someone else to use
they might not know there is a dropdown list on a cell because it
doesn't have that tell-tale arrow. Any way I can make it stay showing
when I click off of the cell?