What font, column width and column height will give me a square cell, approx. .5" x .5"?
C cj \(removethis\) Aug 23, 2004 #1 What font, column width and column height will give me a square cell, approx. .5" x .5"?
G Gord Dibben Aug 24, 2004 #2 cj 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....12.7mm for .5 inch Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP
cj 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....12.7mm for .5 inch Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP
G Guest Aug 24, 2004 #3 -----Original Message----- What font, column width and column height will give me a square cell, approx. .5" x .5"? . Click to expand...
-----Original Message----- What font, column width and column height will give me a square cell, approx. .5" x .5"? . Click to expand...
