Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print multiple pages on one sheet | Excel Discussion (Misc queries) | |||
Print Chart in New Sheet on Two Pages | Charts and Charting in Excel | |||
Print multiple pages with different name. | Excel Discussion (Misc queries) | |||
print different row titles in one sheet w/ many pages | Excel Worksheet Functions | |||
Print multiple pages per Sheet in Excel 2003 | Excel Discussion (Misc queries) |