T
TR Young
How do I set up Excel to display the rows and columns in inches?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
john the confused
In office 2003 you can't
An inch is about 96 pixels though.
John
An inch is about 96 pixels though.
John
T
TR Young
thank you, John. My apologies for not including version (it is 2003, btw).
That sure would be a nice feature for Microsoft to add...
That sure would be a nice feature for Microsoft to add...
G
Gord Dibben
You don't.
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
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