Collating Copies

If you work where there is a good size copy machine, you already know what it means to collate something. With a copier, it means the pages you are copying are placed in complete sets which can be used right away. It is the same in Excel. If you have a worksheet that occupies five pages, and you are printing multiple copies, you can either print them collated or uncollated. When they are collated, they are in page 1–5 order for each of the five sets. If they are not collated, five copies of the first page are printed, then five of the second, and so on. To control collating, follow these steps: 1. Choose Print from the File menu. Excel displays the Print dialog box. (Click here to see a related figure.) 2. Specify the number of copies you wish to print. 3. Click on the Collate Copies check box. A check mark in the box indicates the copies will be collated. 4. Click on OK. Your worksheet will be printed.