Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
MKG MKG is offline
external usenet poster
 
Posts: 4
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
MKG MKG is offline
external usenet poster
 
Posts: 4
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print multiple pages on one sheet Dorci Excel Discussion (Misc queries) 5 July 11th 07 06:36 PM
Print Chart in New Sheet on Two Pages KHanna Charts and Charting in Excel 0 April 20th 06 05:23 PM
Print multiple pages with different name. Annepaws Excel Discussion (Misc queries) 1 August 19th 05 02:26 PM
print different row titles in one sheet w/ many pages Carman Law Excel Worksheet Functions 2 May 24th 05 12:08 PM
Print multiple pages per Sheet in Excel 2003 Chris N Excel Discussion (Misc queries) 1 May 4th 05 03:17 AM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"