Add current selection to Filter - Excel shortcut

[chriscorpion786]

Hi all,

Is there any shortcut key to "add current selection to filter " in Excel.
Once we filter some items, and want to add another selection, how do we select those items first and then add current selection. Is there a shortcut key to this.

Many thanks,
Mustafa

 

[Joe4]

Not that I know of.
But you may be able to create your own, using VBA.
Of course, it all is dependent upon your data structure, and exactly how you want it to work exactly.

Also, not sure if you are aware, but Excel 365 has a new FILTER function in Excel. It is really cool.
Check it out if you are not familiar with it: FILTER function - Microsoft Support