Excel Format Issue
I have customers using Office 365 that are experiencing issues with the formatting of Excel. One user creates the spreadsheets for distribution, some employees can view and print them as they were created but some must edit the document or it displays and prints with the top of the next page on the current one. All of their settings are the same, views, margins, etc. We have even looked at printing to the printer of the creator but the same issue is there. What setting(s) are we missing that the users might have set differently?
Gustav Brock
It could be, that most users print to A4 paper format, while some use the Letter paper format.
ASKER
Hi Gustav! They are all printing Letter format, I checked. It also looks wrong when they display it, the next page creeps into the bottom of the current page.
Then - if they use the same type of printer and identical printer drivers - it could the margin settings.
ASKER
They are all set to minimal margins as well. They checked it before calling me and then I rechecked it.
That is weird.
ASKER
Gustav, this is exactly what I think too! I was hoping there was some weird setting somewhere that I'm missing.
I'm out of ideas. I guess all have set "scale to match paper size" to either on or off.
ASKER
Yes, it's off for everyone. When the described it my first thought was that they have different versions of Office, but they're all using 365. Something has to be different, it's just a matter of finding it!
Have you checked the build numbers of their Office installs? Some may be behind in updating something. Indeed today which is update-day of the month.
ASKER
I didn't! I'll check that and let you know what I find!
Have you gone into the "View Tab" and looked at either the "Page Break View" or the "Page Layout View"? In "Page Break View" you can adjust the page breaks by moving or adding breaks. Also, in "Page Layout View" you can adjust where the data of the spreadsheet is displayed. I've had issues with before and those seemed to help me.
ASKER
We're going to try adding page breaks and see what happens. Thank you!
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.