QAT command button for filter on selection

[Trouttrap2]

I am using Office 365. There used to be a QAT command button for 'filter on selection'. I can't seem to find that button to place in my QAT. Now I have to right click>filter and navigate through the menu to select 'filter by selected cells value'. There are other choices in the menu, but I am only interested in 'value'.

I would like a QAT button to filter by selected cells value instead of right clicking. Or maybe there is a keyboard shortcut. I would like to know that too. The only filter button I can find for the QAT is 'auto filter' and that is not what i want.
Thank you

 

[Fluff]

The only filter button I can find for the QAT is 'auto filter' and that is not what i want.

Actually it is what you want, it's just badly labelled.

 

[Trouttrap2]

Thank you Fluff. It seems like the auto filter i had before was only enabling or disabling the 'auto filter' buttons in the column headers. But after I removed and replace the QAT auto filter button. It now works. Thanks again.

 

[Fluff]

You're welcome & thanks for the feedback.