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

Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.

Check out ExcelTips: Times and Dates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Collating Copies