Excel printing and display scaling bug

Anonymous
2018-04-10T15:17:07+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

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

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2019-01-24T21:58:23+00:00

    This might sound crazy but have any of you played around with the cell styles.  I dont remember what update it was but all of a sudden the tool bar at the top looked different with the cell styles not displaying in the tool bar but an Ikon with an arrow.  with that being said if you change the cell style font everything on the screen changes in reguards to how its desplayed.  so Im wondering when that style chosen is different for a spread sheet than the default in your excel options, could that be the problem.  I can tell you my scaling problem started when they changed the tool bar ikons to the larger ones.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-01-24T21:36:53+00:00

    I randomly ran into this problem as well.  Office.com support was literally cluess but I found what fixes the printing format for me.

    When setting the properties on excel.exe under the compatibility tab I had to use the "change for all users" option, then "change high DPI settings" 

    Then using the option at the bottom "High DPI scaling override" setting set to "system" fixes excel changing the page layout in response to the windows resolution scaling.

    The side effect of this workaround is that your excel text will not be as clear, but i can deal with it slightly blurry rather than printing incorrectly.

    I just have to say that this type of thing is totally unacceptable.  I mean these are both microsoft products and why a display resolution scaling option would impact how page layout formatting is rendered really just underscores MS lack of quality control when they roll out these updates and I really hope they get this big fixed soon.  

    If you changed the DPI settings but did not restart the PC, or at minimum sign out and back in, your DPI settings may not have fully taken effect.  I only suspect this because blurry text is a symptom of this.  That could possibly explain why the problem didn't occur for you.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-01-24T21:24:08+00:00

    I randomly ran into this problem as well.  Office.com support was literally cluess but I found what fixes the printing format for me.

    When setting the properties on excel.exe under the compatibility tab I had to use the "change for all users" option, then "change high DPI settings" 

    Then using the option at the bottom "High DPI scaling override" setting set to "system" fixes excel changing the page layout in response to the windows resolution scaling.

    The side effect of this workaround is that your excel text will not be as clear, but i can deal with it slightly blurry rather than printing incorrectly.

    I just have to say that this type of thing is totally unacceptable.  I mean these are both microsoft products and why a display resolution scaling option would impact how page layout formatting is rendered really just underscores MS lack of quality control when they roll out these updates and I really hope they get this big fixed soon.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-01-24T01:29:24+00:00

    Hi Chris,

    Thanks for your feedback. I haven't get the update, I'll also share this information to the related resources.

    Best Regards,

    Jim

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-01-23T20:32:49+00:00

    Similar problem with Excel 365 on Win10. I have 3 screens (main laptop screen scaled 125% and two monitors with 100% scaling). I have to move Excel to the laptop screen in order for printing to work properly. Same exact chart in the same workbook prints off the page when Excel is running on the monitors. I move the program (without closing and reopening or anything) to the main laptop screen and everything prints correctly. Print preview looks correct in all cases, but output on paper or PDF changes.

    Was this answer helpful?

    0 comments