Excel printing and display scaling bug

I feel your pain.

Excel wasn't made for lots of things and I wish they would make an Excel / Word / Adobe tie in type program.

Until my company wants to move this to a web based program... STUCK. :)

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.

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.

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

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