Printing Microsoft Excel sheet in two different formats

1055680 pts.
Tags:
Microsoft Excel
Hello, For my Microsoft Excel document, is there any way to print one sheet two different ways? Meaning print it on Landscape and also Portrait? I hope that makes sense. Thanks!

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can change the page rotation at print time. As far as I am aware there is no clickable option to automatically print it both ways. Remember that changing the rotation will also change the formatting of the pages you may end up with a different page count.  You may be able to write a script to do it but that seems like a lot of work.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • azohawk
    You can set to landscape and print a copy, then set to portrat and print a copy. I don't believe there is a way to do both at the same time. You might be able to create a macro or a write some VB code that will do this for you if you are going to do this frequently with the same sheet. I have not encountered very many spreadsheets that look good printed in portrait. If your sheet does not print on a single page, you will need to configure which columns will print on all pages.
    3,005 pointsBadges:
    report
  • Subhendu Sen
    Actually when we select the format either portrait/landscape, there is Radio button which allows only one selection at a time and there is no checkbox which allows multiple selection. For this mechanism probably this is not possible at a time to print both the format for one sheet. If there are more than one sheet that may possible to change the format for different sheets.
    96,940 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: