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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-25T05:29:17+00:00

    We have the problem with both custom and narrow margins, and on several computers in the company (all which have been checked).

    We found out that the scaling errors are somewhat constant on a specific computer. As a temporary solution we have applied correction factors (in both x and y dir) on all the figures in the given spreadsheats. The figures then appear "unscaled" in the pdf print, however in the exceel sheet they are stretched. 

    This is not an optimal solution, as correction factors need to be applied on every single computer and the figures appear stretched when working in excel.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-08-24T14:13:37+00:00

    I have had this very issue with a user, however I am unable to recreate on my computer however on theirs it happens.

    To work around I have managed is to get the user to print to PDF and swap between margins (Custom to Narrow) and each time we print now we set the margins to be "Custom" then back to "Narrow" and it works perfectly.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-05-05T18:18:36+00:00

    @msft any hope in fixing this?

    Was this answer helpful?

    0 comments
  4. 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