MS Excel: Repeating rows in Pivot Table

Repeat item labels in rows

1. In the PivotTable report, click the row label that you want to repeat.

This displays the PivotTable Tools, adding an Options and a Design tab.

2. On the Options tab, in the Active Field group, click Field Settings.

 Tip    You can also right-click the row label that you want to repeat, and then click Field Settings.

3. Click the Layout & Print tab, and then select the Repeat item labels check box.

 Tip    To remove the repeated labels, clear the Repeat item labels check box.

4. To show the repeated labels in the PivotTable, make sure that Show item labels in tabular form is selected.

 Notes 

• When you edit any of the repeated labels, the changes you make are automatically applied to all other cells with the same label.
• When you change the format of all repeated labels by selecting the item label in the summary row or all repeated labels, the format is automatically applied to all other cells with the same label. However, you can also change the format of individual repeated labels without applying the same formatting to other cells with the same label.
• Repeated labels are shown in tabular form only. They are not shown when compact form or outline form are applied.

Repeat item labels in columns

1. In the PivotTable report, click the column label that you want to repeat.

This displays the PivotTable Tools, adding an Options and a Design tab.

2. On the Options tab, in the Active Field group, click Field Settings.

 Tip    You can also right-click the column label that you want to repeat, and then click Field Settings.

3. Click the Layout & Print tab, and then select the Repeat item labels check box.

 Tip    To remove the repeated labels, clear the Repeat item labels check box.

 Notes 

• When you edit any of the repeated labels, the changes you make are automatically applied to all other cells with the same label.
• When you change the format of all repeated labels by selecting the item label in the summary row or all repeated labels, the format is automatically applied to all other cells with the same label. However, you can also change the format of individual repeated labels without applying the same formatting to other cells with the same label.
• Repeated labels are shown in compact form for outer fields only. Repeated labels are not shown when outline form is applied.

Turn repeated item labels on or off for all fields

1. Click anywhere in the PivotTable for which you want to repeat labels.

This displays the PivotTable Tools, adding an Options and a Design tab.

2. On the Design tab, in the Layout group, click Report Layout.

3. Do one of the following:

• To display repeated item labels, click Repeat All Item Labels.
• To remove repeated item labels, click Do Not Repeat Item Labels.

4. Click anywhere in the PivotTable for which you want to repeat labels (Test_O15).
5. This displays the PivotTable Tools, adding an Options and a Design tab(Test_O15)