Share via

Pivot Table display name

Anonymous
2021-09-23T06:05:58+00:00

Hi ,

I am pretty new in here. May I know any ways to show the Excel Table column heading name inside the Pivot Table either Rows or Columns?

Greatly appreciated. Thanks.

Viv Ngern

Eg: How to show the actual text of "SI" or "NS" in Pivot Table either in Rows or Columns?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-09-23T08:14:27+00:00

    Click anywhere in the pivot table.

    Activate the Design tab of the ribbon (to the right of PivotTable Analyze).

    In the Layout group, click the Report Layout drop-down and select 'Show in Outline Form' or 'Show in Tabular Form'.

    7 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-09-24T06:05:26+00:00

    Many thanks to HansV

    0 comments