Excel 2007 Keyboard shortcut to to Text Filters

What is the keyboard shortcut to get to "Text Filters"- "Contains..." option?

The way I'm getting there now is to left click on the Auto Filter dropdown for the relevant column and then key "f" then "a".

I want to avoid having to use the mouse when the active cell is on the pertinent column.

Thanks, --Andres
AndresHernandoAsked:
Who is Participating?
 
Shanan212Connect With a Mentor Commented:
Alt + Down
then
Press F then A
0
 
nutschConnect With a Mentor Commented:
You can try Alt {Down} F {left} {down}
0
 
AndresHernandoAuthor Commented:
Important detail:  there must be text in the table for "Text Filter" to work.  If only numbers are in the table, "Text Filter" will not be available.

The upshot of this is that you cannot search for strings of numbers, such as filter all entries that contain "33" unless there is text in the table.

Thank you both for your answers.  I gave "best solution" to Shanan because it does not require scrolling down (I'm splitting hairs here).  Thanks again, nutsch and Shanan.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.