Row hight in millimetres

  • Thread starter Thread starter sk
  • Start date Start date
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
 
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.
 
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
 
A possible solution: Copy and Paste to a Word doc and format the Word doc
table to taste
Bernard
 
Back
Top