Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Course Of The Month
9 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to align both sides of an Excel duplex printout with HP DeskJet 970Cse
Posted on 2001-06-13
Hi,
I am using an HP DeskJet 970Cse printer to print on both sides of the page (8? x 11) multiple pages (4) on the same sheet of paper. The printer does it but with a small flaw.
Both sides are not perfectly aligned. (When looking thru the paper). This is important because the pages are calendar pages that will be cut to form a booklet.
I use Excel (Office 2000) to generate the calendar and all the pages are both centered vertically and horizontally. Each page is on a different sheet, there is nothing else on these sheets. So I select all the sheets to produce a multiple page landscape printout. Everything goes fine except that difference between the front and back of the paper of about 4 mm on the right and left sides of the pages.
My PC (PIII 677 Mhz) runs Windows 2000 (SP1) and I have downloaded and installed the latest driver for my printer.
Someone does have an idea of a possible solution?
Thanks, Pierre
I am using an HP DeskJet 970Cse printer to print on both sides of the page (8? x 11) multiple pages (4) on the same sheet of paper. The printer does it but with a small flaw.
Both sides are not perfectly aligned. (When looking thru the paper). This is important because the pages are calendar pages that will be cut to form a booklet.
I use Excel (Office 2000) to generate the calendar and all the pages are both centered vertically and horizontally. Each page is on a different sheet, there is nothing else on these sheets. So I select all the sheets to produce a multiple page landscape printout. Everything goes fine except that difference between the front and back of the paper of about 4 mm on the right and left sides of the pages.
My PC (PIII 677 Mhz) runs Windows 2000 (SP1) and I have downloaded and installed the latest driver for my printer.
Someone does have an idea of a possible solution?
Thanks, Pierre
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
2
7 Comments
Hi. Copy each calendar and paste special-as a picture into Word. Position however you desire and print from Word.
To Dreamboat:
The cut and paste as picture operation have been used but the quality of the text droped too much. Anyway, this is not applicable because I would have to manually place each page and print a test. This is not practical.
--------------------------
To cri:
Yes the margins are the same on every sheets:
Top, right, buttom, left margins = 0
Header, footer = 0
A shift in the margins produce a reduction of the general size of the page because I scaled each and every sheets to fit on a single page.
The link you suggest refers to a problem that I encountered and solved exactly the way they suggest.
--------------------------
Thanks anyway
The cut and paste as picture operation have been used but the quality of the text droped too much. Anyway, this is not applicable because I would have to manually place each page and print a test. This is not practical.
--------------------------
To cri:
Yes the margins are the same on every sheets:
Top, right, buttom, left margins = 0
Header, footer = 0
A shift in the margins produce a reduction of the general size of the page because I scaled each and every sheets to fit on a single page.
The link you suggest refers to a problem that I encountered and solved exactly the way they suggest.
--------------------------
Thanks anyway
You sure your printer can print to margin = 0 ? AFAIK the 970 has traction feeding, therefore it needs some millimeters as margin, especially at the 'exit' small side. IMO you should try with one margin=0.2 cm, which one you must try out.
To cri
You are right, the printer does'nt print at margin 0 but I must say that the only solution for the moment is yours even if I have to adjust the size of each page because when I add a margin to the page, the overall size changes. It is a matter of setting the margins by trial and error once and for all. Best option so far.
Thanks, I accept your comment as answer.
You are right, the printer does'nt print at margin 0 but I must say that the only solution for the moment is yours even if I have to adjust the size of each page because when I add a margin to the page, the overall size changes. It is a matter of setting the margins by trial and error once and for all. Best option so far.
Thanks, I accept your comment as answer.
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 23 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.