View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eastar Eastar is offline
external usenet poster
 
Posts: 6
Default Auto Filter With Auto Complete Ability

Merry Chrismas
I have a list From A2:A8 - Sunday,Monday, Tuesday,Wednesday, Thursday,
Friday, Sunday
I create a Col Head on A1 and Use AutoFileter, so everytime, when I click
the arrow on the right side, the list will pop up.
My Question: Is there a way, so that the list can be auto-complete? Say, If
I type M, Monday will come out automatically?

thanks