Cell width and height measurements

R

Randy

Does anyone know why row height and colume width are
measured in different units of measure, and what the units
are that are used.
 
G

Gord Dibben

Randy

Row heights are measured in points. There are 72 points to an inch.

The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.

No relationship between the two.

If you want to use VBA to set height and width in mm....

Ole Erlandson has code for setting row and column dimensions.

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

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Height/Width measurements 3
Satisfying two conditions? 8
column width, row height units 1
Units of measure 4
How to size rows and columns in pixels rather than units 3
pricing problems 9
Column Width and Row Height 4
expand row to fit 1

Top