Excel Pivot Table Row Labels: How to Change the Header

In Excel for Microsoft 365 on Windows, click the PivotTable cell that says Row Labels, type the heading you want, and press Enter. If you want separate column headings for each row field instead of the generic Row Labels heading, change the report layout to Tabular Form.

Why Excel shows Row Labels

Excel’s Compact Form places all fields in the PivotTable’s Rows area into one displayed column. That saves space and nests related categories, but the column heading is a general label: Row Labels. It does not necessarily tell a reader whether the rows contain departments, products, regions, or another category.

The heading is different from the row items beneath it. For example, a PivotTable might show Row Labels above North, South, and West. Those three entries are the items in a Region field; changing the heading does not rename the items or change the underlying source data. Likewise, editing the source column name is not the same as changing the visible Row Labels caption.

Excel uses this compact layout by default for many PivotTables. The generic caption is useful when several row fields are nested in one column, but it can be vague in a report or when the table is copied into another document. You can either give the caption a more informative name or choose a layout that displays the row-field names separately.

Change the header directly

To replace Row Labels with a custom heading while keeping the current layout:

Click any cell in the PivotTable to display its contextual ribbon tabs.
Find the cell containing Row Labels, usually at the top of the row-label column, and click it.
Type a concise heading, such as Product or Category, and press Enter.

This changes the displayed caption, not the PivotTable’s field selection or source data. If Excel reports that the PivotTable field name already exists, use a different caption. For example, if Product is already a field name in the PivotTable, try Product Category or Products. Avoid adding a trailing space just to make a duplicate-looking label work; it can make the heading confusing and harder to maintain.

If you cannot find the heading, check that the PivotTable is in Compact Form and that you selected its header cell rather than an item such as North or South. Also make sure the worksheet is not protected from editing. A cell outside the PivotTable, even one immediately above it, will not change the PivotTable caption.

Show individual field headings with Tabular Form

If your PivotTable has more than one field in the Rows area, Tabular Form is often clearer than renaming a single generic heading. Click inside the PivotTable, then choose PivotTable Design > Report Layout > Show in Tabular Form. Each row field gets its own column, and the headings identify those fields. For example, a report with Department and Employee in the Rows area can show Department and Employee as separate headings instead of nesting both under Row Labels.

Other report layouts may suit different reports:

Compact Form keeps row fields in one column and uses the generic Row Labels caption.
Outline Form displays row fields in a more separated, outline-style arrangement.
Tabular Form gives each row field a separate column, which is often easier to read, filter, or copy.

The layout options are under the PivotTable Design tab in Excel for Microsoft 365 on Windows. The contextual ribbon tabs on Excel for Mac can be arranged differently, but look for the PivotTable Design or Design tab and its Report Layout menu. Switching layouts changes the presentation of the report; it does not change the source data or the values being summarized.

Understand row-field names and row items

It helps to identify which part of the PivotTable you actually want to change. A row field is a source-data column placed in the Rows area, such as Region or Product. Row items are the distinct values in that field, such as North or Desk Chair. The Row Labels caption is the heading Excel displays for the compact row area.

Changing the caption only addresses the third item. If the items themselves are misspelled or inconsistent, correct the source data and refresh the PivotTable. If the field name is wrong, consider changing the source column heading and refreshing, or use a layout that exposes the individual field name. The exact best approach depends on whether you want to change the report’s appearance or the name of the data field used to build it.

For example, suppose a sales table has Region and Salesperson columns, both placed in Rows. In Compact Form, Excel can nest salesperson names beneath regions in one column headed Row Labels. A custom caption such as Sales hierarchy might describe that combined column. In Tabular Form, separate Region and Salesperson headings are more precise because each column represents a particular field.

Change a value heading separately

A PivotTable’s value heading is not the same as Row Labels. A value field might appear as Sum of Sales or Count of Orders, typically in the Values area. To rename it, right-click the value heading and choose Value Field Settings. Enter a new name in Custom Name, then select OK. Choose a name that is not identical to an existing field name if Excel rejects it.

For instance, changing Sum of Sales to Revenue changes the label shown for the summarized values; it does not change how Excel calculates the total. To change the calculation itself—for example, from Sum to Count—use the Summarize Values By options in Value Field Settings. Renaming a heading and changing the summary calculation are separate actions.

Common problems and useful checks

The label will not accept my name. Try a different caption if it duplicates a field name already used by the PivotTable. Confirm you are editing the actual PivotTable header cell.
I see Row Labels, but want two headings. Use Tabular Form. Replacing the generic caption cannot create separate columns for multiple row fields.
I changed a row item instead of the heading. Undo immediately if appropriate, or restore the item’s original text. Then select the cell above the items that contains Row Labels.
The heading seems to change after I rebuild the report. Recreating a PivotTable or changing its layout can produce a different caption. Check the current report layout and set the desired caption again if needed.
The source column name changed, but the PivotTable did not. Refresh the PivotTable using PivotTable Analyze > Refresh. If the source range or table structure changed, check the PivotTable data source as well.

In general, choose a heading that describes what a reader will see, and then check the result after refreshing or rearranging fields. A custom caption is a report label; it should not be treated as evidence that the source data or the underlying field has been renamed.

Which option should you choose?

Keep Compact Form and replace Row Labels when the report has one row field, or when a single heading for a nested group is perfectly understandable. Choose Tabular Form when readers need to distinguish multiple row fields, when you want a conventional grid with separate columns, or when you plan to copy the results into another worksheet or report. Outline Form can be useful when you want an indented hierarchy without combining all row fields into the same column.

There is no calculation advantage to one layout over another. These choices affect how the PivotTable is presented, not the source records or the summary values. If the goal is simply to make the report self-explanatory, a clear caption or separate field headings is usually preferable to changing source data solely for display.

Frequently Asked Questions

Can I rename Row Labels to any text?
Usually, you can type a descriptive caption directly into the Row Labels cell. Excel may reject a name that duplicates a field name already present in the PivotTable, so choose a distinct alternative if that happens.

How do I get rid of Row Labels entirely?
Change the report layout to Tabular Form or Outline Form using PivotTable Design > Report Layout. Those layouts show the row fields in a different structure; they do not simply hide the heading while leaving the same compact arrangement unchanged.

Will changing the header rename my source-data column?
No. Editing the PivotTable caption changes its displayed heading only. To rename the source column, edit the heading in the source table and refresh the PivotTable; check the field list and report afterward.

Can I change Row Labels when there are several row fields?
Yes, you can give the compact row area a custom caption. But if the fields need distinct names, switch to Tabular Form so each field has its own column heading.

Why does Excel say the field name already exists?
The caption you entered conflicts with a field name already used in the PivotTable. Try a more specific, distinct heading, such as Sales region instead of Region.

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.