How to print entire workbook 9 pages to a sheet?

[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...

 

[Glenn]

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.

 

[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.

 

[Glenn]

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.

 

[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!

 

[Glenn]

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?

 

[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?

 

[Glenn]

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.