How to print multiple pages per sheet

[MKG]

Office 2003 on Windows XP.

In Word, you have the option to print multiple pages per sheet. In Excel,
this option is not on the print dialog. However, if you go to print
properties, layout, the option is there.

I found this out printing to a HP LaserJet 8150 PS.

Another user who has a 4250 printer cannot see the Layout tab in her printer
properties so she's unable to use this functionality. However, this feature
IS supported by her printer driver because she can use this function in both
Word and Acrobat Reader!

So why can't she use it in Excel?

 

[Gord Dibben]

Don't understand what you're getting at.

You can set the print range for any sheet to include multiple pages.

Or if you mean multiple copies of the same sheet, it is on the File>Print Dialog
under "Copies"


Gord Dibben MS Excel MVP

 

[MKG]

Yes, I meant to say multiple copies on the same sheet.

In Excel, it doesn't show on the print dialog though. Under Copies we only
have the option to choose how many copies of the file to print, and collated
or not.

 

[Gord Dibben]

Copies setting means how many copies of the selected sheet(s) or range to print,
not copies of the file.

Under the same Print dialog you have "Print What" with 4 choices.

Selection
Active worksheet(s)
Entire Workbook
List(if one exists)


Gord