columns and rows in inches

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TR Young - 01 Feb 2007 18:52 GMT

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

Reply to this Message

john the confused - 01 Feb 2007 19:06 GMT

In office 2003 you can't

An inch is about 96 pixels though.

John

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

Reply to this Message

TR Young - 01 Feb 2007 19:18 GMT

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

> In office 2003 you can't
>
[quoted text clipped - 3 lines]
>
>> How do I set up Excel to display the rows and columns in inches?

Reply to this Message

Gord Dibben - 01 Feb 2007 19:24 GMT

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

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

Reply to this Message