| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing a workbook but not getting page set-up results
When I print an entire workbook in Excel it prints everyting in portrait
style when I have both portrait and landscape page set-ups in the workbook. I have several worksheets that I have defined in page set-up to print landscape but they always print portrait style. If I print each worksheet individually, they print correctly. I would like to be able to print the entire workbook with one click of the button. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing a workbook but not getting page set-up results
Instead of printing the "entire workbook" you should right-click on the first
sheet then "Select all sheets" Now FilePrintActive Sheet(s). Gord Dibben MS Excel MVP On Wed, 14 Nov 2007 13:08:04 -0800, Karen S. <Karen wrote: When I print an entire workbook in Excel it prints everyting in portrait style when I have both portrait and landscape page set-ups in the workbook. I have several worksheets that I have defined in page set-up to print landscape but they always print portrait style. If I print each worksheet individually, they print correctly. I would like to be able to print the entire workbook with one click of the button. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
| Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
| Printing Headers on only first page and Footers on only last page | Excel Discussion (Misc queries) | |||
| Printing multiple page worksheets on 1 single page | Excel Discussion (Misc queries) | |||
| printing multiple page workbook | Excel Discussion (Misc queries) | |||
Linear Mode
