Printing a workbook but not getting page set-up results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen S. - 14 Nov 2007 21:08 GMT

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 to this Message

Gord Dibben - 14 Nov 2007 23:46 GMT

Instead of printing the "entire workbook" you should right-click on the first
sheet then "Select all sheets"

Now File>Print>Active Sheet(s).

Gord Dibben MS Excel MVP

>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 to this Message