A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Please restrain yourself from multiple postings of the same issue. It's in bad taste, promotes the ignoring of the thread. I have merged (I think all Multiple copies) into this one thread the deleted the multiple attempts. If I have missed any, my apologies.
First, you posted your question on a weekend. Which means that most people are occupied with other matters. Also, as you know many of the volunteers don't live in the Americas. So many are asleep that could answer the question.
I've tried a test where I changed orientation, of one sheet. And you are correct regardless of what can be set from the ribbon you can only use either Portrait or Landscape, The mac version can't mix.
So to do what you need is create two files, one that has the landscape orientation, and one with the Portrait orientation.the collate by hand.
Please refrain from Multiple posts, and wait for an answer.
_________
Disclaimer:
The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.