Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTables
Is it possible to repeat the row item on the far left for each row in a
PivotTable? Kerry K |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTables
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. To create a table with a heading on each row, you could copy the pivot table, paste it as values in another location, and fill in the blanks, using the technique shown he http://www.contextures.com/xlDataEntry02.html KerryK wrote: Is it possible to repeat the row item on the far left for each row in a PivotTable? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTables
Thanks Debra
I have a client that swears that it can be done but didnt think so. Have a great day Regards Kerry "Debra Dalgleish" wrote: The row headings show once in a Pivot Table, and there's no setting you can change, to force them to repeat. To create a table with a heading on each row, you could copy the pivot table, paste it as values in another location, and fill in the blanks, using the technique shown he http://www.contextures.com/xlDataEntry02.html KerryK wrote: Is it possible to repeat the row item on the far left for each row in a PivotTable? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interactive PivotTables on the Web | Excel Discussion (Misc queries) | |||
Sorting in pivottables | Excel Worksheet Functions | |||
Format Pivottables? | Excel Discussion (Misc queries) | |||
New to Pivottables- need help | Charts and Charting in Excel | |||
Drill Down in PivotTables | Excel Discussion (Misc queries) |