This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
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
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.
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
Hello Matt,
It pains me to see all of this microsoft is making you go through, I have the exact same issue on windows 10 and have sent them videos as well, they just dont want to admit they have a problem here, as they have yet to get back to me. This is a bug, fix it. Stop giving everyone the run around and admit it.
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