• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1898
  • Last Modified:

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
2 Solutions
You can try Alt {Down} F {left} {down}
Alt + Down
Press F then A
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.
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now