Excel printing and display scaling bug

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! 

I don't like the feedback hub because it feels like you are talking to a brick wall.  When I have a problem I want someone to respond.  How do I know if they are doing anything or understand the problem?  In any case.  If others want to upvote, I've created a feedback hub report here:  https://aka.ms/AA69r35

My company is having the same issue but with 2 separate in-house applications.

When the screen scaling is set to 100%, it prints out full page.

When the screen scaling is set to 125%, it prints out with some whitespace on the right and bottom (I guess 80% of the page)

When the screen scaling is set to 150% is prints out with a lot of whitespace (maybe 67% of the page).

This is on Panasonic Toughbook CF-54s running Windows 10 Enterprise 17763.

Interestingly, I have not been able to replicate the printing issue with Excel.

Bill.

FYI .. I got a new work laptop with windows 10.  Still has the same problem. 

Hi Matthew,

I just wanted to comment and share that I am experiencing the same issue. This affects every computer in my office. It's rather frustrating because I create many templates in Excel for our staff to use. I usually have my display settings in windows at 125% to help with things being small due to my high resolution display. I cannot create templates while using the 125% setting, because the excel templates will end up printing differently for the users in the office who leave their display setting at 100%.

Microsoft, please address this issue.

Windows 7 Pro

Microsoft Office Version 1803 (Build 9126.2259 Click-to-Run)

Thanks,

Taylor

I also am experiencing the same issue. I have used various Excel and Windows versions on different PC's for years. This problem has always existed and causes grief to me and others. I am now using Office 2016 with Windows 10 Pro with a Dell E5470 laptop with an i7 processor, and an Intel HD graphics 530 display adapter.

This is what causes the problem.

I am getting along in years and prefer to have a bigger view of desktop items and files I open when using my desktop, so I go into display settings (Scaling) and increase the size of apps, and text etc to 125% or 150% of normal. (150% is recommended by Windows, however same symptoms on both instances.)

Then when working with an excel file, I format column width to optimum by selecting the column and then tapping beside the vertical bar and the column auto-sizes the width.

After saving the file(s), I then email to various other users in our company who have their display resolution set to 100% instead of my 150%.

When they open the excel file, the columns are too narrow and certain numbers may show as #######, or alternatively the column titles extend beyond the width of the column.

This has been the case for years and years.

In addition, here is another test for you.

Create an excel file with column titles and large numbers in the columns so that when you auto size the width, the columns are pretty much full.

Now still within excel, reduce your screen size to 70%, using the zoom field within excel.

You will notice that the numbers in the columns will become ######## plus the column titles will exceed the width of the field, and need to be auto sized once more.

This is annoying and unproductive.

MatthewMPW, just stumbled on your post here, I had the exact same problem with an excel spreadsheet. Scaling was set correctly, print preview looked correct, but no matter what copier my customer printed to in the city (municipal IT here), it would print a single enlarged portion of the spreadsheet.

A colleague and I found the issue for us was the DPI settings, which should not act like this, but sure enough, changing from 1200 to 600 DPI resolved the issue. Obviously there's other factors in play here, but I figured I'd put my $0.02 in, especially since you're having suggestions that do not pertain to the issue at hand.

Hope that helps!