Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Use the Correlation Analysis Tool in Excel
How to Import Delimited Text Files in Excel 2013
How to Rank by Percentile 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 Create Sparklines in Your Excel Dashboards
Set Up and Define Problems in Excel's Solver Add-In Utility
How to Run a Web Query in Excel
How to Import a Database Table in Excel
How to Import Straight Text in Excel 2013