Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Excel Multiple Copies
When we print multiple copies of a excel worksheet say 5, we get instead of
one seperator page we get 5. Is there a way to get excel print it as one job, it appears it is doing 5 sepearte jobs to print the 5 copies. Any thoughts ? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Excel Multiple Copies
This would be a function of the printer/printer driver. Excel doesn't know
the capabilities of your printer, i.e. whether it has the ability to take a single copy and print 5 times or if it is memory or function limited and needs to get it all as 5 jobs. Only way I know would be to make 4 copies of the sheet to be printed, select all 5 sheets and then send that as a single job (1 copy). But you could be presented with a page numbering problem if there is page numbering set up in the header or footer of the sheet. Then of course you've got the remaining task of deleting those 4 copies out of the workbook. Could be done with a macro a couple of ways: actually replicating the sheet 4 times then printing them as a group and then deleting the 4 extra copies; or, copying the active range head-to-tail on the same sheet 4 times with a page break between each, printing the one sheet, then deleting the added information and page breaks. This last would have the disadvantage of more or less permanently making your file larger because Excel will save the file as if those added rows of were still there. "Stup88" wrote: When we print multiple copies of a excel worksheet say 5, we get instead of one seperator page we get 5. Is there a way to get excel print it as one job, it appears it is doing 5 sepearte jobs to print the 5 copies. Any thoughts ? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Excel Multiple Copies
Late thought: perhaps if your printer setup has an option to print separator
pages or not, you could use File | Print and then inhibit the printing of separator pages for the job? That would be so much easier than building the code I alluded to earlier. "Stup88" wrote: When we print multiple copies of a excel worksheet say 5, we get instead of one seperator page we get 5. Is there a way to get excel print it as one job, it appears it is doing 5 sepearte jobs to print the 5 copies. Any thoughts ? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Excel Multiple Copies
You may find it cheaper to print one copy and then photocopy (Xerox???) the
remaining four. Or you could try printing to a file--make sure you use the same printer driver for the printer you're going to use. Then you can use an old DOS command to copy that file to the printer multiple times: copy /b C:\a.prn+C:\a.prn+C:\a.prn+C:\a.prn+C:\a.prn lpt1: You may want to try it on a small test (a single piece of paper worksheet???) Stup88 wrote: When we print multiple copies of a excel worksheet say 5, we get instead of one seperator page we get 5. Is there a way to get excel print it as one job, it appears it is doing 5 sepearte jobs to print the 5 copies. Any thoughts ? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove hidden lines when printing multiple copies in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel wants to print multiple copies | Excel Discussion (Misc queries) | |||
printing multiple copies of a worksheet | Excel Discussion (Misc queries) | |||
HOW DO I PRINT MULTIPLE COPIES IN EXCEL | Excel Discussion (Misc queries) | |||
Why does an excel worksheet default to 24 copies when printing | Excel Worksheet Functions |