Excel printing and display scaling bug

Anonymous

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.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

79 answers

Anonymous

2020-03-17T20:56:21+00:00

Just wondering if this works on your computers as I finally got mine so somewhat be close or tolerable

Excel options: default font type and size matches the cell styles for "normal" along with the font type and size ( both on the excel ribbon at the top) further switch the current setting you have chosen to opposite in excel options general optimize for best appearance or compatibility
Was this answer helpful?

0 comments No comments
Anonymous

2020-03-18T12:07:59+00:00

Just wondering if this works on your computers as I finally got mine so somewhat be close or tolerable

Excel options: default font type and size matches the cell styles for "normal" along with the font type and size ( both on the excel ribbon at the top) further switch the current setting you have chosen to opposite in excel options general optimize for best appearance or compatibility

It's actually been quite a while since I checked if this problem still exists. I tried it for the sake of testing this. It does, and this didn't appear to help me at all. Thanks.
Was this answer helpful?

0 comments No comments
Anonymous

2020-05-05T18:18:36+00:00

@msft any hope in fixing this?
Was this answer helpful?

0 comments No comments
Anonymous

2020-06-15T18:27:02+00:00

Same thing happening for me and my team. Windows 10 with the latest office offerings (O365). Like others have said, excel prints normal when Windows scaling is set to 100%. Prints wrong when set to anything else. We use excel to generate proposals...only can print them when in the office and docked to our 27" 1080p monitors. Whenever you disconnect the external monitors, Windows changes scaling to better fit the small laptop screen. This causes excel to print incorrectly. MICROSOFT, WE NEED A FIX. THIS IS UNACCEPTABLE!
Was this answer helpful?

2 people found this answer helpful.

0 comments No comments
Anonymous

2020-07-10T08:22:17+00:00

I've also ran into this bug, Windows 10 2004 64-bit and Excel 365. The workaround I'm doing doesn't involve signing out and in, I just make sure Excel is closed, set scaling to 100%, open Excel, and set scaling back to 175%. In my case as long as Excel is opened while display scaling in Windows is set to 100%, it will keep the correct printing layout. As long as Excel is kept opened, I can open other files and will print correctly, as far as I can tell.

This also works with Remote Desktop, Log into RD with 100% scaling, open Excel, log off RD, and log back in with the scaling I want.

But geez, more than 2 years and nothing, Microsoft. Really?
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments