B
Bill
The row height is indeed in points but then what measure
is the font height????? -- read on...
Try this. Put a single 48 point Capital letter in a cell
and autofit the row height. Check the measurement (Excel
should report back that it's 90(120 pixels)). Now 1 pica
point = 1/72 inch, so 90 points x 1/72 = 1.25 inches. Use
MS Draw to create a circle 1.25 inches in diameter -- this
circle *will* just fit in the row and therefore, the row
height is in pica points.
But, our 48 point letter should be 48 x 1/72 = 0.67 inches
tall. It is not however, it is approx. 0.72 inches high on
the screen (by the circle method used above). If I print
my example at 100% of original size, the 48 point capital
letter hardcopy actually does measure 0.72 inches just as
it did on the screen.
What gives? What am I doing wrong????????
is the font height????? -- read on...
Try this. Put a single 48 point Capital letter in a cell
and autofit the row height. Check the measurement (Excel
should report back that it's 90(120 pixels)). Now 1 pica
point = 1/72 inch, so 90 points x 1/72 = 1.25 inches. Use
MS Draw to create a circle 1.25 inches in diameter -- this
circle *will* just fit in the row and therefore, the row
height is in pica points.
But, our 48 point letter should be 48 x 1/72 = 0.67 inches
tall. It is not however, it is approx. 0.72 inches high on
the screen (by the circle method used above). If I print
my example at 100% of original size, the 48 point capital
letter hardcopy actually does measure 0.72 inches just as
it did on the screen.
What gives? What am I doing wrong????????