数据透视表怎么全选所有字段_列出所有数据透视表字段和数据透视表项的宏

数据透视表怎么全选所有字段

If you're setting up a big pivot table, it's easy to lose track of what you've added, and what filters have been applied. To help you stay organized, I've created a macro to list all pivot fields and pivot items in the selected pivot table's row, column and filter areas. You can download the sample file, and test the macro in your own files.

如果您要设置一个大型数据透视表，则很容易忘记添加的内容以及应用了哪些过滤器。 为了帮助您保持井井有条，我创建了一个宏来列出所选数据透视表的行，列和过滤器区域中的所有数据透视字段和数据透视项目。 您可以下载示例文件，并在自己的文件中测试宏。

代码如何工作 (How the Code Works)

This macro finds any pivot fields that are in the pivot table layout, and lists all the pivot items in each field. You can read more about pivot fields and pivot items on my website.

该宏查找数据透视表布局中的所有数据透视字段，并列出每个字段中的所有数据透视项。 您可以在我的网站上了解有关数据透视字段和