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?

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?

I am trying to get a pivot table that is too long to fit on an 8 1/2 x 11
page, but is narrow enough to fit a 2nd table next to it, to continue the
info from the bottom rows into a the 2nd table, but not with cut and past as
I need to do this for about 20 different pivot tables on an ongoing basis.
My pivot table is 3 columns wide, with the first column containing a alpha
sorted list and the second two indicate whether or not the items in the alpha
list fall into their categories.

Michal

"ShaneDevenshire" wrote:

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?

On Tue, 30 Sep 2008, in microsoft.public.excel.charting,
MichalRea said:
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?

I was sure vertical Windows Split was going to work, but it seems to be
locked row for row. I guess a horizontal split would uncouple the rows
and lock the columns, but that's no good to you.

Instead, just create a range of formulae that read the values of the
lower rows of the Pivot table, and put it next to the upper rows, and
Copy.. Paste Special the formats.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.