Excel Table Cell Width vs Word Table Cell Width

[i16978]

I am transforming excel tables into the word tables and I was wondering if Excel cell width = 20 what would that be in the word table cell width

Thanks in advance

[RobDog888]

Excel uses characters, points, and pixels as units of measurement. Word uses Inches.

Points Pixels Inches 
18     24     0.25 
36     48     0.5 
72     96     1.0 
108    144    1.5 
144    192    2.0

[RobDog888]

In word you can use the InchesToPoints and PointsToInches functions to do any conversions.

xxx = InchesToPoints (0.25)
xxx = PointsToInches (20)

[i16978]

OK, but what I have is in Excel the cell width is 20 which is roughly an equivalent of combining with of two default cells. According to your previous post, it would mean that to represent this in Word i would have to set the cell width to .25 and to me that does not represent that wide column that I have in Excel. Or am I wrong?

[RobDog888]

8.43 is characters and it equates to 64 pixels per column in Excel for default. So a double width default width column will
be 16.86 characters or 128 pixels or 96 points or 1.25" ?

This is straight from the help file.

[i16978]

thanks, i guess i missed it. in any case i had to re-calculate the size of the cells based on the total print area of the page, keeping in mind the layouts and different paper sizes and such.

and i am happy to say that this is solved

i16978

[RobDog888]

Cool! Gladto help. I didnt realize that they used different measurement units between Office apps until this thread.