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 No comments

79 answers

Sort by: Newest
  1. Anonymous
    2019-06-21T13:47:30+00:00

    Hi Chris,

    Thanks for your feedback. I haven't get the update, I'll also share this information to the related resources.

    Best Regards,

    Jim

    It's been 14 months since I reported this issue.  Can we get an update?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-06-18T17:13:19+00:00

    We had everyone on Windows 7 and had to pull everyone down to Medium scaling to make sure we replicated everything to a T.  Now with Windows 10, the scaling is not exactly the same which makes this an oh so fun project that I am not looking forward to.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-06-18T16:57:20+00:00

    Have the same issue in Win 10 Pro Excel 2016. Setting scaling to 100% has not fixed unfortunately.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-06-18T00:39:36+00:00

    I feel your pain.

    Excel wasn't made for lots of things and I wish they would make an Excel / Word / Adobe tie in type program.

    Until my company wants to move this to a web based program... STUCK. :)

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-06-17T23:43:13+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.

    I tried scaling it did nothing in my case.

    When I am at work, plugged into my laptops docking station, no problem, scaled correctly.

    Anywhere else? Hells to the no.  Infuriating as I produce price lists for our reps and it is nigh impossible at home, unless i want to give them the microsoft patented half page squint-o-rama.

    Honestly how you manage this bug is beyond me.  If the pages are already set up to print a certain way, how the hell do you manage to screw that up by SCREEN SIZE?!  The two should not even relate to each other.  Amazing.

    Was this answer helpful?

    0 comments No comments