Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing Recto/Verso
Hi all,
I have the following problem in Excel 2003... I have an Excel document with multiple worksheets. Every worksheet contains one or more (!) pages when printing them. Now I want to print those pages recto/verso. The problem is that pages of the different worksheets may NOT be printed at the back-side of the last page of the previous worksheet. For example: Worksheet A has 2 pages when printing Worksheet B has 3 pages when printing Worksheet C has 2 pages when printing When I now print the whole file recto/verso; -- Worksheet A will be OK -- Page 1 & 2 of Worksheet B, will be OK -- Page 3 of Worksheet B AND page 1 of worksheet C will be on the same paper -- page 2 of Worksheet C will be on one paper... How can I solve this problem that no pages of a worksheet is printed on a page of another worksheet? In my example, I should get: -- Page 1 & 2 of Worksheet A on one page -- Page 1 & 2 of Worksheet B on one page -- Page 3 of Worksheet B on one page, with a blank back!! -- Page 1 & 2 of Worksheet C on one page Thanks in advance! Sam |
#2
|
|||
|
|||
You will only have a problem if you select all the worksheets and print them
together. If you print each sheet individually, you should get the results you want. If you want to make this easier for the user you could set up the print area and print properties for each sheet to get it to print the way you want it to, save the workbook, and then use VBA as illustrated below to step through your sheets and print them individually: Public Sub PrintSheets() Worksheets("Worksheet A").Printout Worksheets("Worksheet B").Printout Worksheets("Worksheet C").Printout ' etc... End Sub "Sam Vanderstraeten" wrote: Hi all, I have the following problem in Excel 2003... I have an Excel document with multiple worksheets. Every worksheet contains one or more (!) pages when printing them. Now I want to print those pages recto/verso. The problem is that pages of the different worksheets may NOT be printed at the back-side of the last page of the previous worksheet. For example: Worksheet A has 2 pages when printing Worksheet B has 3 pages when printing Worksheet C has 2 pages when printing When I now print the whole file recto/verso; -- Worksheet A will be OK -- Page 1 & 2 of Worksheet B, will be OK -- Page 3 of Worksheet B AND page 1 of worksheet C will be on the same paper -- page 2 of Worksheet C will be on one paper... How can I solve this problem that no pages of a worksheet is printed on a page of another worksheet? In my example, I should get: -- Page 1 & 2 of Worksheet A on one page -- Page 1 & 2 of Worksheet B on one page -- Page 3 of Worksheet B on one page, with a blank back!! -- Page 1 & 2 of Worksheet C on one page Thanks in advance! Sam |
#3
|
|||
|
|||
the simplest way is to make sure that each sheet will print an even number of
sheets. Check print preview and add lines or page breaks when needed. "Sam Vanderstraeten" wrote: Hi all, I have the following problem in Excel 2003... I have an Excel document with multiple worksheets. Every worksheet contains one or more (!) pages when printing them. Now I want to print those pages recto/verso. The problem is that pages of the different worksheets may NOT be printed at the back-side of the last page of the previous worksheet. For example: Worksheet A has 2 pages when printing Worksheet B has 3 pages when printing Worksheet C has 2 pages when printing When I now print the whole file recto/verso; -- Worksheet A will be OK -- Page 1 & 2 of Worksheet B, will be OK -- Page 3 of Worksheet B AND page 1 of worksheet C will be on the same paper -- page 2 of Worksheet C will be on one paper... How can I solve this problem that no pages of a worksheet is printed on a page of another worksheet? In my example, I should get: -- Page 1 & 2 of Worksheet A on one page -- Page 1 & 2 of Worksheet B on one page -- Page 3 of Worksheet B on one page, with a blank back!! -- Page 1 & 2 of Worksheet C on one page Thanks in advance! Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell borders printing black instead of grey | Excel Discussion (Misc queries) | |||
Printing switches focus off proper sheet | Excel Worksheet Functions | |||
problem printing to PDF | Excel Discussion (Misc queries) | |||
Illegal operation error while printing EXCEL or WORD Files | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |