| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Hello Easter:
Have a look here. http://www.jegsworks.com/Lessons/num...s/autofill.htm Matt Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
| Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
| Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
| Auto complete | Excel Worksheet Functions | |||
| ability to auto file column(s) on a pivot table | Excel Worksheet Functions | |||
Linear Mode
