Home

Button for reset all filters

claym
Occasional Visitor

Hi,

First of all I am not at good at this but I looking for a way to use a button to reset all the filters I have.

To use one button instead of clear all the filters separately would be great as it is more effcient.

But as I wrote, I am not very good at this I was wondering if someone could show/teach me how to do it.

 

reset button.PNG

1 Reply

Hi,

 

I don't think you need to create a button to do so!

Excel already has a button to turn on/off the Filter, you can find it in the Sort & Filter group under the Data tab.

 

If you have some filters and you want to clear them all, you can go and click this button twice to turn the filters off and then turn it on, this is will clear them all.

 

Tip: the shortcut to this button is (Ctrl+Shift+L).

 

Hope that helps

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies