98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Changing the row header and column header to show the ac
Excel - Changing the row header and column header to show the ac
Resolved · Medium Priority · Version 365
Wed 10 Jul 2024, 08:12Delegate Adam said...
Adam has attended:
Excel Pivot Tables course
Excel - Changing the row header and column header to show the ac
Hey all - after some Pivot table know how please!
Is there an easy way to change the row header and column header to show the actual variable name instead of Row Label and Column Label? I am aware you can just overwrite them by double clicking where it says Row/column label, delete and write your variable name, however I was hoping I there was an easier way - we have some very long variable names and a large number of pivot tables!
Get back to me when you can, thanks!
Fri 12 Jul 2024, 16:14Trainer Martin said...
RE: Excel - Changing the row header and column header to show th
Hi Adam,
Thank you for your question to the forum.
You can set a variable label in a pivot table by selecting the pivot table and going to the DESIGN tab > REPORT LAYOUT > SHOW IN OUTLINE FORM
Once applied any other row/column headers used in the pivot table will be displayed dynamically
Hope this has helped. Please let me know if it has.
Kind regards
Martin Sutherland
(IT Trainer)
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display pictures on Chart Data PointReplacing a single chart data point bar with a picture. |
