Hi Lee,
In Excel 97, 2000, 2002, 2003, the Collate check box in the print dialog box is checked by default. In versions of Microsoft Excel earlier than Excel 97, in Excel 2007, the Collate check
box is cleared by default.
If you want this option checked by default in the new Excel files, we can create a template and put it into the XLSTART folder to work around it. Following is the key steps.
Note: As this setting is saved with the workbook, the following steps doesn't affect the existing workbooks.
1. Open a new blank workbook in Excel 2007.
2. Click the Office button > Print.
3. In the print dialog box, click Properties > in the Advanced tab, go to Paper/Output. Click Copy Count, set it as 2, and check the Collate. If you want the copy count as 1, then
set it back to 1. Click OK. Now, the collate is checked. Click Close.
4. Click the Office button > Save As. Choose file type as *.xltx. Save it to the folder: C:\Program Files\Microsoft Office\Office12\XLSTART. Name the file as book.xltx.
5. Click Save to save it.
6. Exit Excel. Start Excel 2007. Check the print dialog box in the new Excel file. The collate checkbox should be checked. What is the result?
Related KB article:
822107 How to use startup folders in Excel
http://support.microsoft.com/default.aspx?scid=kb;EN-US;822107
If anything is unclear or if you have any other concerns, please don't hesitate to contact me.
Regards,
Emily Lin
Microsoft Online Partner Support
Get Secure! -
www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
