Print preview doesn't show all of the workbook pages to print in 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M Skabialka - 19 Mar 2008 17:53 GMT

I was going to print a multiple worksheet workbook, selected to print the
entire workbook, then saw that it was spooling 187 pages! I cancelled it
immediately, though it would have been a good reference, but I was thinking
it was going to be less than couple of dozen sheets.
I went into Print Preview and it would only show me the pages for the
current selected worksheet.
How in Excel 2007 can I find out how many pages will print if I select the
whole workbook?

Reply to this Message

Jim Rech - 19 Mar 2008 18:12 GMT

When I select all the sheets to be printed and then do a print preview I see
the count of all pages for all sheets.

Signature

Jim

|I was going to print a multiple worksheet workbook, selected to print the
| entire workbook, then saw that it was spooling 187 pages! I cancelled it
[quoted text clipped - 4 lines]
| How in Excel 2007 can I find out how many pages will print if I select the
| whole workbook?

Reply to this Message

M Skabialka - 19 Mar 2008 21:52 GMT

Aha! There are lots of blank pages with only a header! I think I'll need
to set the print area on most of the worksheets and it should take it down
to a much more manageable printed size. I can't believe I didn't think of
this!
Thanks,
Mich

> When I select all the sheets to be printed and then do a print preview I
> see
[quoted text clipped - 11 lines]
> the
> | whole workbook?

Reply to this Message

Rate this thread: