Repeat Item Labels in a Pivot Table

Note: There is an updated post with detailed instructions for repeating pivot table row labels. Refer to that page

Pivot Tables for Excel 2007One of the new features in Excel 2010 relating to Pivot Tables is the ability to repeat the item labels. Why is this useful?

Pivot tables are often used as a means of extracting information from a database, and then the pivot table itself is used as a database. But previously you had to do some work to fill in the blank spaces with the label heading.

Now, you can click on the Repeat Item Labels switch and it will do it for you.

 

Learn more at our live advanced Excel courses in South Africa. Visit www.AuditExcel.co.za Live Excel Training page