Search Contextures Sites
- Print One Page Wide
- Headings On Every Printed Page
- Rows to Repeat Not Available
- Excel Printing Tips Video
For information on printing Excel comments, please visit:
Printing Excel Comments
If an Excel sheet has data that won't fit one page across, you can change the Scaling setting, to force it to fit.
Follow these steps to change the page scaling setting in Excel 2010:
- On the Ribbon, click the File tab, then click Print
- In the Settings section, click the arrow at the right of No Scaling
- Click on Fit All Columns on One Page
Now all the columns will fit across a single page when printed, and down as many pages as required, to fit all the rows.
Follow these steps to change the page scaling setting in Excel 2007:
- On the Ribbon, click the Page Layout tab
- In the Page Setup group, click the Dialog Launcher, at the bottom right
- In the Page Setup window, on the Page tab, click the 'Fit to' option for Scaling
- Enter 1 as the number of page(s) wide
- Clear the box for the number of pages tall, then click OK
This will limit the file to printing one page across, but won't limit the number of pages down. You don't have to guess the number of pages required, just leave it blank and Excel will figure it out for you.
In a long Excel worksheet, you might have headings in the top rows, to explain what is in each column of data.
When you print the worksheet, you can repeat those headings on each printed page, by setting the Print Titles, as described below.
To repeat headings on each printed page:
- On the Ribbon, click the Page Layout tab, and click Print Titles
- In the Page Setup window, on the Sheet tab, click in the Rows to Repeat at Top box.
- On the worksheet, select the row(s) that you want to print at the top of each page. The row numbers will appear in the Page Setup window.
- Click OK, to close the window.
Occasionally, when the Page Setup window opens, the Rows to Repeat at Top command is not available. As shown in the screen shot below, that setting, and a few others, are greyed out.
This happens if you open the Page Setup window from the Print Preview window. In the screen shot above, I clicked the Page Setup link in the Preview window, and those commands were grey.
To solve the problem:
- Close the Page Setup window, if the Rows to Repeat and other commands are grey.
- On the Ribbon, click the Page Setup tab
- Click Print Titles, to open the Page Setup window again, with the commands active.
To see the steps for setting print scaling to fit all the columns, and set the heading rows, please watch this short video tutorial
Contextures Inc., Copyright ©2013
All rights reserved.
Last updated: May 17, 2013