If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing Double Sided
Hi:
I have an excel workbook with 8 worksheets with one page of printable data on each sheet, I want to print out each of the 8 sheets in a report, but I want to do double sided printing so that the report only contains four A4 pages. I can do double side printing when all the printable data is on one worksheet but I can't seem to be able to do it when the printable data is on seperate sheets in the excel workbook. Help would be greatly appreciated. Regards, Liam. |
#2
|
|||
|
|||
Printing Double Sided
I don't know how to do this in excel but there is a program available
that will allow you to do this, the program is called fineprint and details can be found at fineprint.com, you can download a trail version to see if you like it before you have to buy. --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
Printing Double Sided
Thanks Ian, but unfortuneately I can't download software at work.
Regards, Liam. "ian taylor " wrote: I don't know how to do this in excel but there is a program available that will allow you to do this, the program is called fineprint and details can be found at fineprint.com, you can download a trail version to see if you like it before you have to buy. --- Message posted from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
Printing Double Sided
Hello Liam, two thing to try may be:
1. in excel set the range you want to print on each spreadsheet (highlight area you want to print then go to file/print area/set print area, then use file/page set up to make it print to 1 page tall 1 page wide etc), do this for each sheet, then hold down the "control" key click on each sheet tab you want to print then go to print (I presume this would work if you have a printer that can double side print automatically) 2. Use powerpoint to print it out, for each sheet highlight the area you want to print and then copy (ctrl C), then go to powerpoint and 1 slide for each page you want to print out separately click on the slide and go edit/paste special, in the paste special subscreen select paste as link, do this for all you want to print out and then print from powerpoint, if you save this powerpoint file then next time you want to do the same printouts you just have to have the excel file open and then open up powerpoint presentation and the links should update and you can print out the new report. Hope this helps and makes sense --- Message posted from http://www.ExcelForum.com/ |
#5
|
|||
|
|||
Printing Double Sided
Does your printer support duplexing? If so, if you set that in the Printer
Properties dialog, it should work -- at least it does for me. On Tue, 6 Jul 2004 00:23:01 -0700, "WilliamP" wrote: Thanks Ian, but unfortuneately I can't download software at work. Regards, Liam. "ian taylor " wrote: I don't know how to do this in excel but there is a program available that will allow you to do this, the program is called fineprint and details can be found at fineprint.com, you can download a trail version to see if you like it before you have to buy. --- Message posted from http://www.ExcelForum.com/ |
#6
|
|||
|
|||
Printing Double Sided
Thanks Ian I used the powerpoint option and it worked for me fine.
"ian taylor " wrote: Hello Liam, two thing to try may be: 1. in excel set the range you want to print on each spreadsheet (highlight area you want to print then go to file/print area/set print area, then use file/page set up to make it print to 1 page tall 1 page wide etc), do this for each sheet, then hold down the "control" key click on each sheet tab you want to print then go to print (I presume this would work if you have a printer that can double side print automatically) 2. Use powerpoint to print it out, for each sheet highlight the area you want to print and then copy (ctrl C), then go to powerpoint and 1 slide for each page you want to print out separately click on the slide and go edit/paste special, in the paste special subscreen select paste as link, do this for all you want to print out and then print from powerpoint, if you save this powerpoint file then next time you want to do the same printouts you just have to have the excel file open and then open up powerpoint presentation and the links should update and you can print out the new report. Hope this helps and makes sense --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing 2 worksheets to a 2 sided document | Wasting Paper Guy | General Discussion | 1 | June 30th, 2004 01:29 AM |
Double sided Merged post cards - both sides with merge fields on t | larryboy | Mailmerge | 8 | June 27th, 2004 01:00 AM |
Double Sided Printing | [email protected] | General Discussion | 1 | June 4th, 2004 10:20 AM |
two sided printing | 789 | Worksheet Functions | 2 | May 30th, 2004 08:22 PM |
excel printing double border on repeated rows | Borden Townsend | Worksheet Functions | 1 | September 25th, 2003 09:40 PM |