可以在Excel中创建“清除过滤器”按钮或选项吗？ [英] Possible to create an Clear Filters button or option in Excel?

问题描述

嘿所有，



有没有办法创建一个清晰的过滤器按钮？ 我创建了一个报告并将其部署到一个sharepoint站点。 此网站会删除编辑报告的所有Excel选项，只是将其作为视图/与报告进行交互。 所以我不能去功能区
并点击那里的清除过滤器按钮。 我需要在报告中创建一些清除所有过滤器/切片器选项的内容。 有什么想法？ 任何建议将不胜感激！

Hey All,

Is there a way to create a clear filters button?  I created a report and deploy it a sharepoint site.  This site removes all the Excel options of editing the report and just has it as a view/interact with the report.  So I cannot go to the ribbon and hit the clear filter button that is there.  I need to create something in the report that will clear all filters/slicer selections.  Any thoughts?  Any suggestions would be appreciated!

推荐答案

>>>我需要在报告中创建一些清除所有过滤器/切片器选择的内容。  



根据您的描述，您可以使用VBA清除所有过滤器，请参阅以下代码：

>>>I need to create something in the report that will clear all filters/slicer selections.  

According to your description, you could use VBA to clear all filters, refer to below code:

Sub ClearFilter()
    ActiveSheet.ShowAllData
End Sub

欲了解更多信息，请参阅< a href ="http://excelribbon.tips.net/T012254_Clearing_Only_Filtering_Settings.html">
仅清算过滤设置

For more information, please refer about Clearing Only Filtering Settings

这篇关于可以在Excel中创建“清除过滤器”按钮或选项吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！