How to print all sheets in a workbook

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

Comments

  1. Vijay says:

    Thanks for the post.

  2. Nick says:

    New issue: Our printer default settings are black/white. I find that, in Excel 2003, you open the Print dialog box, select All Sheets in Workbook, and go to the printer properties and select the local printer setting for Color, only the first sheet prints in color. Anyone have a solution?

  3. Jon says:

    Similar thing happened to me Nick in Excel 2003. First page was 2-up, but no other sheets were. Anyone find a solution yet?