Bug: Print sets page layout to the same across all worksheets on Excel for Mac
To reproduce the issue, setup two sheets with different page layout (e.g. fit to pages, orientation etc). Select both and press print, then press cancel. Both sheets will now have the same print layout. This seems like a bug because:
- This is not expected behaviour as it directly contradicts the documentation for Excel for Mac (see link below)
- Pressing print shouldn't change the design of the spreadsheet and destroy painstakingly setup per-sheet page layout settings that take a long time to fix after this bug has paved over them
- The Windows version does not have this problem
- It is highly counter-intuitive
I have seen cases such as https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/10605018-printing-vertical-and-horizontal-worksheets where subsets of this issue have been treated as a feature request and been left on the back-burner for years - that one has been open since 2015 despite people indicating that it is severely impacting their business. It is a bug, not a feature request and is seriously impacting Mac users.
From the documentation:
"Note: Because you can set page orientation on a sheet-by-sheet basis, it is possible to print some sheets in a workbook in one orientation (such as portrait orientation) and other sheets in the same workbook in the opposite orientation (such as landscape orientation). Simply set the orientation for each sheet as appropriate, and then print the entire workbook."
This issue has been fixed and the fix will be available in version 16.35 or greater. Go to the help menu and choose Check for 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 feedback button in Excel if you notice any issues with this or anything else in Excel.
and in 2020, the bug still exists
Michael Hayes,Sr commented
AGREE! This version of Mac EXCEL requires all workbook pages to have the same PRINT orientation - very frustrating, and once upon a time , this did not happen.
YES YES YES
Page orientation set in an Excel document/worksheet should stay put until the user changes it and it should print in that orientation unless otherwise changed during print. It should not revert to portrait (in both worksheet & printer) whenever print is selected. Hence, you should be able to have a workbook that contains worksheets of both portrait and landscape orientation and be able to print them all together. This is an unbelievable shortcoming.