Column width

[HomeworkHelpNeeded!]

I'm trying to make the cells on a spreadsheet be 4.5" long by 2.5" tall. I
can't seem to figure out how to make it be a measurement vs
pixels/characters. Can anyone help me with this?

 

[Gord Dibben]

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 which you can convert to
inches.

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP

 

[HomeworkHelpNeeded!]

Thank you! That helped!

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 which you can convert to
inches.

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP

 

[AS]

Based on the discussion in that link, do you know the original standard font
and point size that was used to create a measurable sheet? My logic says
that if I change my "style" to that standard font (not necessarily the actual
font used in the cells), I can then get the exact measurements to line up a
sheet so that the margins are not variable. The problem I run into is that my
headers don't snap to the top and left margins because my furthest right
column drops off the printable area before it reaches the last few pixels
available for a letter-sized sheet.

 

[Gord Dibben]

From help on default column width....................

The number that appears in the Standard column width box is the average
number of digits 0-9 of the standard font (standard font: The default text
font for worksheets. The standard font determines the default font for the
Normal cell style.) that fit in a cell.

The "standard font" is whatever you have chosen under Tools>Options>General

I think you would have to play around with various fonts until(maybe) you
get what you need.


Gord