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.

Documentation:

https://support.office.com/en-us/article/print-with-landscape-orientation-in-excel-for-mac-5b26f602-ed29-46bd-992a-52dd9d4770e7

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

when I select a print area, and then go to print - it seems to be the default to have print entire workbook - and I can't seem to change the default, or set up new presets that return automatically, so I just get print the print area selected and set? I used to be able to do this. This slows down my work process considerably and is a massive inconvenience. Who wants print entire workbook as a default? No-one I know. I've tried doing the string as a new preset, but can't get it to return automatically. Printing a selection is now a prolonged and slow process. I used to be able to do this, until quite recently. see screenshot. Can we go back to how it was before this 'upgrade'.

It would be amazing if there was a way to select certain cells and mark them as “DO NOT PRINT”. So that these cells could be visible while I’m working but not print out when I sent the worksheet to print. I know I can hide rows or columns but I need only specific cells. I also know I can change the font to white, but that hinders my ability to see the cells while working or would make me have to constantly change font colors back and forth. This could even be added in the “Protection” tab under “Format Cells”. Options could be “Protect”, “Hidden” (as they currently are) and add “Do not print” as a third option. Perhaps another route would be with conditional formatting, say do not print cells highlighted in yellow? I’ve scoured the internet for a way to do this but have not found a good simple solution that doesn’t involve complicated macros that change font colors back and forth.

This is a file that I work constantly throughout the day and print multiple times a day, so a simple solution would save me a lot of time. (And trust me, I want to be green and not print as much, but it's a must for my job.)

In Excel 2011 and for Windows you used to be able to scale the spreadsheet when printing by setting the Scale to Fit option on the print menu to 1 page wide and leave the pages tall blank (or vice versa). This will no longer work, setting pages wide or pages tall to blank is no longer allowed, 1 tall or 1 wide is the minimum setting. To get this option to work you have to go to the File Page Setup window and set the scaling on the Page tab. This is clumsy and inconvenient. Please bring back the option to do this at print time in the print page.