ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing opposing pages (https://www.excelbanter.com/excel-discussion-misc-queries/117568-printing-opposing-pages.html)

paulgallanter

Printing opposing pages
 
I am printing a sheet in 2003 where it takes two opposing pages to show the
width of the sheet. The problem is, I want to print on both sides of the
paper and page one is on the wrong side. How do I make page 1 a blank
without making page 2 a blank (as the sheet is a double wide) so that the
first part of the data is on page 2 opposing page 3.

thank you, paul

ckswanecamp

Quote:

Originally Posted by paulgallanter (Post 401179)
I am printing a sheet in 2003 where it takes two opposing pages to show the
width of the sheet. The problem is, I want to print on both sides of the
paper and page one is on the wrong side. How do I make page 1 a blank
without making page 2 a blank (as the sheet is a double wide) so that the
first part of the data is on page 2 opposing page 3.

thank you, paul

Any update to this question? I currently have the same issue as OP....

I have created a workbook that will be utilized in the field to enable pen & ink changes (validation purposes). The columns are two horizontal pages wide, and will be bound on the short edge.

When I print, I am using "print over & down" and "print on both sides" but that puts page one columns "A thru Y" on the front & columns "Z thru AL" on the back.

I don't want to change the layout of the spread sheet because the pen & ink changes will need to be updated in the document (after validation.) Catch my drift?

Any help would be much appreciated!

ckswanecamp

I figured out a work around....

I made a "Cover Sheet" on a new tab located in front of my spreadsheet's tab. I then adjusted the page setup (a separate setup for each tab) and kept test printing / making adjustments until I was satisfied with the results in hand.

If anyone finds this thread like I did- I hope this helps....


All times are GMT +1. The time now is 02:26 AM.

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