ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I print multiple worksheets on one page? (https://www.excelbanter.com/excel-discussion-misc-queries/60827-how-do-i-print-multiple-worksheets-one-page.html)

renonv

How do I print multiple worksheets on one page?
 
I use Excel 2000. How do I print two or more worksheets to one page?

Dave Peterson

How do I print multiple worksheets on one page?
 
You can make a third worksheet and copy the data from each sheet onto that third
sheet.

Maybe even better is that you could copy and paste picture link.

Create a new sheet
Select the range on sheet1
Edit|copy
Go to A1 of the new sheet
Shift-Edit|Paste picture link

Repeat with the second range on the second sheet.

But position the cursor under (or to the right of the first picture) before you
paste the picture.

Then print that third sheet.

By pasting the picture link, any change to the original ranges will show up in
that live picture.



renonv wrote:

I use Excel 2000. How do I print two or more worksheets to one page?


--

Dave Peterson


All times are GMT +1. The time now is 05:38 PM.

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