the list in my data validation list opens at the bottom to blank cells. is there anyway to control where the list opens (say maybe the top)?
the list in my data validation list opens at the bottom to blank cells. is there anyway to control where the list opens (say maybe the top)?
Brian
Can you try explaining that again... I don't know what you mean.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi, when i click on a data validation list and the list opens, it opens just below the last selection available. can i make it open at the 1st selection? this happens to me once in a whiole w/ different list i make and i just need to know what i'm doing wrong. thank you, Brian
I have never seen this problem. What Version are you working with?
ChemistB
If you have already made a selection in the list, the next time you select it will open to that selection..
I am not sure you can get it to always open on top, unless it is the first time you make a selection.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks