columns and rows in inches

How do I set up Excel to display the rows and columns in inches?

In office 2003 you can't

An inch is about 96 pixels though.

John

"TR Young" wrote:

How do I set up Excel to display the rows and columns in inches?

thank you, John. My apologies for not including version (it is 2003, btw).
That sure would be a nice feature for Microsoft to add...

"john the confused" wrote in
message ...
In office 2003 you can't

An inch is about 96 pixels though.

John

"TR Young" wrote:

How do I set up Excel to display the rows and columns in inches?

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/...vbawssetrowcol


Gord Dibben Excel MVP

On Thu, 1 Feb 2007 13:52:19 -0500, "TR Young"
wrote:

How do I set up Excel to display the rows and columns in inches?