To print all worksheets in a workbook then :
1. In the File menu click Print.
2. The Print window will open.
3. At the bottom of the Print window find a section labeled: Print what .
4. Click on the radio button labeled: Entire workbook.
5. Click OK.
Applies to Excel 2003