asked on
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
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
Microsoft Excel
Last Comment
AndresHernando
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.