Collating Copies

Summary: When you print multiple copies of worksheets that require more than one page each, you'll probably want those copies printed as sets. By turning on collation, you can direct Excel to print the sets that you need. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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:

Display the Print dialog box. (Click here to see a related figure.) Choose File | Print or, in Excel 2007, press Ctrl+P.
Specify the number of copies you wish to print.
Click on the Collate Copies check box. A check mark in the box indicates the copies will be collated.
Click on OK. Your worksheet will be printed.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3237) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.

Check out ExcelTips: Custom Formats today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Collating Copies