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?
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?
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.