Solved

How to align both sides of an Excel duplex printout with HP DeskJet 970Cse

Posted on 2001-06-13
7
783 Views
Last Modified: 2012-05-04
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
0
Comment
Question by:archampi
  • 4
  • 2
7 Comments
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6187537
Hi. Copy each calendar and paste special-as a picture into Word. Position however you desire and print from Word.
0
 
LVL 13

Expert Comment

by:cri
ID: 6187556
Are the margins the same ? If yes: try with a difference of 2 mm between them.
0
 
LVL 13

Expert Comment

by:cri
ID: 6187575
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 

Author Comment

by:archampi
ID: 6188939
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
0
 
LVL 13

Accepted Solution

by:
cri earned 200 total points
ID: 6189564
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.
0
 

Author Comment

by:archampi
ID: 6196459
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.
0
 
LVL 13

Expert Comment

by:cri
ID: 6196730
archampi, thAnk you.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question