Printing Multiple Excel Pages On a Piece of Paper

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.)

Steps Continued Here

15,576 total views, 1 views today

(Visited 1 times, 3 visits today)

3 thoughts on “Printing Multiple Excel Pages On a Piece of Paper

  1. i know what you mean (print second sheet to the right of page because the first page only take half a sheet) and the directions above (multiple sheet on single page) is not what you are looking for. I too am looking to do this, only way i think to do it is with a macro or manually have to place the column you want be placed to the right of the “first page”.

  2. Doesn’t do what I want. It prints 2 pages, but still in one column, just tiny. I want it to print the 2nd page without reduction, side-by-side with the first page on one sheet. I tried setting print option to over-then-down instead of down-then-over, but it made no difference.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.