Auto Filter With Auto Complete Ability

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eastar - 26 Dec 2007 17:02 GMT

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

Reply to this Message

GoBow777 - 26 Dec 2007 20:45 GMT

Hello Easter:

Have a look here.

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

Matt

Eastar;603610 Wrote:

> Merry Chrismas
> I have a list From A2:A8 - Sunday,Monday, Tuesday,Wednesday, Thursday
[quoted text clipped - 8 lines]
>
> thank

--
GoBow777

Reply to this Message