Printing whole workbooks on one sheet of paper

[kolena]

Can you print multiple worksheets on one sheet of paper. For example if
worksheet 1 has 10 lines and worksheet 2 has 7 lines can you print both on
one sheet of paper? PLEASE HELP (I have excel 2003)

 

[Gord Dibben]

No.

You can copy the 7 rows under the 10 rows and print that.

Ron de Bruin has code to copy non-contiguous ranges from same sheet or
multiple sheets to a new sheet for printing.

http://www.rondebruin.nl/print.htm#non-contiguous


Gord Dibben MS Excel MVP