Please help! I'm using a simple data validation to allow for drop down values
to select from. To allow for future addition of values, I've included a
number of blank cells (with ignore blank setting). Whenever the cell is
dropped down, the focus is on a blank cell at the bottom of my list of
values, and I then need to scroll up to see the values. Can anybody help with
this? Thanks.