Print>Properties>Layout>Pages per sheet: this function/property .
 

In Excel, when I select multiple pages per sheet and the multiple pages are
different sheets, then sometimes my hardcopies do have multiple shrunken
sheets printed to one page. Othertimes excel and my printer seem to ignore
my "multiple pages to one page" request. Why?

I've been having the same problem. If you activate multiple sheets, then
tell it to print multiple pages per sheet, Excel only prints the first page
in the multiple sheet format (i.e., one small page in the upper left of the
page.) The rest of the pages come out full size on separate sheets.

Does anyone know how to remedy this. It's been driving me crazy

Since my earlier message I have found that if each active worksheet has been
separately set up to print in multiple page format (through
PrintProperties...Pages Per Sheet) then the active worksheets will print
the multiple pages per sheet. Though I have found this has not worked 100%
of the time. Bye.

"Printer" wrote:


I've been having the same problem. If you activate multiple sheets, then
tell it to print multiple pages per sheet, Excel only prints the first page
in the multiple sheet format (i.e., one small page in the upper left of the
page.) The rest of the pages come out full size on separate sheets.

Does anyone know how to remedy this. It's been driving me crazy