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: Most helpful
  1. Anonymous
    2020-03-17T20:56:21+00:00

    Just wondering if this works on your computers as I finally got mine so somewhat be close or tolerable 

    Excel options: default font type and size matches the cell styles for "normal" along with the font type and size ( both on the excel ribbon at the top) further switch the current setting you have chosen to opposite in excel options general optimize for best appearance or compatibility

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-01-13T15:33:23+00:00

    Matthew,

    Congrats on your patience. I've never run into this problem, until recently, we've always had our workstations at 100% with no need to change scaling, but with VPNs, and advancing technology and better monitors at home, we've found the need to scale our workstations sometimes to 125% when connecting through remote desktops, etc... Well, let's just say, this caused some messes now, and our main accounting computer that prints checks, and reports from Microsoft Dynamics NAV (yea, it's not Excel, but still a Microsoft product) will only print correctly if the computer is left in 125% scaling. Anytime we scale the display back to the normal 100% it actually makes the print job larger, and prints off the page, which, when trying to print checks, is not good when things prints off the check!

    We figured we just messed something up and confused Windows from remote desktop, multiple display settings and scaling issues, etc.. etc.. Sad to see this has been a nearly a 2 year battle with no real updates.

    The workstation in question is a basic HP with built in Intel onboard graphics running Win 10 Pro. Using nothing but Windows and Microsoft products.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-11-18T14:00:28+00:00

    You have too many columns and too much white space.  Reduce column widths to remove excess white space.  Reduce column widths and wrap text (Item Name, Item Contents, Campaign Items needed).  Doing that, you might get it to print out on 11x17 paper and have it still readable.  Maybe need to hide some less important columns.

    Also, check your default page size and scaling factors.  Page 1 just doesn't look like 8½x11 paper.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-11-12T19:09:40+00:00

    I've used excel for the better part of 20 years.  I cannot figure out why I cannot scale this spreadsheet to fit AND BE READABLE once printed.  It's printing too tiny to read, and dragging page breaks, setting scaling, and trying all of the other things mentioned here, are not working  can anyone help??  I just want 1 or 2 pages, readable, and with all columns visible. 

    Thank you! 

    This isn't what this post is about.  This is about display scaling changing how something prints.  I will say, I'm not sure if I misunderstood you, but I don't see how it is possible to print that with all columns visible AND have it readable.  Just look at the picture, have you ever seen a piece of paper that shape? You need less columns or a longer piece of paper.  You should make a separate post and ask this question if you still need help.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-11-12T18:08:06+00:00

    I've used excel for the better part of 20 years.  I cannot figure out why I cannot scale this spreadsheet to fit AND BE READABLE once printed.  It's printing too tiny to read, and dragging page breaks, setting scaling, and trying all of the other things mentioned here, are not working  can anyone help??  I just want 1 or 2 pages, readable, and with all columns visible. 

    Thank you! 

    Was this answer helpful?

    0 comments No comments