Welcome toExcel2007.Tips.Net
Helpful Links
Cleaning Tips
Money Tips
Organizing Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
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.
Related Tips:
Add a Professional Finishing Touch! Word includes great tools that allow you to add professional-grade finishing touches to your documents. You can add indexes, tables of contents, and other special tables by using the detailed information available in this volume. Check out WordTips: Indexes and Special Tables today!