Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / January 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David - 23 Jan 2006 23:30 GMT
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
Gary''s Student - 23 Jan 2006 23:41 GMT
Height is measured in points (72 points to the inch)
Width is measured in points (12 points to the inch)

Signature

Gary's Student

> 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
George Nicholson - 24 Jan 2006 00:56 GMT
> 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,
Signature

George Nicholson

Remove 'Junk' from return address.

> Height is measured in points (72 points to the inch)
> Width is measured in points (12 points to the inch)
[quoted text clipped - 6 lines]
>> please
>> help me
Bill Ridgeway - 24 Jan 2006 09:53 GMT
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

> Gary's Student
>
[quoted text clipped - 5 lines]
>> please
>> help me
Gord Dibben - 24 Jan 2006 05:25 GMT
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

Gord Dibben  MS Excel MVP
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.