Auto Filter With Auto Complete Ability

[Eastar]

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

 

[GoBow777]

Hello Easter:

Have a look here.

http://www.jegsworks.com/Lessons/numbers/basics/autofill.htm

Matt