Page Layout issues between 2010 and modern 365

[gravanoc]

I recently completed a very tedious, time-consuming project where I placed textboxes in Excel & aligned them so that they would print their text onto a pre-printed form (CMS-1500). Using a copy of that form and making copies of it to be printed onto, I eventually got it where it needed to be. Additionally, it used VBA to accommodate formatting issues with dates, phone numbers, etc. & to iterate through each row of data, transferring this data to the textboxes & printing once after every row was complete.

The problem is that I suspected there may be some differences in how the process would unfold on machines using older versions of Excel & potentially due to printer brand or other hardware considerations. I setup a unified page layout in a separate module to mirror the settings I used on my version of Excel, but the target is Excel 2010, so I don't know what the impacts to fidelity will be. Even a millimeter of difference could cause problems.

Settings:
• Custom margins (eliminated header & footer space, set left & right to 0, top & bottom to 0).
• 8.5 × 11" paper size
• Portrait
• Scaling 100% (it all fits on one page)
Everything else is mostly default settings.

If any additional info is needed, please let me know.

Picture:

 

[rlv01]

I use both versions and I doubt any difference will be due to different Excel versions. It is more likely that different printers will have a larger effect. But the only way you will know for sure is to test, and if your target platform is Excel 2010 then you need to test with that version.