How to print multiple pages per sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MKG - 21 May 2008 21:22 GMT

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?

Reply to this Message

Gord Dibben - 22 May 2008 04:10 GMT

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

>Office 2003 on Windows XP.
>
[quoted text clipped - 10 lines]
>
>So why can't she use it in Excel?

Reply to this Message

MKG - 22 May 2008 13:52 GMT

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.

> Don't understand what you're getting at.
>
[quoted text clipped - 19 lines]
> >
> >So why can't she use it in Excel?

Reply to this Message

Gord Dibben - 22 May 2008 15:46 GMT

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

>Yes, I meant to say multiple copies on the same sheet.
>
[quoted text clipped - 25 lines]
>> >
>> >So why can't she use it in Excel?

Reply to this Message