Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by paulgallanter View Post
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!
  #3   Report Post  
Junior Member
 
Posts: 2
Smile

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....
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing Hiden Pages Slave2Six Excel Discussion (Misc queries) 0 August 1st 06 11:16 PM
Excel printing "additional" blank pages? marsulein Excel Discussion (Misc queries) 1 June 30th 06 12:51 PM
Printing Odd or Even Pages NAVEEN Excel Discussion (Misc queries) 3 February 21st 06 10:59 AM
Printing same table on reverse side of all pages. dziw Excel Discussion (Misc queries) 1 July 6th 05 06:26 PM
how do I print a range without printing the blank pages? Chris VP Excel Discussion (Misc queries) 2 May 2nd 05 07:08 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"