Workbook Prints as separated documents

  • Thread starter Thread starter moto57
  • Start date Start date
M

moto57

I normally print the same form, which consists of 5 differen
worksheets. When I send it to the printer (Xerox Document Centre 432
it prints as 3 different documents. I would like to use the staplin
feature of this printer but I cant because it will staple only the
middle pages (the first and last pages will be printed as differen
documents).
Any help about how to make this print as a hole document?
The printer is installed as a network printer
 
moto57 said:
I normally print the same form, which consists of 5 different
worksheets. When I send it to the printer (Xerox Document Centre 432)
it prints as 3 different documents. I would like to use the stapling
feature of this printer but I cant because it will staple only the 3
middle pages (the first and last pages will be printed as different
documents).
Any help about how to make this print as a hole document?
The printer is installed as a network printer.
Click to expand...

You might try making a pdf file first. Then send that to the printer.

Another possibility is using FinePrint (http://www.fineprint.com/). I've
used it to merge print jobs, though it has other features also.
 
Do you group the worksheets before you print?

I'm not sure if this'll work, but try grouping all 5 sheets and then printing
the selected sheets.

Maybe even: File|Print|entire workbook
will work for you.

And to group sheets. Click on the first worksheet tab and then ctrl-click on
subsequent.

Notice the title bar. xl warns you when you group sheets by adding [Grouped] to
the title bar.

Anything you do to one of those grouped sheets, you do to all. So be careful to
ungroup when you're done.

Right click on one of the worksheet tabs and select: Ungroup Sheets.
(or select one of the non-grouped sheets.)
 
With the PDF it will work, but i'm trying to save time and that will b
an additional step. I'm having the problem using Print Entire Workbook
I just printed it with the grouping option and it didn' work. I'll kee
trying
 
This might be too much work.

Group your sheets (or print entire workbook), but print to a file.

Then shell to DOS and do:

copy /b myprintfile.prn lpt1:

(or whatever printer you go to.)
 
Back
Top