What measurement unit is used for the row height in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to change the row height to 6 ml, the row height says that it is
12.75, but if that's talking about mls then 19 lines should be about 245 ml
which is how high I want my piece of paper, but it's not AAARRRGGGHH please
help me
 
Height is measured in points (72 points to the inch)
Width is measured in points (12 points to the inch)
 
Width is measured in points (12 points to the inch)
Actually, I believe column width is expressed in "Characters". 13 characters
to an "inch" (96 pixels)
At least, that's what Excel help says...

....and the definition of "inch" is relative, since display resolution can
have an effect. 10 point type changes height when you change screen
resolutions, but it remains 10 point type.

there's probably a joke to be made about surveying virtual reality, but it's
been a long day... :-)

HTH,
 
David

In addition to the othewr replies...............

Assuming 96 pixels per inch you could approximate but at different resolutions
your approximation can be off.

If you want to use VBA to set height and width in mm(I assume you don't want
your height in ml which is a liquid measure)............

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben MS Excel MVP

I am trying to change the row height to 6 ml, the row height says that it is
12.75, but if that's talking about mls then 19 lines should be about 245 ml
which is how high I want my piece of paper, but it's not AAARRRGGGHH please
help me
Click to expand...

Gord Dibben MS Excel MVP
 
Gary''s Student wrote <<Width is measured in points (12 points to the
inch)>>

I don't think this is correct. The width of, for instance, the letters 'I',
'M', 'N and 'W' are very different. I believe there is a convention placing
letters in four groups according to width. In any case width is
proportional to the height so will vary accordingly.

All that said, the height and width of characters on the screen may be
varied according to the zoom factor but the zoom factor doesn't in itself
change the size of characters on a printed page. The standard printers'
measurement is 'points' is an actual and physical measurement. However, I
wouldn't trust that any stated font size isn't changed by either word
processing or printer driver software. In the days of manual print setting
it was necessary to know exactly what you're getting but nowadays print size
can be best regarded as a relative guide.

Regards.

Bill Ridgeway
 
Back
Top