Repeat All Item Labels in the Pivot Table - Office 2010 & 2013

Repeat All Item Labels in the Pivot Table - Office 2010 & 2013

Procedures to Repeat All Item Labels in the Pivot Table - Office 2010 & 2013

(these functions are not available in 2003 or 2007)

The Pivot Table View can be customized by utilizing the Pivot Table Tools on the menu.


How to add Pivot Table Tools on your menu view


  1. Click inside your Pivot Table view to display the PivotTable Tools on your menu bar

  1. PivotTable Tools has two selections - Options tab and Design tab.

  1. Options tab displays a toolbar with multiple "options" to view your pivot table information. i.e. Pivot Charts





  1. Design tab displays a toolbar with multiple ways to view data within the pivot table. 






Design tab also displays different Pivot Table Styles you can use.

.

Note - this is available in 2010 & 2013 only. 


Options tab view


Design tab view

How to repeat item labels in your Pivot Table

  1. Item labels are displayed in the summary rows - not in details row.





Example: ACTBUS is the Item Summary Label and all names within ACTBUS show totals.








  1. To repeat the column heading in all detail rows  - double-click on heading (Full Name for this example) to display the Field Settings box.



  1. Select Layout & Print tab



  1. Click on Repeat Item Labels








Full Name is displayed on each row after selecting Repeat Item Labels.



 

How to repeat ALL item labels in your Pivot Table

Use the following method if you want to Repeat ALL Item Labels.



  1. Click on Design tab under Pivot Table Tools
  2. Click on the Report Layout filter
  3. Select Repeat All Item Labels from the drop down menu.
  4. Your view will repeat headings and rows for your pivot table.                                                        See example below




    • Related Articles

    • Printing Pivot Table Headings on every page – Office 2010

      Printing Pivot Table Headings on each page – Office 2010   Your Pivot Table spans several printed pages and the page, row and column headings only print on the first page – Follow the instructions below if you want the headings on every page Click on ...
    • Pivot table - repeat item labels

      This short 2 minute video will show you how to Repeat Item Labels on a Pivot Table.   
    • Pivot Table Quick Reference for Office 2007

      Pivot Table Quick Reference for Office 2007 Click Attachments to see the document
    • To save pivot table data to a new spreadsheets:

      To save pivot table data to a new spreadsheets: Right click on the tab for the pivot table. Select Move or Copy Select New Book Check “Create a Copy" Click on OK The pivot table data is now in a new sheet – you can save it as any name. Note – this ...
    • Pivot Table Cheat Sheet (Great Tips)

      Use this cheat sheet for quick how-to information on pivot tables.  Information includes dragging and dropping fields on and off the report, adding additional fields, creating new calculated fields, sorting, filtering, adding page breaks and more!