Hi all, wonder if anyone can help me?

I have set up some sets of data validation but when you click on the drop
down arrow on the cell, you have to scroll up to see the data you can choose
from. For example, my first set of data I have 17 options to choose from when
you click the drop down but only the last 3 show, thus the user having to
scroll up to see the rest. This is only a niggly problem but I am trying to
make this particular spreadsheet as simple as possible for the target
audience.

Does anyone know how I can force the drop down to start at the top of the
list, rather than the bottom?

Many thanks.

Rachel