Article ID: 211474 - View products that this article applies to.
This article was previously published under Q211474
If you click Print on the File menu and specify a number in the Number of copies box to print multiple copies of a worksheet, chart, or other document, Microsoft Excel creates a separate print job for each copy, and then sends the jobs to the printer. For example, if you print five copies of a worksheet, five print jobs are created and sent to the printer.
This behavior may cause the following problems:
These problems occur because the Collate check box in the Print dialog box is selected (checked) by default in Microsoft Excel. When this check box is selected, and you print multiple copies, Microsoft Excel creates a separate print job for each copy you request, and then sends each job to the printer.
In versions of Microsoft Excel earlier than Excel 97, the Collate check box is cleared by default.
To work around this behavior, clear the Collate check box before you click OK in the Print dialog box.
NOTE: If you clear the Collate check box, you must manually collate the printed output.
In Microsoft Excel, you can print multiple copies by specifying a number in the Number of copies box in the Print dialog box. To do this, follow these steps:
<Job 1> <Job 2> <Job 3> <Job 4> <Job 5>where each print job consists of Page 1, Page 2, and Page 3. Microsoft Excel collates the pages.
If the Collate check box is cleared, Microsoft Excel creates one print job and sends it to the printer with instructions to print it five times. For example, if you print five copies of a three-page document, the following information is sent to the printer:
<Instructions to print each page in the next job five times> <Job 1>Because the Collate check box is cleared, the printer prints five copies of Page 1, five copies of Page 2 and five copies of Page 3. You must manually collate the pages.