Printing Multiple Pages On a Piece of Paper

Summary: If you want to save paper on a printout, you might consider printing multiple pages on a single piece of paper. This can be done by using the capabilities of your printer, as described in this tip. (This tip works with Microsoft Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

You may want to print multiple pages of your Excel worksheet on a single piece of paper. You can accomplish this in Excel 2000 or later versions by following these steps:

Display the Page Setup dialog box. You do this in Excel 2000 through 2003 by choosing File | Page Setup. If you are using Excel 2007 you display the Page Layout tab of the ribbon and then click the small icon at the lower-right corner of the Page Setup group.
Click on the Options button. Excel displays the printer's Document Properties dialog box.
Look around through the available tabs to locate one that has a Pages Per Sheet control or a Multiple Page control. On my printer it is the Finishing tab; on yours it may be different. (Click here to see a related figure.)
Using the Pages Per Sheet control (or the Multiple Page control), specify how many pages you want printed on each sheet of paper.
Click on OK to dismiss the printer's Document Properties dialog box.
Click on OK to dismiss the Page Setup dialog box.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3386) applies to Microsoft Excel versions: 2000 | 2002 | 2003 | 2007

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.

Check out PivotTables for the Faint of Heart today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Printing Multiple Pages On a Piece of Paper