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-05-14T01:31:07+00:00

    Hi CW2019,

    Your questions are similar, but the Office products you use are different. Since we tested with the same Office product in same version as Matt but failed to repro and the issue wasn’t fixed after Matt tried the troubleshooting steps, we provided the above suggestion. Regarding to the issue you encountered, we kindly suggest you focus on your thread. The related engineer will provide dedicated support for you there.

    We appreciate your understanding.

    Best Regards,

    Zixuan

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-05-13T07:27:26+00:00

    Hi Matt,

    Apologize for the delay. Thanks for the detailed screenshot and repro file.

    I tested again with the file you provided. But I got the same result that the change for scaling value of Display in Windows setting won’t affect the printing of the workbook in our side.

    Since the behavior persists after you updated the Office version and tried other troubleshooting steps, it isn’t related to specific Excel version, but more like Excel and Windows 7 compatibility issue, and seems only happen to your windows version.

    Considering mainstream Support for Windows 7 Service Pack 1 has ended (Extended Support which contains security updates is still available) according to this article. Could you please upgrade to Windows 10 to see the outcome and receive the best user experience? 

    Thanks a lot for your time and efforts. Much Appreciated.

    Regards,

    Zixuan

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-05-10T16:33:06+00:00

    I would have to produce at least two videos, as you must log out of windows for DPI settings to take effect.

    I don't know how you are testing it, but I am going to PM you an excel file that I just produced for you.  I would like you to use that in a test.  Please note, the file is not saved or changed in any way between Display DPI setting changes.

    With display scaling turned off, the test file the cell displayed in the bottom right of the first page is 9-47 (column 9, row 47).   See below.

    With display scaling turned on in windows, and set at 125%, the cell displayed in the bottom right of the first page is now 10-47, (column 10, row 47).   See below.

    This is the problem.  Please confirm you cannot reproduce this with the test file I PM you.  I've been pretty explicit about what I am doing.  I don't see how a video will help you.  It will just prove what I am saying is actually happening.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-05-10T16:10:53+00:00

    Hi Matt,

    Thanks a lot for your updating.

    Since we can’t repro on our end, could you please capture a complete repro video and share it with us via Private Message for us to move forward this thread?

    Appreciate your time and efforts.

    Best Regards,

    Zixuan

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-04-22T14:06:39+00:00

    Hi Matt,

    Could you please share the result after you tried the above suggestions? We will try our best to provide support for you.

    Regards,

    Zixuan

    Was this answer helpful?

    0 comments