How to print entire workbook 9 pages to a sheet?

J

JDS

Excel workbook contains 54 sheet tabs, some tabs are two or more pages. I
want to print continuous pages, 9 to a letter size paper. If 1st tab has 1
page, 2nd tab 5 pages, 3rd tab 3 pages, that would print all on one piece of
paper...
 
G

Glenn

JDS said:
Excel workbook contains 54 sheet tabs, some tabs are two or more pages. I
want to print continuous pages, 9 to a letter size paper. If 1st tab has 1
page, 2nd tab 5 pages, 3rd tab 3 pages, that would print all on one piece of
paper...


If you can print to PDF, Adobe Reader can handle 9 per page.
 
J

JDS

I am unclear of the benefit of printing to PDF. Excel says it will print 9
to a page, but I can't get it to do the Workbook as a continuum of all
sheets(tabs). How will Adobe improve this? I use Adobe but have never
'printed to' Adobe.
 
G

Glenn

JDS said:
I am unclear of the benefit of printing to PDF. Excel says it will print 9
to a page, but I can't get it to do the Workbook as a continuum of all
sheets(tabs). How will Adobe improve this? I use Adobe but have never
'printed to' Adobe.

If you select all of your worksheets and print to PDF format, all of your 54
pages will be in one PDF document. Then you can print from Adobe Reader, which
has options to scale multiple pages per sheet.
 
J

JDS

I have tested this on 2 smaller files, one worked, the other gives me this
error message:
! Acrobad PDFMaker cannot create PDF from Workbooks where Worksheets have
different settings for Print Quality. Set a uniform value of Print Quality
in all Worksheets, or run PDFMaker on individual Worksheets.
I have diligently tested and checked every advanced printer setting for the
3 sheets and they match exactly. Still I get the error message. I have
closed & opened the file. Do you know of any other setting to consider?
Very grateful for your help!
 
G

Glenn

JDS said:
I have tested this on 2 smaller files, one worked, the other gives me this
error message:
! Acrobad PDFMaker cannot create PDF from Workbooks where Worksheets have
different settings for Print Quality. Set a uniform value of Print Quality
in all Worksheets, or run PDFMaker on individual Worksheets.
I have diligently tested and checked every advanced printer setting for the
3 sheets and they match exactly. Still I get the error message. I have
closed & opened the file. Do you know of any other setting to consider?
Very grateful for your help!


I've never had any problems similar. Sorry I can't be of further help. If no
one else posts a response, maybe try posting in adobe.acrobat.windows?
 
J

JDS

Much gratitude. If I rate the post now to show appreciation for your work,
will that mean nobody else will consider answering the remaining question?
 
G

Glenn

JDS said:
Much gratitude. If I rate the post now to show appreciation for your work,
will that mean nobody else will consider answering the remaining question?

No idea. But from experience, if nobody else has jumped in within a few hours,
they probably won't.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top