Sizing a cell to an exact square

[MaryW]

I often like to use Excel as a kind of "graph paper" to create projects. Does anyone know what size the columns and rows need to be to create a 1 inch square?

 

[Paul B]

Mary, I think 12.71 for the columns and 72 for the rows will be close

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

I often like to use Excel as a kind of "graph paper" to create projects.

Does anyone know what size the columns and rows need to be to create a 1
inch square?

 

[maryW]

Thanks Paul... that looks pretty close!

 

[Gord Dibben]

Mary

In addition to Paul's pretty close suggestion, you can use VBA to set row and
column dimensions to millimeters using code from Ole Erlandson's website.

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

Note: 25.4 mm to the inch

Gord Dibben Excel MVP

 

[JE McGimpsey]

This will depend on the font you're using. The column width setting is
the number of standard font numeric characters that fit into a cell,
while the row height is in points (where there are 72 points to an inch).

If your standard font is smaller or larger than the default, the 12.71
value will make the cells narrower or wider, respectively.

For instance, I use Verdana 10 pt as the standard font on my machine and
the width setting for exactly 1" is 9.57. Using 12.71 makes my cells 30%
wider than their height.

The only way currently to set column widths and row heights to the same
units is to use VBA, as Gord suggested.

 

[MaryW]

Thanks to all for your help. Using VBA sounds much more precise. I will use that. Thanks again!

 

[Dana DeLouis]

Microsoft's Graph Paper Template (for Excel) does a good job of making
"squares" for Graph paper. Maybe you can get some ideas there. It's about
half way down the list.

http://office.microsoft.com/templat...ID=CT063455571033&CTT=4&Origin=CT062100801033

It likes to use a Font of "Century Gothic" with the following sizes:

Sub FindDimension()
'// C10 is first square on Template
With [C10]
Debug.Print .EntireRow.Height
Debug.Print .EntireColumn.Width
End With
End Sub

Returns...
15.75
15

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =

I often like to use Excel as a kind of "graph paper" to create projects.

Does anyone know what size the columns and rows need to be to create a 1
inch square?