Printing 2 worksheet duplex on same paper
I have a excel spreadsheet with two worksheets. I want to print both worksheet on the same paper on both sides duplex. I know someone might suggest that I print the first sheet then turn the paper over to print the second sheet, but thats not what I want. I select both worksheets choose the duplex option on the printer and print but the worksheet always comes on two different sheets of paper. Any help would greatly appreaciated. Thanks i advance.. -- jacksprat ------------------------------------------------------------------------ jacksprat's Profile: http://www.excelforum.com/member.php...o&userid=34916 View this thread: http://www.excelforum.com/showthread...hreadid=546528 |
Printing 2 worksheet duplex on same paper
I have a excel spreadsheet with two worksheets. I want to print both
worksheet on the same paper on both sides duplex. I know someone might suggest that I print the first sheet then turn the paper over to print the second sheet, but that's not what I want. I select both worksheets choose the duplex option on the printer and print but the worksheet always comes on two different sheets of paper. Any help would greatly appreciated. Thanks in advance. I’ve done it this way. It’s not elegant, admittedly. Print the workbook to the “Microsoft Office Document Image Writer.” This opens a “Microsoft Office Document Imaging” window for each worksheet. Next, combine the worksheets into a single document. To do this, notice that each of the “Imaging” windows has a left pane with thumbnails of the page(s). Using right-click, “Copy” one or more thumbnails from the left pane of one window and “Paste” it into the left pane of another. Repeating this, the entire document can be merged into a single window. Finally, print from that window. Hope this helps. If you do this sort of thing a lot, you might want to look into http://fineprint.com/products/fineprint/index.html for an add-on program that (among many other features) can combine several print jobs into one, with fewer steps than using Image Writer. |
All times are GMT +1. The time now is 05:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com