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)
--
Gary's Studentquot;Davidquot; wrote:
gt; I am trying to change the row height to 6 ml, the row height says that it is
gt; 12.75, but if that's talking about mls then 19 lines should be about 245 ml
gt; which is how high I want my piece of paper, but it's not AAARRRGGGHH please
gt; help me
gt; Width is measured in points (12 points to the inch)
Actually, I believe column width is expressed in quot;Charactersquot;. 13 characters
to an quot;inchquot; (96 pixels)
At least, that's what Excel help says...
....and the definition of quot;inchquot; 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,
--
George Nicholson
Remove 'Junk' from return address.quot;Gary''s Studentquot; gt; wrote in message
...
gt; Height is measured in points (72 points to the inch)
gt; Width is measured in points (12 points to the inch)
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Davidquot; wrote:
gt;
gt;gt; I am trying to change the row height to 6 ml, the row height says that it
gt;gt; is
gt;gt; 12.75, but if that's talking about mls then 19 lines should be about 245
gt;gt; ml
gt;gt; which is how high I want my piece of paper, but it's not AAARRRGGGHH
gt;gt; please
gt;gt; help me
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.
www.erlandsendata.no/english/...vbawssetrowcolGord Dibben MS Excel MVP
On Mon, 23 Jan 2006 15:30:03 -0800, quot;Davidquot; gt;
wrote:
gt;I am trying to change the row height to 6 ml, the row height says that it is
gt;12.75, but if that's talking about mls then 19 lines should be about 245 ml
gt;which is how high I want my piece of paper, but it's not AAARRRGGGHH please
gt;help me
Gord Dibben MS Excel MVP
Gary''s Student wrote lt;lt;Width is measured in points (12 points to the
inch)gt;gt;
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
gt; Gary's Student
gt;
gt;
gt; quot;Davidquot; wrote:
gt;
gt;gt; I am trying to change the row height to 6 ml, the row height says that it
gt;gt; is
gt;gt; 12.75, but if that's talking about mls then 19 lines should be about 245
gt;gt; ml
gt;gt; which is how high I want my piece of paper, but it's not AAARRRGGGHH
gt;gt; please
gt;gt; help me
- May 16 Wed 2007 20:37
What measurement unit is used for the row height in Excel?
close
全站熱搜
留言列表
發表留言