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-02T02:27:36+00:00

    AMD FirePro W4190M

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-01-01T01:32:59+00:00

    Hi JasMed, Taylor & CW2019,

    I got a feedback. To further investigate the issue, please confirm if you are also using Nvidia display card and share its details with us.

    *We did some tests and cannot reproduce the issue with other display cards like Intel Iris Plus Graphics 640.

    To check this, you can run Computer Management > Device Manager > Display adapters to view the display adapter information.

    Best Regards,

    Jim

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-11-16T17:56:50+00:00

    My work around was to purchase reading glasses. *face palm*  

    Hopefully they fix it someday....

    Was this answer helpful?

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