format row and column widths for the same size

[diverdave]

I want to use excel to sketch and want to know what setting to use for column width and row height so they measure the same.

 

[bjurney]

Do you mean under Format>Row>Height?

You can do the same thing for column and adjust as needed.

 

[diverdave]

when I set both to the same number, 15 for example, the cell ends up with the column width about twice the width as the cell height.

I need to make a blueprint and need to be able to have each cell an inch by an inch.

I know I can make an adjustment to one of them and then print out the page and measure and then adjust and reprint over and over again untio they match but I am hoping someone knows what the settings are so I can save some time AND paper.

 

[bjurney]

If you click on the edge between the rows and columns, it will tell you how many pixels it is. You can match the pixels to whatever you would like by clicking and dragging.

 

[diverdave]

I wish it was that simple - I wouldn't be on the forum if it was. Try that out - you will see that the unit of measurement is not the same for height as it is for width.

 

[bjurney]

This is from the Microsoft Help and may explain why they appear to have diffrent numbers. Its just that the width is displayed in characters while the height is displayed in points. Hope this helps!


<TABLE class=OTbl cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="PADDING-RIGHT: 0px; PADDING-LEFT: 12px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px"><TD class=cdOTATtl width="100%">Measurement units and rulers in Excel</TD><TD style="PADDING-RIGHT: 0px; PADDING-LEFT: 12px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px"></TD><TR><TD class=ACB style="PADDING-RIGHT: 12px; PADDING-LEFT: 12px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px" width="100%" colSpan=3>Unlike Microsoft Word, Excel does not provide a horizontal or vertical ruler, and there is no quick way to measure the width or height of a worksheet in inches. Excel uses characters, points, and pixels as units of measurement.

• The width of cells is displayed in characters and pixels rather than in inches. When you drag the boundary of a column heading to adjust the width of a column on the worksheet, a ScreenTip displays the width in characters and shows pixels in parentheses.
• The height of cells is displayed in points and pixels rather than in inches. When you drag the boundary of a row heading to adjust the height of a row on the worksheet, a ScreenTip displays the height in points and shows pixels in parentheses.

An approximate conversion of points and pixels to inches is shown in the following table.
<TABLE class=collapse><TBODY><TR class=trbgeven><TH>Points</TH><TH>Pixels</TH><TH>Inches</TH></TR><TR class=trbgodd><TD>18</TD><TD>24</TD><TD>.25</TD></TR><TR class=trbgeven><TD>36</TD><TD>48</TD><TD>.5</TD></TR><TR class=trbgodd><TD>72</TD><TD>96</TD><TD>1</TD></TR><TR class=trbgeven><TD>108</TD><TD>144</TD><TD>1.5</TD></TR><TR class=trbgodd><TD>144</TD><TD>192</TD><TD>2</TD></TR></TBODY></TABLE>
</TD></TR></TBODY></TABLE>

 

[diverdave]

that gets me closer - still off by 3/16 of an inch so guess I have to go the long way around to get it exact but I DO appreciate you're researching this for me.
Dave

 

[Nalani]

This is what I use when making Graph Paper


<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 13.2pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=18 width=64>Colum</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=64>Row</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=64>Size</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 13.2pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=18>116</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>128</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>1 inch</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 13.2pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=18>59</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>64</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>1/2 inch</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 13.2pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=18>29</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>1/4 inch</TD></TR></TBODY></TABLE>

All Pixel values

Discloseure: This is on My Computer and My Printer - not tried on any other

 

[diverdave]

Thanks Nalani. For Some funny reason those settings got me 1 1/4 X 1 1/4 inches. By reducing the numbers the 20% I was over I get exactly 1" by 1". My numbers are: Column = 93 Row = 103.

Mystery to my why they are different but at least I was able to figure it out with your help.

 

[Nalani]

Glad you worked it out.

Like I said, only tested on My system. What I also do is save a seperate workbook to My Documents with the Pixels needed so I don't have to "figure it out" again.

Excel Workbook
	A	B	C	D	E	F
1
2
3
4
5
6
7				Colum	Row	Size
8				116	128	1 inch
9				59	64	1/2 inch
10				29	32	1/4 inch
11
Sheet1

Although it doesn't look right in Excel, it does print correctly.

And thanks for the feedback.