I have a workbook which consists of 10 pages.

I would like to print 2 pages onto one sheet of A4 (landscape) making a
total of 5 printed sheets, how can I do this?

This microsoft article may help
http://support.microsoft.com/kb/142529/

Or this extract from John Walkenbach's book may be what you are looking for



Printing multiple ranges, from the book 'Excel bible' by John Walkenbach



You can create live snapshots of the ranges and paste these snapshots to an
empty area of the worksheet or a new worksheet. Then you can print this new
area which consists of the snapshots.



To create a live snapshot of a range, select the range and copy it to the
clipboard. Then to paste a live link, select the cell in which you want to
paste the snapshot to an empty worksheet or an empty area on an existing
sheet, press and hold the shift key, and then choose edit (from the menu),
paste picture link.



Repeat this procedure for the other ranges. After you paste them, you can
rearrange the snapshots any way you like. These are live links, change a
cell in the original range and the change appears in the linked picture.


"geeall" wrote in message
...
I have a workbook which consists of 10 pages.

I would like to print 2 pages onto one sheet of A4 (landscape) making a
total of 5 printed sheets, how can I do this?