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

Comments

  1. 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!

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.