If the cell containing the list has an entry that is in your source list,
then the list will open at that point.

If the cell is blank, and you have left an empty cell at the bottom of your
source list to allow keyed in entries, or future expansion, move the empty
cell to the top of the list.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Kevin" wrote in message
...
I have a list for data validation. It is a long list and when I click on the
cell the first thing I see is the options from the end of the list. Can I
change a setting (no code) so that the list of options first shown when you
click in the cell is the first item on the list

thanks
--
Kevin