Row hight in millimetres

S

sk

Hello everybody,

I need to print tables of the fixed and exactly determined row hight and
column widthdraw because of the predprinted paper sheets.

I can determine page properties in millimetres, but I can't determine
row hight and column width in millimetres or can I?

Thank you for your answer,

SK
 
K

Ken Wright

Row heights are measured in points with 72 points to the inch, so you can do the
conversion from there. Column Width's are harder as the measurement equates to
the number of characters that can be displayed in a fixed width font. Pretty
much trial and error with that I think.
 
G

Gord Dibben

SK

Row heights are calculated in points and cannot be changed.

There are 72 points to the inch. 25.4mm to the inch. You do the math.

Note: Excel will round off row heights to nearest .25 points so exactitude is
a crap-shoot.

Column Width is set in number of numeric characters in
the default font (e.g., a width of 10 will allow 10 numeric
characters) and size, and so depends on which font you're using and
the default font size.


Gord Dibben XL2002
 
B

Bernard V Liengme

A possible solution: Copy and Paste to a Word doc and format the Word doc
table to taste
Bernard
 
Top