Repeat Pivot Table Labels in Excel 2010

When you create a pivot table in Excel 2010 or Excel 2007, the row labels are in a compact layout – all the headings are listed in column A.

PivotLabelRepeat01

You can change the Report Layout setting, to either Outline form or Tabular form, so each row field is in a separate column.

PivotLabelRepeat02

Here’s the same pivot table in Outline form. The Region field is in column A, with a separate row for each new heading.

PivotLabelRepeat04 

Repeat the Row Labels

A new feature in Excel 2010 lets you repeat those row labels, so they appear on every row in the pivot table.

To turn on that feature for all the fields, select the Repeat All Item Labels on the Ribbon’s Design tab.

PivotLabelRepeat03

Here’s the pivot table in Outline form, with repeating row labels.

PivotLabelRepeat05

Repeating Labels for a Single Field

Instead of turning on repeating labels for the entire pivot table, you can apply the feature to a specific pivot table field.

In this example, the Region, City and Store fields are in the Row area, and we’ll turn on repeating labels for the Region field only.

  1. Right-click one of the Region labels, and click Field Settings
  2. In the Field Settings dialog box, click the Layout & Print tab
  3. Add a check mark to Repeat item labels, then click OK

PivotLabelRepeat06

Now, the Region labels are repeated, but the City labels are only listed once.

PivotLabelRepeat07

Watch the Pivot Table Repeat Labels Video

To see the steps for repeating labels in all fields, or a single field, please watch this short Excel pivot table video tutorial.

Or watch on YouTube: Repeat Headings in Excel 2010 Pivot Table

_________________

Share and Enjoy

  • Facebook
  • Twitter
  • Google Plus
  • LinkedIn
This entry was posted in Excel Pivot Tables, pivot table formatting. 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>