G Guest Jul 17, 2007 #1 the columns are measured in adifferent format to the rows so rows length mite be mm while columns length are inches
the columns are measured in adifferent format to the rows so rows length mite be mm while columns length are inches
G Guest Jul 17, 2007 #2 There is no fixed unit for either the rows or columns in Excel. These will vary based on the font and font size for the sheet. For more info see: http://support.microsoft.com/default.aspx/kb/214123 HTH, TK
There is no fixed unit for either the rows or columns in Excel. These will vary based on the font and font size for the sheet. For more info see: http://support.microsoft.com/default.aspx/kb/214123 HTH, TK
G Gord Dibben Jul 17, 2007 #3 Row heights are measured in points or pixels. There are 72 points to an inch and "maybe" 96 pixels to the 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. For an interesting and enlightening discussion on this subject see http://snipurl.com/dzz8 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 On Tue, 17 Jul 2007 09:26:02 -0700, very confused individual <very confused
Row heights are measured in points or pixels. There are 72 points to an inch and "maybe" 96 pixels to the 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. For an interesting and enlightening discussion on this subject see http://snipurl.com/dzz8 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 On Tue, 17 Jul 2007 09:26:02 -0700, very confused individual <very confused
