I have 4 worksheets to print for a report that will be bound in upper-left corner (portrait layout). Page numbers to be in top left (portrait orientation) of every printed page

One sheet is an evidence page. It is 1 page from a text file report with Landscape orientation. I want to keep that orientation but the header/footer needs to remain in Portrait orientation.

Without transposing the individual characters in each line (and reversing the order), is there a formatting to allow this ?

Alternatively, what is the next simplest method?

• Moved by Fei XueMicrosoft contingent staff 1 hour 55 minutes ago

There is no really easy way to do this - see Landscape Excel file but we want a Portrait Header for some suggestions.

Hi Spillerbd,

Thanks for posting in MSDN forum.

This forum is for developers discussing developing issue involve Excel application. Since the issue is more relative to end-user, I'd like to move it to Excel IT pro forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Regards & Fei