PivotTable report Click the field or item that you want to rename. On the Options tab, in the Active Field group, click the Active Field text box. Type a new name. Press ENTER.
- How do I change data labels in a PivotTable?
- Can I change the name in PivotTable?
- How do I change a row label?
How do I change data labels in a PivotTable?
On the Layout tab, in the Labels group, click Data Labels, and then click the option that you want. For additional data label options, click More Data Label Options, click Label Options if it's not selected, and then select the options that you want.
Can I change the name in PivotTable?
Click the PivotTable. In the PivotTable Analyze ribbon tab, click the PivotTable Name text box. Type a new name.
How do I change a row label?
You can change other Row Labels name by clicking the relative fields in the PivotTable, then rename it in the Active Field textbox.