ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing whole workbooks on one sheet of paper (https://www.excelbanter.com/excel-discussion-misc-queries/196350-printing-whole-workbooks-one-sheet-paper.html)

kolena

Printing whole workbooks on one sheet of paper
 
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

Printing whole workbooks on one sheet of paper
 
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

On Fri, 25 Jul 2008 12:31:09 -0700, kolena
wrote:

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)




All times are GMT +1. The time now is 06:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com