When I want to print an entire workbook as one document, I normally choose
File, then print, and then choose Entire Workbook, and the entire workbook
prints as one document (sometimes I use a pdf writer, and this turns the
workbook into one document).

I have one workbook which is printing each worksheet separately. Does anyone
know what would cause this behaviour? I've never seen it before, and it has
me stumped.

Thanks very much!

try this


1. Select all sheets in the workbook. To do this, click the first
worksheet, hold down SHIFT, and then click the last sheet in the workbook.
2. On the File menu, click Page Setup. On the Page tab, select
resolution=300dpi and then click OK.


"B. Levien" wrote:

When I want to print an entire workbook as one document, I normally choose
File, then print, and then choose Entire Workbook, and the entire workbook
prints as one document (sometimes I use a pdf writer, and this turns the
workbook into one document).

I have one workbook which is printing each worksheet separately. Does anyone
know what would cause this behaviour? I've never seen it before, and it has
me stumped.

Thanks very much!