How to Run the PivotTable Wizard in Excel
How to Use the Correlation Analysis Tool in Excel
How to Run a Web Query in Excel

How to Set Pivot Table Options in Excel

Step 1 of 6
Next Slideshow
Next Slideshow

Layout & Format tab options

Use the Layout & Format tab’s choices to control the appearance of your pivot table. For example, select the Merge And Center Cells with Labels check box to horizontally and vertically center outer row and outer column labels.

Use the When in Compact Form Indent Row Labels [X] Character(s) to indent rows with labels when the PivotTable report is displayed using the compact format. Use the Display Fields in Report Filter Area and Report Filter Fields Per Column boxes to specify the ordering of multiple PivotTable filters and the number of filter fields per column.

The Format check boxes appearing on the Layout & Format tab all work pretty much as you would expect. To turn on a particular formatting option — specifying, for example, that Excel should show some specific label or value if the cell formula returns an error or results in an empty cell — select the For Error Values Show or For Empty Cells Show check boxes.

To tell Excel to automatically size the column widths, select the Autofit Column Widths on Update check box. To tell Excel to leave the cell-level formatting as is, select the Preserve Cell Formatting On Update check box.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
How to Import Delimited Text Files in Excel 2013
How to Use AutoFilter on an Excel Table
How to Run the Excel PivotTable Wizard
How to Use the Custom AutoFilter on an Excel Table
How to Query an External Database in Excel