ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting From Computer to Computer (https://www.excelbanter.com/excel-discussion-misc-queries/185501-formatting-computer-computer.html)

bighurt87

Formatting From Computer to Computer
 
I created a spreadsheet on my laptop to fill-in the blanks of a form. When I
transfered the spreadsheet to a different laptop, the formatting changed
slightly. The biggest difference was things like check boxes grew in size,
which have caused me problems. I am using the exact same version of XP and
MS Office on each computer. Anyone know why these things changed and if they
can be changed back?

JE McGimpsey

Formatting From Computer to Computer
 
I doubt anything changed. In addition to explicit formatting, the
display will depend on the fonts used (i.e., different versions of the
same font may have different metrics, or a font used that doesn't exist
on the other machine will be substituted with a "close" font) and the
print driver used.

In addition, I've seen anomalies with different zoom settings where
objects and cell alignments shift.

You can't really control either. Making sure you're using standard, MS
supplied fonts in standard font sizes helps.

In article ,
bighurt87 wrote:

I created a spreadsheet on my laptop to fill-in the blanks of a form. When I
transfered the spreadsheet to a different laptop, the formatting changed
slightly. The biggest difference was things like check boxes grew in size,
which have caused me problems. I am using the exact same version of XP and
MS Office on each computer. Anyone know why these things changed and if they
can be changed back?


bighurt87

Formatting From Computer to Computer
 
I assure you that things changed. The size of the cells changed slightly.
Primarily though, it was the size of the text in the boxes from the "forms
toolbar" and the buttons from the "forms toolbar". They grew as much as 50%.
The main font didn't change at all.


All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com