Excel File not appearing the same on different computers.

[andrewb90]

Hello All,

I'm using Excel 2016, on Windows 10, and I will create my sheet and align my columns and change my fonts and everything else to look nice, and then when I email it to another computer and open it, some of the text in certain columns will get cutoff or change to ###. I'm also using excel 2016 and windows 10 (though I'm not sure if its the most recent update excel for office 365.) I'm not sure the best way to fix this. My sheet is going to soon be going to several other versions, and possibly some older versions of excel, I don't want to have any issues.

 

[joeu2004]

(.... deleted by me; likely misdirection ....)

 

[Macropod]

That's fairly normal and merely reflects the way the different display drivers handle the display for whatever screen resolutions they're working with. Even on your own PC, just changing the zoom can produce these effects. Changing the zoom on your computer and widening any adversely affected columns so as to remove the truncations, before returning to your preferred zoom, should lead to your workbook displaying satisfactorily on a wide range of computers.

 

[Macropod]

Go to answers.microsoft.com and look for a similar discussion. Not in a position to look myself and provide a link. The upshot of it is that the pixel width of some (?) fonts changed. MSFT team member responded that Excel and window teams are working on it. Don't know if that's related to your problem, or if your problem might be simpler to explain

Not terribly helpful. Not knowing the answer really isn't a good reason to send the OP off to look elsewhere...

 

[andrewb90]

So would you recommend that format my columns and such at normal (or 100%) zoom? Or would it be better to set it at a lower number?

 

[Macropod]

What I'm suggesting is that you try them with Excel zoomed to a variety of settings (say 80-100% in 5% increments) and correct any columns that don't display correctly at all of those settings.

 

[andrewb90]

Ok awesome! I'll give that a try. Thanks!