How can I fill the empty labels with the headings in a Pivot Table

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.

fill the empty labels with the headings in a Pivot Table

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)

fill the empty labels with the headings in a Pivot Table

As shown below, the actual name of the database column will appear in the Pivot Table.

fill the empty labels with the headings in a 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 live courses and live in South Africa look at the MS Excel training courses available. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.