OmniDocHow to Rename Pivot Table Headers and Field Names
Learn how to change pivot table headers, row and column captions, and value field names in Excel, and what to do when a rename does not stick.
Pivot table headers can be hard to read when the default captions are vague, such as a generic label above the row items or a value field named "Sum of Revenue" when your report needs "Revenue, Q1." If you searched for how to change pivot table headers, the fix depends on which header you mean. Some captions can be typed over in the grid, some are set in a separate dialog, and some come from the source data and only change after a refresh.
This guide covers the general Excel method for renaming row and column captions, value field names, and the underlying source headers. It also explains the common errors that stop a rename from working, and how to confirm the result. The steps are written for a standard Excel pivot table, so the exact ribbon names may differ slightly by version.
How do you change pivot table headers? The short answer
Click the header cell you want to change, type the new name, and press Enter for row and column captions. For value fields, open the value field settings and enter a custom name. For field names that come from your data, rename the column header in the source sheet and refresh the pivot table.
| Your situation | What to do | Why |
|---|---|---|
| The label above the row items or column items is generic | Click that caption cell in the pivot table and type a new label | Captions in the top-left area of the table are editable |
| A value column says Sum of or Count of plus a field name | Open the value field settings and enter a custom name | The custom name replaces the caption without changing the calculation |
| The field name comes from a column in your data | Rename the column header in the source sheet, then refresh | The pivot table reads field names from the source range |
| Excel says the name already exists | Choose a name that is not used by any field or item | Pivot field names must be unique within the table |
| Headers are missing or hidden | Check the field headers setting on the pivot table tools | Field headers can be turned off, which hides the captions |
Before you start
- Decide which header you need to change. A row or column caption, a value field name, and a source column header are handled differently. Changing the wrong one wastes time, and a rename in one place may not appear in another.
- Check whether the pivot table is linked to a range or a table. If the pivot table reads from a fixed range, new columns added later will not appear until you change the source. Renamed headers in a formatted table usually flow through on refresh.
- Back up the file or copy the sheet. Renaming source headers changes every formula and pivot that references them. A copy lets you compare before and after.
- Know the names other people use. If someone else builds formulas or charts from the pivot table, changing a value field name can break a reference that depends on the old text. Confirm the new names with them first.
- Make sure the cursor is inside the pivot table when you open the field settings. If you click outside the table, the pivot table tools may not appear.
Renaming pivot table headers in Excel, step by step
- Identify the header type. Click the cell in the pivot table and look at what it contains. If it is a row or column caption, use the typing method. If it is a value like Sum of Sales, use the value field settings. If it is a field name that appears in the field list, you will need the source data.
- Rename a row or column caption. Click the caption cell in the top-left area of the pivot table, type the new text, and press Enter. The change applies immediately to that caption, and the field items below it stay the same.
- Rename a value field. Right-click any number in the value area, then choose the value field settings option. Enter the new name in the custom name box, and confirm with OK. The label changes in the pivot table, but the calculation stays the same.
- Rename a source column header. Go to the data sheet, click the header cell for the column, and type the new name. Keep the header in the first row of the source range so Excel can read it as a field name.
- Refresh the pivot table. Click inside the pivot table, open the data options, and refresh. Field names that come from the source will now show the updated text. If they do not, check that the source range still includes the renamed column.
- Resolve duplicate-name errors. If Excel refuses the new name, it usually matches another field or an existing caption. Add a qualifier, such as a quarter or region, to make the name unique.
- Turn field headers on or off if needed. The field headers toggle on the pivot table tools controls whether the captions show. Turn it on again if captions have disappeared after a layout change.
- Save and check the result. Save the file and compare the pivot table with the source data to confirm each caption matches the field it describes.
Check the result
| Check | How to see it | If it's wrong |
|---|---|---|
| Caption text | Look at the top-left area and the column headings | Retype the caption, or check that you did not edit a data cell instead |
| Value field name | Compare the value area heading with the custom name you set | Reopen the value field settings and confirm the name was saved |
| Source header | Look at the first row of the data sheet | Rename the column in the data sheet, then refresh |
| Refresh behavior | Refresh the pivot table and check the headers again | If the old name returns, the source header may still hold the old text |
| Formulas and references | Check any formulas or charts that point to the pivot table | Update references that use the old caption text |
If a rename reverts after refresh, the source column is the usual cause. If the header appears correctly but your formulas break, the old name was probably used in a lookup, and that lookup needs the new text.
Frozen headers and print titles are separate
People often search for how to change pivot table headers when they really want headers to stay visible while scrolling. Freezing panes keeps rows or columns in view on screen, and print titles repeat rows or columns on each printed page. Neither changes the text of a pivot table caption. Use the renaming steps above for the text, and use the sheet view and page setup options for scrolling and printing.
❓ FAQ
1. Why can't I type over a value field name directly?
Value fields show a calculation label, such as Sum of or Count of, that Excel generates. You rename it through the value field settings so the calculation stays intact.
2. Will my renamed header survive a refresh?
Captions you typed over in the pivot table usually stay, while source field names follow the column header in the data. If a name reverts, rename the source column and refresh again.
3. Why does Excel say the field name already exists?
Each field in a pivot table needs a unique name, and a new name that matches another caption or field is rejected. Add a word such as a year or region to make it distinct.
4. Do I need to rebuild the pivot table to change headers?
No. Renaming captions and value fields does not require a rebuild. You only need to change the source and refresh when the header comes from the data.
📝 Summary
Changing pivot table headers in Excel means choosing the right method for the header type: typing over captions, editing value field settings, or renaming the source column and refreshing. Check each change against the source data, and use a unique name when Excel rejects a duplicate.
