is there a shortcut to open filter>contains box in excel?

1.7k views Asked by At

I use filters a lot.

Filter > contains option

But it is slow because everytime i need to do several clicks.

So, my question is, is there a shortcut to open filter, drop down, contains window?

1

There are 1 answers

0
Byron Wall On BEST ANSWER

Assuming you start with filtered data already, you need to have the header cell selected. From there: ALT+DOWN, F, A.

If the filter is not already created then throw in a CTRL+SHIFT+L at at the start.

If you are not in the header row, some combination of CTRL+ARROW keys can get you there. Ideally you have a block of data and can use CTRL+UP if you start in the correct column.