View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Louise Louise is offline
external usenet poster
 
Posts: 217
Default Data Validation / Allow List

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