You’ve built your Pivot Table in MS Excel, but the column and row labels are not showing the name of the relevant field. How can you fill the empty labels with the headings in a Pivot Table?
As shown below, the default set up for a Pivot Table is to have the words ‘Column Labels’ and ‘Row Labels’ instead of the actual names as shown in the Pivot Table tool. However, you may want the actual names of the column or row to be shown.
This is an easy fix. You just need to change the report layout. As shown below, while clicked on the Pivot Table:
- In the DESIGN ribbon
- Click on REPORT LAYOUT
- Choose ‘Show in Outline Form’ (or Tabular form)
As shown below, the actual name of the database column will appear in the Pivot Table.
You can learn more about Pivot Tables in our MS Excel Pivot Tables Online Course.
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.