For many versions of Microsoft Excel I found it annoying that it said Row labels and Column labels in a Pivot Table instead of the actual field headings.
In Excel 365 this can now eventually be changed to show field headings by default.
To do so, from within Excel itself, go to File – Options. Click Data.
Click Edit Default Layout.
From the Report Layout dropdown, select either Show in Outline Form or Show in Tabular Form.
Click OK twice.
In earlier versions, by default if you create a pivot table, instead of showing the field names, it will say row labels and column labels.
To see the field names instead, click on the Pivot Table Tools Design tab, then in the Layout group, click the Report Layout dropdown and select either Show in Outline Form or Show in Tabular form. The relevant labels will then be displayed.
Find out more about our Excel training in the London area.
Find out more about our Excel training in Wiltshire, Dorset, Somerset and Hampshire.