Repeat Headings in Excel 2010 Pivot Table

http://www.contextures.com/xlPivot01.html When you create a pivot table in Excel 2010 or Excel 2007, the row labels are in compact form, with all the headings in column A.

You can change the layout, so each field is in a separate column.

In Excel 2010, you can also change a setting so that the pivot table headings are repeated in each row, instead of showing only once.

Watch this Excel tutorial video, to see the steps for changing the layout and repeating labels in an Excel pivot table.

Category:

Science & Technology

Tags:

• Excel
• Excel pivot
• pivot table
• Excel pivot table
• pivot table labels
• pivot table repeat labels
• pivot table repeat headings
• PivotTable
• Contextures

[10Shlomi10]

excatly what I was looking for!!!

Thanks A Lot!