Centre Column Headings in Excel Pivot Table

If your pivot table has column labels, and more than one field in the Values area, you might want to centre the column labels.

For example, in the pivot table shown below, there are Region headings in the Column Labels area. Below each Region label, there are headings for the Qty Sold and $ Sales fields.


The East label is at the far left of its Qty Sold heading. It’s hard to tell which Region headings go with which Value headings.

To make the pivot table easier to read, you can centre the Region labels over their Value field headings.

To centre the column headings in Excel 2007:

  1. Select a cell in the pivot table
  2. On the Ribbon, under the PivotTable Tools tab, click Options
  3. At the far left, in the PivotTable group, click Options


  1. On the Layout & Format tab, in the Layout section, add a check mark to Merge and Center Cells With Labels


  1. Click OK

Each Region column label is now centred over its Value field headings.




P.S. For more information on Pivot Tables, please see the Pivot Table Tutorials on the Contextures Website.


Share and Enjoy

  • Facebook
  • Twitter
  • Google Plus
  • LinkedIn
This entry was posted in Excel Pivot Tables, pivot table tutorial, pivot tables. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>