M
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?
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.
P
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 **
inch square?
--
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 **
Does anyone know what size the columns and rows need to be to create a 1MaryW said:I often like to use Excel as a kind of "graph paper" to create projects.
inch square?
M
maryW
Thanks Paul... that looks pretty close!
G
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
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
J
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.
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.
M
MaryW
Thanks to all for your help. Using VBA sounds much more precise. I will use that. Thanks again!
D
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
= = = = = = = = = = = = = = = = =
inch square?
"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
= = = = = = = = = = = = = = = = =
Does anyone know what size the columns and rows need to be to create a 1MaryW said:I often like to use Excel as a kind of "graph paper" to create projects.
inch square?