Custom Fit to Page

[elbarto]

Does anyone know how to fit multiple pages to page? What I mean by this
is I have a worksheet that is 707 rows and I've set the page breaks to
break the worksheet into 8 pages. The pages are set to letter size.
However, some pages have empty space at the top and bottom, and other
pages fill out the page completely. This is because each page has a
different amount of rows in it obviously. I want to make it so each
page is "fit to page" where there is no empty space at the top and
bottom, regardless of how many rows each page has. Hopefully what I'm
saying makes sense. Any help would be appreciated. Thanks.

 

[Mallycat]

I don't think you can do this if all pages are on the same spreadsheet.
If the pages were across different sheets, you could do it by setting
the fit to page property in the print dialogue. This property works on
the entire sheet, not page to page.

Matt

 

[Lobo]

Does anyone know how to fit multiple pages to page? What I mean by this
is I have a worksheet that is 707 rows and I've set the page breaks to
break the worksheet into 8 pages. The pages are set to letter size.
However, some pages have empty space at the top and bottom, and other
pages fill out the page completely. This is because each page has a
different amount of rows in it obviously. I want to make it so each
page is "fit to page" where there is no empty space at the top and
bottom, regardless of how many rows each page has. Hopefully what I'm
saying makes sense. Any help would be appreciated. Thanks.

Go to View and then Page Break Preview. You will see solid or dashed lines
where each page breaks. Drag the solid lines up or down until they become a
dashed line. This will be the most efficient page break for your document
and should adjust if you add or delete rows.
Lobo
~~~~~~~~~~~~~~~~~~~
Delete the obvious to reply to me personally.
~~~~~~~~~~~~~~~~~~~