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 No 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 No 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 No 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 No comments

59 additional answers

Sort by: Most helpful
  1. Anonymous
    2016-09-15T15:08:14+00:00

    OK, excel doesn't seem to correctly pass the landscape setting on to the printer (where Word does. Annoying).

    The fix is to hit print to get the print preview, then [show details]. There, the orientation is set to portrait. Change it to Landscape and you're good to go. 

    It's irritating as **** to have to set it to Landscape in both Excel and the print preview (and you have to set it every single time you want to print).

    Fix this please, Microsoft!

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2016-09-15T13:49:08+00:00

    I have recently upgraded to Office 2016 for Mac via Office365. I only use Word and Excel. With the new version, Excel will not print in Landscape, but Word does just fine.

    In excel, I select Landscape orientation and the margin lines appear correctly, but as soon as I go to print, the print preview reverts to portrait. I've tried setting print areas and it makes no difference. Also, printing to PDF has the same result.

    I have a Canon MB2350 and have downloaded the drivers again but it is still the same. 

    Mac OS 10.11.5

    Excel 15.25

    Was this answer helpful?

    0 comments No comments