Preventing a Printed Area from Extending onto an Extra Page in Excel 2010

In this article, we will learn how to prevent 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, we need to follow the following steps:

• Click on Page Layout ribbon
• Click on Print Titles or click Dialog Box Launcher in the bottom-right corner of Page Setup group

• The Page Setup dialog box will be displayed

• Select Sheet tab
• In Scaling, select the Fit to option button, and set the area to be 1 page(s) wide by blank page tall (that is, leave the tall input box blank).
• Click on Print Preview to see the preview

Before applying setting, we are able to view only 5 columns
 

 
After applying setting, we are able to view missing Sales column i.e. all 6 columns