Nice trick Howard.

A keeper, for sure.

I either never saw before or definitely had forgotten.


Gord


On Thu, 8 Jan 2009 11:57:36 -0800, "L. Howard Kittle"
wrote:

Hi Louise,

Give this a try. Type in the "s" in the data validation cell but DON'T hit
Enter. Now click on the drop down arrow while the cell is still in the edit
mode. Should take you to the top of the s list.

HTH
Regards,
Howard

"Louise" wrote in message
...
Hi all

I have used the above function to create a drop-down list in a range of
cells in Excel. Is there any way that, when you click onto the drop-down
arrow, you can quickly get to, for example, items beginning with the
letter
's' in the list? I've tried simply pressing the key and it doesn't work.

Is there such a function?

THank you.
Louise