Printing vertical and horizontal worksheets
When printing within a workbook that has both vertical and horizontal work sheets the page orientations all become vertical or horizontal rather than maintaining the original orientation.

Thanks for your support for this issue. We are planning to work on it soon, and we recognize that it has gone a long time without being addressed.
Please answer a short survey about this topic to help make sure we get to the best solution – https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR6Vq1--mcHNHh95T6_DZcJFURDg2NlNBTFZUSkJRNUEyQzVFRTQ0T0hHSi4u
33 comments
-
Michelle commented
When are you planning to work on this issue? How soon is soon?
-
Anonymous commented
.1BVS/=LC/ASP/OK$
-
Michelle commented
How is this still an issue in 2019?
-
Kumar commented
Very surprising that this issue is known for more than 3 years since Office365 for MAC was launched. Office 2011 for MAC handled this better. Why isn't MS been able to fix this issue and incorporate a fix in one of the updates? Same error / issue is noted when saving a workbook into PDF using Adobe products. Urgent attention is requested.
-
vvv888 commented
I have a workbook with vertical and horizontal orientation of sheets. In order to print it with page numbers I print to pdf every sheet separately, then use Automator to merge pdfs to single file, then use Soda online to enumerate it. And bingo! I can print it at last!
Microsoft, are you mad? -
Jane Little commented
Is this fixed yet ? So annoying.
-
E commented
I hate this change!! It has cost me hours and hours and hours of headaches.
-
Michele commented
Please, any news about this feature? It will be included for Mac in Office 2016 or will be included in Office 2019? Thanks!
-
Jennifer commented
Spent waaaaaay too long chatting with support tonight to try to get help with this issue only to be told that he couldn't help and it would have to go to development. I only recently updated from the version of Excel I purchased in 2012 and am SHOCKED and beyond disappointed that this new version cannot handle something the old one did with ease. While there is a work around, it is going to be incredibly time consuming. Please fix this soon!!
-
James SMith commented
how is this still an ongoing issue?! fed up of constantly having to check back here.
-
Guy Miller commented
Agreed, it is bad enough that Microsoft has included this non-logical "bug" in Excel - very poor quality work. Microsoft should be more ashamed of itself though for not do anything about fixing it! These comments date back to 2015!
-
tangolovers commented
It is very common to have worksheets with different/mixed orientation in the same workbook. Usually the 1st page is some kind of summary or table of contents. It is totally unacceptable that the orientation can not be set (AND STAY SET) so you don't have to print page by page.
Also, Excel seems to always default to Portrait when printing and you always have to change it manually - every time you print. Also unacceptable!! Terrible behavior from a software that is supposed to be an industry standard!
-
Cameron Porcaro commented
We were using Office 2011 and this functioned as it should. We switched to Office 2016 and discovered that it was broken. We had to roll back to Office 2011 On macOS 10.13 in order to get this feature back.
-
The Neutral Guy commented
Mac is handling printer drivers differently than PC.
MS did not break this. They need to work around how things work on Mac but this takes time, even less when in a digital era, less and less people is using printing features in such applications. Let's give them time to fix it since it is most probably not a priority. -
Barb C commented
When I print a calendar I put the setting to landscape, it prints out in portrait .how do I change this ? it prints out the whole calendar ,but I do not want it in portrait style.
-
Ken A. commented
Need this fixed so behaviour is the same for Mac & Windows. This is working on Excel 2016 on Windows 10.
-
Anonymous commented
This is very cumbersome in the new excel 2016. Excel 2013 and previous version did this easily. How was this overlooked with this new rollout. This affects both MAC and WINDOWS users!
-
Rc2 commented
Microsoft - the ability to print workbooks using a combination of both horizontal and vertical worksheets is a must. Please fix this for all Mac users. Thank you.
-
Martha commented
I recently upgraded from a PC to a Mac and was very disappointed that I can not print both vertical and horizontal within the same workbook ... it worked fine with the PC. I need this for my business for both printing and conversion to PDF. I hope Microsoft will resolve this soon.
-
Anonymous commented
I agree, this is basic functionality that has been in use in Excel from the beginning of time. What kind of developer at Microsoft would "intentionally" omit this feature/functionality with Excel for Mac 2016?