excel数据透视表_Excel数据透视表选择快速提示

excel数据透视表

To format a pivot table, you can select a specific section, such as one of the fields, or a grand total. When you point to a field heading, a black arrow will appear, if the Enable Selection setting is turned on.

要设置数据透视表的格式，您可以选择特定的部分 ，例如字段之一或总计。 当您指向字段标题时，如果启用“启用选择”设置，则会出现黑色箭头。

In the screen shot below, you can see the black arrow at the top of the Product field. Click in that spot, and all the Product item labels are selected.

在下面的屏幕快照中，您可以在“产品”字段顶部看到黑色箭头。 单击该位置，然后选择所有“产品”项目标签。

Click in that spot again, and the Product heading is selected, instead of the item labels.

再次单击该位置，将选择“产品”标题，而不是项目标签。

数据透视表字段设置快速提示 (Pivot Table Field Setting Quick Tip)

Instead of a single click on a heading cell, you can point to an outer field heading and double-click when the black arrow appears. In the screen shot below, the black arrow is on the Bran product heading cell.

您可以指向外部字段标题，然后在出现黑色箭头时双击，而不是单击标题单元格。 在下面的屏幕快照中，黑色箭头位于Bran产品标题单元格上。

Note: This trick won't work on an inner field, like Region, which has no other fields under it.

注意：此技巧不适用于内部区域(例如Region)，该内部区域下没有其他区域。

Double-click on the outer field heading, and the Field Settings dialog box opens. In there, you can change the layout and other settings, and add or remove subtotals.

双击外部字段标题，将打开“字段设置”对话框。 您可以在其中更改布局和其他设置，以及添加或删除小计。

Another way to open the Field Settings dialog box is to right-click on an item, and click Field Settings in the popup menu. This works for both inner and outer fields in the pivot table.

打开“字段设置”对话框的另一种方法是右键单击一个项目，然后在弹出菜单中单击“字段设置”。 这对数据透视表中的内部字段和外部字段均适用。

I find the double-click shortcut to be quicker and easier – as long as you remember to point somewhere that the black arrow appears.

我发现双击快捷键更加快捷方便-只要您记得指向出现黑色箭头的位置即可。

观看数据透视表选择视频 (Watch the Pivot Table Selection Video)

To see the steps for selecting section of an Excel Pivot Table, you can watch this short video tutorial.

要查看Excel数据透视表的“选择步骤”部分，您可以观看此简短的视频教程。

演示地址

翻译自: https://contexturesblog.com/archives/2012/05/15/excel-pivot-table-selection-quick-tip/

excel数据透视表