How to print multiple pages per sheet
 

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?

How to print multiple pages per sheet
 

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 FilePrint Dialog
under "Copies"


Gord Dibben MS Excel MVP

On Wed, 21 May 2008 13:22:00 -0700, MKG wrote:

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?

How to print multiple pages per sheet
 

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" wrote:

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 FilePrint Dialog
under "Copies"


Gord Dibben MS Excel MVP

On Wed, 21 May 2008 13:22:00 -0700, MKG wrote:

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?

How to print multiple pages per sheet
 

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

On Thu, 22 May 2008 05:52:01 -0700, MKG wrote:

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" wrote:

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 FilePrint Dialog
under "Copies"


Gord Dibben MS Excel MVP

On Wed, 21 May 2008 13:22:00 -0700, MKG wrote:

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?