Pivot Table Default Function If you add a number field to the Values area, the default summary function is Sum. However, if the source data has blank cells, or nonnumeric data, such as text or errors, in that field, the Count function is the default summary function. Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel. You can use an Excel table like in our example above. Tables are a great PivotTable data source, because rows added to a table are automatically included. Then select the Field Settings.
Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
We never share your email address with anyone - never have, never will. Privacy Policy.
It’s now possible to change the default layout for a new Excel PivotTable.
PivotTable default configuration has been on the ‘wish list’ for many years. It’s now in Excel 2016 for Windows, Office 365 customers only as part of the May 2017 update.
The changed defaults apply to all new PivotTables made on that computer. Presumably saved in the Registry?
Change PivotTable default
To setup from an existing PivotTable, open that PivotTable first.
Then go to File | Options | Data | Make changes to the default layout of PivotTables.
Click on Edit Default Layout …
Layout Import – choose a cell in an open PivotTable then click ‘Import’. That will copy those settings into the default layout.
SubTotals put subtotals at top or bottom or none.
Grand Totals can be on/off for either rows or columns
Report Layout Compact, Outline or Tabular.
Blank Rows can be added after each item.
PivotTable Options opens the standard option dialog.
Want More?
Office Watch has the latest news and tips about Microsoft Office.Independent since 1996. Delivered oncea week.
We never share your email address withanyone - never have, never will.Privacy Policy.