By Allen Wyatt for Excel.Tips.Net
Printing Multiple Excel 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 by following these steps:
1. Display the Page Layout tab of the ribbon.
2. Click the small icon at the lower-right corner of the Page Setup group. Excel displays the Page Setup dialog box.
3. Click on the Options button. Excel displays the printer’s Properties dialog box.
4. 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 Features tab; on yours it may be different. (See Figure 1.)