Speed Up Excel Printing

Posted In Tutorials - By NitiN Kumar Jain On Friday, May 22nd, 2009 With 0 Comments






Pin It


You would have definitely noticed that printing multiple copies of a multi-page excel worksheet takes a lot of time to print. Like, it takes good time to print 3 copies of a 4 page worksheet.

The reason for this is that Excel, by default, sends each worksheet individually. Hence, pages 1 through 4 are sent, then 1 through 4 are sent again, and again, until all 3 sets have been printed.

Printing speed can be improved by turning off collating on our printout. This means that page 1 would be printed 3 times, then page 2, 3 times, and similarly other 2 sheets.

Follow these to turn off collating in Excel:

  • Choose Print from the File menu.
  • In the Print dialog box, ensure that the Collate check box is cleared.
  • Select desired number of copies and click on OK.

excel-collate-tip

Reason as explained before is that with collation turned off, Excel sends only a single copy of each page, along with a command that tells how many copies of each page to print. It is clear from the above image too.

This can really prove to be handy when printing multiple copies of sheet containing multiple sheets.

Hope this is useful to you.

-NKJ