Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I repeat labels in a Pivot Table
I have a pivot table and I want the outer labels repeated on each line. I
thought this would be easy but can't figure out how to do this. |
#2
|
|||
|
|||
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. To create the table with a heading on each row, you can copy the table, and fill the blanks: http://www.contextures.com/xlDataEntry02.html teddy wrote: I have a pivot table and I want the outer labels repeated on each line. I thought this would be easy but can't figure out how to do this. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |