How can I specify the height of a row?

[Ikke]

Hi everyone,

How can I specify the height of a row in cm?

In Word, when I draw a table, I can specify the height in cm but in Excel I
have not found an option to do so.

Also, when I print the Word document, why are the printed tables not
exactly the size I specify?

Word/Excel 2000...

Thanks in advance,

Ikke

 

[Gord Dibben]

In Excel row height is measured in points.

72 points per inch.

24.4mm per inch.

I get .352778 mm per point.

If you want to use VBA to set height in mm

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben MS Excel MVP

 

[Ikke]

In Excel row height is measured in points.

72 points per inch.

24.4mm per inch.

I get .352778 mm per point.

If you want to use VBA to set height in mm

Ole Erlandson has code for setting row and column dimensions.

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

Thanks for your quick reply!

Ikke

 

[Gord Dibben]

Thanks for the feedback and good luck.


Gord

Thanks for your quick reply!

Ikke

Gord Dibben MS Excel MVP

 

[Bernard Liengme]

1 inch =25.4 mm (NOT 24.4)
This is the DEFINITION of an inch and was adopted in WWII to make US and UK
parts interchangeable
So the US is really metric!
best wishes

 

[Ikke]

1 inch =25.4 mm (NOT 24.4)
This is the DEFINITION of an inch and was adopted in WWII to make US
and UK parts interchangeable
So the US is really metric!
best wishes

Thank you for the correction!

Ikke

 

[James Silverton]

Hello, Bernard!
You wrote on Sun, 15 Oct 2006 10:00:25 -0300:

BL> 1 inch =25.4 mm (NOT 24.4)
BL> This is the DEFINITION of an inch and was adopted in WWII
BL> to make US and UK parts interchangeable
BL> So the US is really metric!
BL> best wishes


Offhand, I don't recall when or why the definition of the inch
was changed but both the British and the American definitions
were very close indeed to 25.4 mm to the inch, close enough that
wrenches were interchangeable. Conveniently for obtaining
agreement on a *definition*, one inch was slightly more than
25.4mm and the other less.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

 

[Gord Dibben]

How the hell did 24.4 get into my post?<g>

Thanks Bernard for the correction.


Gord

1 inch =25.4 mm (NOT 24.4)
This is the DEFINITION of an inch and was adopted in WWII to make US and UK
parts interchangeable
So the US is really metric!
best wishes

Gord Dibben MS Excel MVP