NOTE: The settings available on each tab may vary slightly, depending on which type of pivot table is selected (Normal, OLAP-based, pre-2007, MDX support)Īt the top of the PivotTable Options window, there is a box that shows the current name of the selected pivot table.Įxcel automatically creates a numbered name for each new pivot table, and you can leave the default name as is, or change that name to something more meaningful, such as "SalesPivot".Īlthough the naming rules for other items, such as macros, or worksheets, are somewhat strict, the pivot table names are quite flexible. In the PivotTable Options window, the PivotTable name is shown at the top, and there are six tabs below that. Right-click on any cell in the pivot table.See how to open that dialog box, and change the settings Open PivotTable Options There’s another place where you can control the pivot table’s behaviour too – in the Pivot Table Options.
When you’re setting up a pivot table, you can use the Ribbon commands to change its appearance, and the source data, and several other settings.
You can always ask an expert in the Excel Tech Community or get support in the Answers community.More Pivot Table Tutorials Pivot Table Options Reset to Excel default - This will restore Excel's default PivotTable settings. PivotTable Options - This will launch the standard PivotTable options dialog. Report Layout - Pick from Compact, Outline or Tabular report layout.īlank Rows - The PivotTable will automatically insert a blank row after each item. Grand Totals - Turn Grand Totals on or off for both Rows and Columns Subtotals - Show subtotals at the top or bottom of each PivotTable group, or don't display subtotals at all. You can reset, import new settings, or change individual settings at any time. That PivotTable's settings will be automatically imported and used in the future. Layout Import - Select a cell in an existing PivotTable and click the Import button. To get started, go to File > Options > Data > Click the Edit Default Layout button.
0 kommentar(er)
