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."
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.