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
    2018-11-16T17:47:32+00:00

    If it helps anyone else get around this issue - we found that if you have 2 or more monitors, setting just one of them to 100% is enough to fix this issue.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-08-21T01:42:30+00:00

    Hi All,

    Sorry for the late response and inconvenience it caused. Previously I had contacted the related team and will share update here once available.

    Currently I haven't get the update, but I'll report your situation again and consult team.

    Best Regards,

    Jim

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-06-10T03:43:07+00:00

    Hi Matthew,

    Thanks for your reply. I've received the logs in your PM.

    Yes, you can also share the log running on another machine with us at your conveinence.

    Best Regards,

    Jim

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-06-07T12:16:24+00:00

    I'm running the tool on my work computer now.  If it's any consequence, I've completely uninstalled and reinstalled office after I first had this problem, I believe in April.

    I'll try to remember to run it on my home computer later.  I assume more information is better.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-06-07T01:41:32+00:00

    Hi Matthew,

    We need to collect the log to further analyze your Office client. 

    Please use the Office Configuration Analyzer Tool (OffCAT), which provides a detailed report of your installed Office programs.

    Once finished, you can send the log file with us via PM.

    Thanks,

    Jim

    Was this answer helpful?

    0 comments