View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default pivot table formatting

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


mwam423 wrote:
greetings! if i've got three items in the "row" section of pivot table
layout, is it possible to have the value of the first and second items
displayed on each line? the default table currently has the first item on
the first line only, second items will appear once at the top of each of
their sections, then the third item will appear on each line. guessing this
is just how pivot output pops out but you folks can help me find out
definitively.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com