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.



This entry was posted in Formatting. Bookmark the permalink.

Leave a Reply

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