Hello,

I have a pivot table set up on a worksheet. Although most of the time I
have less than a page of data that's being returned (I use page breaks),
sometimes I have a bit more.

Is there a way I can set "something" up so that the page break automatically
goes to the last line of data?

Thank you.

I've always found that excel does a nice job of determining the print range, so
I don't set it myself.
Sometimes, excel will include too much data, but resetting the last used cell
will help let excel figure out what should be printed.

You can find some techniques at Debra Dalgleish's site for resetting the last
used cell:
http://www.contextures.com/xlfaqApp.html#Unused

Jim wrote:

Hello,

I have a pivot table set up on a worksheet. Although most of the time I
have less than a page of data that's being returned (I use page breaks),
sometimes I have a bit more.

Is there a way I can set "something" up so that the page break automatically
goes to the last line of data?

Thank you.

--

Dave Peterson

Hi,

1. Select the pivot table,
2. Choose File, Page Setup, and turn on Fit to and leave 1 by 1.
3. Chose File, Print, Selection, OK.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Jim" wrote:

Hello,

I have a pivot table set up on a worksheet. Although most of the time I
have less than a page of data that's being returned (I use page breaks),
sometimes I have a bit more.

Is there a way I can set "something" up so that the page break automatically
goes to the last line of data?

Thank you.