Now go to the Layout & Print tab on the same dialog box, and tell Excel to display the pivot tables labels in separate columns, without grouping: You need to display your row labels in tabular form. Finally (and still in the same dialog box) tick the box to repeat item labels (at last!). I am struggling to find the 'repeat item labels' for an Excel Pivot table on the Mac version of Excel. Can anyone point me in the right direction? I couldn't find it! In Windows it is under Field SettingLayout and PrintRepeat Item Labels. Where is the equivalent function in a Mac? Many thanks, Remon. Jun 08, 2016 if I right click on a zone cell in my pivot table I do not see the option to 'layout & print or 'repeat row labels'. All I see is an option to change the field name and subtotals. There is nothing else to edit. I am right clicking on a zone cell. It did work but I just don't see how to replicate it! Sorry for the confusion. Under the report layout section, there is an option to deselect i.e. ‘Do not repeat item labels’ this would bring back your pivot table to default settings. Also read: Top 10 reasons for excel formulas not working.
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.
You can change the Report Layout setting, to either Outline form or Tabular form, so each row field is in a separate column.
Here’s the same pivot table in Outline form. The Region field is in column A, with a separate row for each new heading.
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.
Here’s the pivot table in Outline form, with repeating row labels.
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.
- Right-click one of the Region labels, and click Field Settings
- In the Field Settings dialog box, click the Layout & Print tab
- Add a check mark to Repeat item labels, then click OK
Now, the Region labels are repeated, but the City labels are only listed once.
Watch the Pivot Table Repeat Labels Video
Pivot Tables In Excel
To see the steps for repeating labels in all fields, or a single field, please watch this short Excel pivot table video tutorial.
Pivot Table Repeat Data
_________________