Excel for Mac only printing in one orientation

Anonymous
2016-11-26T04:32:11+00:00

I have no problem printing portrait and landscape within one single document in Word for Mac with my current printer driver. However, when I print from a worksheet from Excel (Mac) that has portrait and landscape sheets within it, it prints them all to portrait, unless I change it in the Print menu, but then it will print all sheets to whatever orientation I select. This is so easy to do in the Windows version of Excel. How come I can't do it in a Mac????? I already did the trick of moving the Excel plist to the desktop. That didn't work. I don't think I have a printer driver problem because I don't have a problem with Word. This is my first Mac computer. Please help!!!!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2016-11-26T23:28:53+00:00

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.

Was this answer helpful?

0 comments
Answer accepted by question author
Bob Jones AKA CyberTaz MVP 437.7K Reputation points
2016-09-15T16:19:52+00:00

I'm afraid I don't have a solution but FWIW I have no similar problem here regardless of whether my Epson or my HP is the selected printer. Nor have I seen any similar complaints :-)

If the sheet is set to Landscape (using either the button on the Page Layout tab or through the File> Page Setup dialog) it appears as Landscape in the Print window.

Likewise, even if the sheet is set for Portrait & I choose Landscape in the Print dialog the switch is passed back to the file.

Was this answer helpful?

0 comments
Answer accepted by question author
Anonymous
2010-02-09T04:27:03+00:00

Method1: Try changing the orientation:

Open word -> click on Page Layout  tab-> Orientation-> select  Landscape and try printing .

Method2: Try printing the document using other printer ( e.g. OneNote, Microsoft xps) for this :

Click on office button-> print-> from the drop down select  the One note or Microsoft xps .

Method3: If this works , then you follow the below article to check some printing problem:

http://support.microsoft.com/kb/870622.

Ruchi Bisht, Microsoft Answers Support Engineer.

• We appreciate your participation in MS Forums, Help us understand your needs better. To share your valuable Feedback please Click here.

Was this answer helpful?

0 comments

59 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2016-11-28T14:18:40+00:00

    My question is not a duplicate of this one. 

    This question was about printing both landscape and portrait in one document.

    My question was about Excel refusing to print a single page document in landscape. These are two entirely different questions and I don't appreciate your hostile tone.

    Was this answer helpful?

    0 comments
  2. Jim G 134.1K Reputation points MVP
    2016-11-28T16:13:12+00:00

    Hi Karla,

    It is difficult to convey tone in short answers in the forum. I've seen Phillip's postings for years and know at least enough about Phillip to know he would never mean to imply a hostile tone. He's simply trying to be helpful.

    As far as merging the questions goes, what's done is done. Unmerging is technically possible but there's no reliable way to know which follow-up answers will follow if we split this thread.

    Regarding printing a workbook having worksheets having different orientations, there is a feature suggestion and discussion about the topic in UserVoice, a different forum dedicated to letting Microsoft know how actual users want certain features to work. The current behavior is "by design," meaning this is the way Microsoft designed Excel to work. Printing is currently working the way Microsoft expects it to work. Please vote to have this changed by voting for this feature request and commenting about it here:

    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/10605018-printing-vertical-and-horizontal-worksheets

    The UserVoice forum is user-to-Microsoft. UserVoice comments are read by Microsoft personnel. This forum right here is primarily user-to-user, although lately Microsoft employees have been joining in frequently.

    Now let's focus on the problem of not being able to print a single page document in landscape. Let's do a quick review to make sure we're on the same page (pun intended). In the problem workbook, go to File > Page Setup and then click on the Sheet tab. Is the Print area specified? If yes, does it make sense for this worksheet? Click on the Margins tab. Do the margins make sense for this worksheet? On the Page tab, what is the Scale setting? Usually you will want 100%.

    Was this answer helpful?

    0 comments