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.

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

Related posts:

1. Free Word / Excel password Recovery If you are looking for a tool that can recover...
2. Speed Up Your .Net Project Debugging Are you suffering from the poor performance of the...
3. Label and Refer Diagrams, Tables in MS Word The preferred approach for labelling and referencing  ’screen shots’, diagrams,...
4. Keyboard Shortcuts Windows Explorer keyboard shortcuts END Display the bottom of...
5. You Spoke, Hotmail listened Over the past year, many of you told them that...
6. Start Windows Explorer at Any Directory There is a way to start windows explorer at any...
7. How to Improve SQL Performance Consider the following SQL SELECT * FROM A-LF LEFT JOIN...
8. Test Your Internet Speed If you ever wondered how much Internet speed you actually...
9. Feed Apps: Promote or Not To Promote I notice a facebook app in some of my friends...
10. Create Passport Photos Online idphoto4you is an online tool to create passport /...