|  

» Preventing a Printed Area from Extending onto an Extra Page

A common problem that occurs while printing is when a small area wraps onto an extra page. For example, if you select a print area that includes columns A to F, columns A to E may be on one page, while column F is printed on an extra page.

To force the last column(s) to be within the printed area:

1. From the File menu, select Page Setup.
2. Select the Page tab.
3. In Scaling, select the Fit to option button, and set the area to be 1 page wide by blank page tall (that is, leave the tall input box blank).
Screenshot // Preventing a Printed Area from Extending onto an Extra Page
Preventing a Printed Area from Extending onto an Extra Page

Rate This Tip
12 34 5
Rating: 4.06     Views: 19890
Niggle
Norbury  Posted on: 31-12-1969
Great tip as I've suffered this for a long time. Most of my sheets had hidden columns and my solution was to have an extra column shown set at 0.01 wide. It didn't 'Prevet' it but did PreVent it!
Name
Comment Title
Comments