View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default How do wrap all columns of a pivot table to 2nd half of same page

Hi,

If you are asking whether you can wrap text in a pivot table - yes, the same
way you do it in a spreadsheet - Format, Cells, Alignment, Wrap text

I don't think this is what you are after but ... If you are asking can you
extend the printout across multiple pages, look at this and see if it
addresses anything you are after - choose the pivot table and then from the
Pivot Table toolbar pick Pivot Table, Table Options, and turn on Repeat item
labels on each printed page and Set print titles.

If you are asking can you print a Excel document like a Word document with
multiple columns - no.

If you are asking something else please give us more details.
--
Thanks,
Shane Devenshire


"MichalRea" wrote:

I have a 3 column pivot table that can be too long to fit on one page, but I
do not want to shrink it to fit (makes type too small) Is there a way to get
the rows that don't fit on the page to wrap and print as a 3 column table on
2nd half (open half) of the page?