Welcome toExcel2007.Tips.Net
Helpful Links
Cleaning Tips
Cooking Tips
Health Tips
Word2007 Tips
Newest Tips
Correcting Pale Shading of Selected Cells
Converting Numeric Values to Text Values
Easily Dividing Values by a Set Amount
Unwanted Files Loading when Starting Excel
Subscribe
Printing Multiple Pages On a Sheet 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.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:
- Make sure that the Page Layout tab of the Ribbon is displayed.
- Click the small icon at the lower-right corner of the Page Setup group. Excel displays the Page Setup dialog box.
- 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 Features 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.