Printing Multiple Pages On a Piece of Paper

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:

1. 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.
2. Click on the Options button. Excel displays the printer's Document Properties dialog box.
3. 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.)
4. Using the Pages Per Sheet control (or the Multiple Page control), specify how many pages you want printed on each sheet of paper.
5. Click on OK to dismiss the printer's Document Properties dialog box.
6. Click on OK to dismiss the Page Setup dialog box.