» Preventing a Printed Area from Extending onto an Extra Page
CATEGORY - Excel Printing
VERSION - All Microsoft Excel Versions
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).

Book Store:
Recommended Books:
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!

