Imagine that we have an existing PivotTable laid out exactly the way we want it to be, where we have spent a lot of time on it. What happens to those settings though? Do we have to repeat them again and again for future PivotTables that we create? Well, it is possible to import these settings, otherwise will have to edit them one by one, individually. If we change the Default Settings of a PivotTable, all these settings will take place to all the new PivotTables in all future Workbooks. PivotTables that already exist, will not be affected at all by the changes that are made to the Default Layout. If you want to find out, how to modify and change the Default Layout of PivotTables just keep on reading the post below.
We must select the File tab so we can move into Backstage View.
Once we select the command Options, the Excel Options dialog box appears as shown below, where from the left we select the category Data. Once the category Data is selected, we locate the area Data Options in the middle of the Excel Options dialog box. Then at the right of where it mentions Make Changes To The Default Layout Of PivotTables, we select the Edit Default Layout button as shown below.
Subtotals: We can either show Subtotals at the top or bottom of each PivotTable group, or we can even not display the Subtotals at all.
Grand Totals: We can either turn on or off the Grand Totals for both Rows and Columns.
Report Layout: Once selected, from the drop-down menu we can either select to be shown in Compact, Outline or Tabular Report Layout.
Blank Rows: If we activate the command, the PivotTable will automatically insert a Blank Row after each item.
PivotTable Options: By selecting the PivotTable Options button, the PivotTable Options dialog box will appear as shown below. This dialog box is separated in the following tabs where we can use and are: Layout & Format, Totals & Filters, Display, Printing and Data.
Below you can check out the video describing How To Change The Default Layout of PivotTables in Excel.
Don’t Forget To Subscribe To My YouTube Channel.
This entry was posted in Word 365 ProPlus English and tagged backstage view, Blank Rows, Cell, Columns, Compact, Data, Display, Edit Default Layout, File, Grand Totals, How To, How To Change Default Layout Of PivotTables in Excel?, Import, Know How, Layout & Format, Layout Import, Make Changes To The Default Layout Of PivotTables, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Word, My YouTube Channel, Office Smart, Office System, OfficeSmart, Options, Outline, philippospan, PivotTable, PivotTable Options, Printing, Report Layout, Reset To Excel Defaults, Rows, Smart Office, smartoffice, Subscribe, Subtotals, Tabular Report Layout, Tip & Tricks, Totals & Filters.