Excel printing and display scaling bug

Hello,

Has this issue been resolved or can Microsoft provide a update?

I have recently encountered this exact problem, in both Windows 7 and Windows 10.

I have a for set up to print exactly to one page wide. Changing the scaling in the Windows display settings (after logging off and logging on again after the change - this is important in Windows 10, as it doesn't give a notification, Windows 7 forces this/gives a warning pop up) impacts how the document prints and fits to the page dimensions, either pushing content onto a second page, or creating extra space in the margin.

For the record, we are using onboard graphics. On my machine it is Intel HD Graphics 5500, however I find it hard to believe it is linked to this.

Hi Brian,

Sorry to hear that. I had asked multiple times but unfortunately haven't get update from related resources. Also considering it has been a long time, I apologize for that. Given this, here's another way to send feedback, where you can directly contact the relevant team.

Best Regards,

Jim

I am having the exact same problem. Excel files that have printed perfectly for years are suddenly shifting (now they won't fit to one page vertically.) I'm having to shrink to fit but then it shrinks everything side to side also. 

It's very annoying. It's also shifting drawing objects so they no longer line up. I have a feeling it has something to do with the application that supposedly fixes programs that may appear blurry depending on the display.

Please find a solution to this problem as it's eating up much time trying to print things correctly. (to PDF by the way).

Thanks

The whole point of this post is that this happens when you turn on display scaling.  If you have a  large or small screen, its possible it is on by default.  Normal sized monitors won't turn on display scaling by default.  By on, I mean set to something other than 100%, regardless of the "recommended" setting.  You can work around your problem with printing by setting the scaling to 100%.  You must log out of your user profile and log back in (or restart computer) for these setting to FULLY take effect.  They do partially turn on immediately in windows 10, but you should log out or restart to test it.

Windows 7 Pro

Office 365 x64 ver 1709 (Build 8431.2236 click-torun)

When printing with Excel, the page layout is being affected by display scaling.  I had it set at 125%.  A spreadsheet that normally prints to 6 pages is trying to print to 9 or 10 pages.  Adjusting the page size in "page break view" does not fix the problem.  This is with the setting, "fit all columns on one page".  If you simply reduce the *print* scaling (by a percentage, instead) until it print on only 6 pages, the sheet appears more narrow than it normally does.

If you simply set the display scaling back to 100%, it fixes the problem.  Display scaling should only change what I see, not how it prints.

Furthermore, checking the box under excel shortcut:  "disable display scaling on high dpi settings" does NOT disable the display scaling for excel like it should.  I had to completely shut it off under display settings to resolve the problem.

Edit:  Added *print* to the scaling option I was referring to.   Please note display scaling setting is in windows and print scaling is in excel.

I tried scaling it did nothing in my case.

When I am at work, plugged into my laptops docking station, no problem, scaled correctly.

Anywhere else? Hells to the no.  Infuriating as I produce price lists for our reps and it is nigh impossible at home, unless i want to give them the microsoft patented half page squint-o-rama.

Honestly how you manage this bug is beyond me.  If the pages are already set up to print a certain way, how the hell do you manage to screw that up by SCREEN SIZE?!  The two should not even relate to each other.  Amazing.