Share via

Excel 2010 vs 2016 Page Margin Differences

Anonymous
2019-09-05T23:46:27+00:00

Hello,

I have created some documents for my company using Excel 2010 (Windows 7), as installed on my laptop. Some of my colleagues have newer laptops running Windows 10 and Office 2016. The documents have been designed to fit nicely on a defined number of pages, adjusting margins precisely for best display on Excel 2010. The issue I have is that my colleagues running Excel 2016 have had the page layout come up differently, and what shows as 4 pages on 2010 might be 8 pages on 2016 due to one row/column going over the page border, and having a flow-on effect down the document.

The odd thing is this has not been consistent between different computers running 2016 and Win 10 - some adjustments were made to the documents and this worked on some of the 2016 versions, but others still had display issues. Presumably, this is a display setting on each computer? We already found the scaling factor in Windows settings which seemed to help (Display > Scale, set to 100% (from "125% (recommended)"). Does anyone have further suggestions on why different versions of Excel display identical documents differently?

Thanks!

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2019-09-06T01:40:41+00:00

    Thanks Naval.

    Those tips seem to be more about compatibility between .xls and .xlsx versions, though.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-09-06T01:39:53+00:00

    Thanks for the reply. No, resolution is identical between mine and one of the problem computers. Both using laptop + extended display to monitor, and both laptops and monitors have the same resolutions, respectively.

    Worth a look, though, so thanks!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-09-06T00:40:11+00:00

    My name is Naval and I am an Independent Advisor. I would like to help you.

    Try to follow the instructions provided on the link in order to fix the issue:

    https://support.office.com/en-gb/article/use-ex...

    I tried my best to find the solution for your issue. If this doesn't help you kindly let me know, we will find other solutions.

    Thanks and regards

    Naval

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-09-06T00:22:51+00:00

    To:  Matticus

    Re:  printing on other computers

    The Screen Resolution (SR) affects the size of the display.

    The smaller the SR the larger the screen display.

    My older model computer monitor has a SR of 2560 x 1440 (default),

    but can be set as small as 800 x 600.

    '---

    Free "Custom_Functions" Excel add-in (19 new Excel functions)

    Download from Media Fire: 

    http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

    Was this answer helpful?

    0 comments