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
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
57,017
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
57,017
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,407
Messages
5,641,955
Members
417,249
Latest member
serrulate

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