Excel Pivot Table Repeat Row Labels: How to Do It Easily

Charts & pivot tables · Updated November 18, 2026

To repeat row labels in an Excel PivotTable, select the PivotTable, choose PivotTable Design > Report Layout > Show in Tabular Form, then choose Report Layout > Repeat All Item Labels. This fills the label cells down the rows, so each record shows its category instead of leaving repeated values blank.

What repeating row labels does

PivotTables commonly suppress repeated labels to make grouped reports shorter. For example, a report with Region and City as row fields may show the region name only beside the first city in each region. The cells beneath it look blank, even though those cities still belong to that region. Repeating labels fills those blank-looking cells with the appropriate region name.

This is a display and layout choice, not a change to the source data or the PivotTable’s calculations. It does not add extra records, alter sums, or change which rows belong to a group. It makes the report easier to scan, copy, print, or use as a flat-looking table. The repeated text is part of the PivotTable display; it does not mean Excel has inserted new source records.

The command is most useful when a PivotTable has more than one row field, such as Department and Employee, or Year and Month. With only one row field, there may be no visible blank labels to fill.

How to repeat all item labels in Excel 365

In Excel for Microsoft 365 on Windows, use these steps:

  1. Click a cell inside the PivotTable. This displays the contextual PivotTable tabs on the ribbon.
  2. Open PivotTable Design.
  3. Select Report Layout > Show in Tabular Form. This puts each row field in its own column.
  4. Open Report Layout again and select Repeat All Item Labels.

Look down the row-field columns to confirm that labels now appear beside each applicable detail row. If you want to undo the display change, return to PivotTable Design > Report Layout and choose Do Not Repeat Item Labels. The wording may be unavailable or disabled if the PivotTable is in Compact Form, so switch to Tabular Form first.

On Excel for Mac, select the PivotTable and look for the same options on the contextual PivotTable Design tab. Ribbon placement and labels can vary by release. If you are using Excel for the web and cannot find the command, open the workbook in the desktop app and make the layout change there.

Why the report layout matters

Compact Form is often Excel’s default. It combines multiple row fields into one column, using indentation to show their hierarchy. For example, a Region and City report may show both fields in a column called Row Labels. That format saves space, but it can be less convenient when readers need to filter, copy, or compare each field separately.

Tabular Form displays each row field in its own column, which gives repeated labels a clear place to appear. Outline Form also separates row fields into columns, but presents the hierarchy differently. If your goal is a straightforward list with one column per field, Tabular Form is usually the clearest choice. Switching layout changes the report’s appearance; it does not change the underlying source table.

There is a practical trade-off: repeating every label can make a long report wider or visually busier. For a compact on-screen summary, blank cells can communicate grouping effectively. For a report that will be shared, printed, or copied into another system, repeated labels are often easier to interpret without relying on nearby rows for context.

Using several row fields

Repeat All Item Labels applies to the row fields in the report, not just the first field. Consider a sales PivotTable with Country, City, and Salesperson in the Rows area, and Sum of Sales in Values. Without repetition, a country or city name may appear only at the start of its group. With repetition, each detail row displays the country, city, and salesperson information that applies to it.

This can make the report more useful when sorting or reading individual records. A row containing a salesperson’s name and sales total is easier to understand when its city and country are visible on that same line. However, repeated labels do not turn subtotals into detail records. Subtotal rows, grand totals, blank rows, and other report formatting remain separate parts of the PivotTable.

When there are nested fields, check the report after changing the layout. You may prefer to remove subtotals or adjust their position so that repeated labels and totals are easy to distinguish. These are separate layout choices: repeating labels fills item-label cells, while subtotal settings control where group calculations appear.

Example: a sales report with regions and products

Suppose the source list contains Region, Product, and Sales columns. A PivotTable places Region and Product in Rows and Sum of Sales in Values. In a compact report, Excel might display a region name once, followed by several product rows with a blank-looking Region cell. That is normal grouping behavior, not missing source information.

After switching to Tabular Form and repeating labels, a simplified result could look like this:

  • North | Chairs | 1,200
  • North | Desks | 850
  • South | Chairs | 940

Each line now identifies its region independently. This is helpful if someone copies the detail rows into a separate worksheet or reads a printed page where group headings are easy to lose. The totals remain the same as before; only the presentation of the row labels changes.

Common problems and how to fix them

  • The command is missing or disabled: First click inside the PivotTable so its contextual ribbon tabs appear. Then change the report to Tabular Form and check the Report Layout menu again.
  • Labels still appear in one column: The PivotTable may still be in Compact Form. Choose Show in Tabular Form; repeating labels does not itself separate multiple row fields into individual columns.
  • The report looks repetitive: That is the intended result. If the repeated text makes a short summary harder to read, use Do Not Repeat Item Labels or keep the compact layout for that view.
  • A field appears blank even after repetition: Check the source data for genuinely empty values, and confirm that the field is in the Rows area rather than Filters or Columns. Repeating item labels fills repeated group labels; it cannot supply a value that is missing from the data.
  • Some rows look different from detail rows: Check for subtotals, grand totals, or blank rows. Those elements are not ordinary item rows, so their appearance may not match the repeated labels on detail lines.

Also make sure you are working with a PivotTable rather than a normal range formatted to resemble one. The PivotTable Design tab appears when a cell inside an actual PivotTable is selected.

Repeating every field or just one

Repeat All Item Labels is convenient when the report should be self-contained across all row fields. If you want to repeat just one field, use that field’s settings instead: right-click an item in the relevant row field, choose Field Settings, open Layout & Print, and select Repeat item labels if the option is available for the current layout. The exact dialog availability can depend on the field and report layout.

Use the all-fields command when a reader needs every row to identify its full category path. Use a field-specific setting when one category is essential for interpretation but repeating every level would add clutter. For example, you might repeat Department but leave a lower-level subcategory visually grouped. Review the finished report to ensure the remaining blank cells are still understandable.

When a PivotTable is not the right format

Repeated labels improve readability, but a PivotTable is still a summary report with its own structure. If you need a clean, static list for a database import or a process that expects every row to contain literal values, consider creating a separate output table rather than relying on how the PivotTable is displayed. Copying and pasting values can produce a static copy, but that copy will not update automatically when the PivotTable refreshes.

For a report intended to remain interactive and refresh from its source, keep the PivotTable and use its layout options. For a one-time extract, a copied values-only table may be more appropriate. In either case, preserve the original PivotTable or source data if you may need to change the grouping, filters, or calculations later.

Frequently Asked Questions

Why does Excel leave PivotTable row labels blank?
Excel suppresses repeated item labels to make grouped reports shorter. The rows still belong to the displayed group; choose Repeat All Item Labels in Tabular Form to show the label on each applicable row.

Can I repeat labels without changing the source data?
Yes. Repeating labels changes the PivotTable’s display, not the source records or calculations. It does not write values into blank cells in the source table.

Can I repeat only one row label?
Usually, yes. Open that field’s Field Settings and look under Layout & Print for Repeat item labels. If you cannot select it, switch the report to Tabular Form and check that the field is in the Rows area.

Will repeated labels change my totals?
No. The command affects how row labels appear. It does not change the values being summarized, the filters, or the PivotTable’s calculations.

Can I use repeated labels in Compact Form?
The Repeat All Item Labels command is intended for a tabular report and may be unavailable in Compact Form. Choose Show in Tabular Form first, then apply the repeat-label setting.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.