QAT command button for filter on selection

Trouttrap2

Well-known Member
Joined
May 11, 2010
Messages
612
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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,312
Office Version
  1. 365
Platform
  1. Windows
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.
 
Solution

Trouttrap2

Well-known Member
Joined
May 11, 2010
Messages
612
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,312
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,121
Messages
5,622,861
Members
415,935
Latest member
kes1973

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top