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.
Matt Stride
shared this idea
This issue has been fixed and the fix will be available in version 16.35 or greater. You can get the fix in the monthly update available in March 2020, or you can get it sooner by opting into the Insiders Program and getting the Fast updates. To opt into the Insiders Program, go to the help menu and choose Check for updates. Then click the Advanced button and opt into the program and make sure you choose Fast updates.
Previously, orientation and paper size settings on individual worksheets were being overridden by the setting in the Print dialog. This meant that if you had 1 sheet to print in Portrait, and another in Landscape, you had to print them separately, otherwise they would both print in the same orientation. The settings were removed from the print dialog and now should be set on the Page Layout tab of the ribbon for each specific worksheet.
Please send feedback by clicking the Smiley-face button in Excel if you notice any issues with this or anything else in Excel.
37 comments
-
Michelle - it would be great if you would send feedback about this issue by clicking the smiley-face button in Excel, so I can get more details from you about this.
-
Michelle
commented
Thanks for fixing the page layout! This is now back to the way it used to be for many years. Well partially! My page layout settings, which I do in the page layout sections, includes specific page numbers, which seems to be fine if the page is only one page long, but one of the sheets I have contains two pages and the page numbers for those seem to create their own numbers, based on the chronological number of pages I have grouped, so once again ignoring my settings. See page 5 and 6, (containing tables) which should be pages 4 and 5. In the page layout option, I have set these pages to have the first page start at 4, and in the footer use the &page option which should pick up the page starting at 4 and the next one five. (I have placed yellow highlights on each page as to what each page number should be).
-
Michael Hayes
commented
Hooray!!!!
-
Kumar
commented
Thanks Steve for working on it. Really appreciated. Also wish to thank you for keeping us updated during the process. Once I manage to update, will let you know if it's all working well.
-
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.
