If column width is 8.43, what should the row height be to make a square?

[Sol Moriarty]

If column width is 8.43, what should the row height be to make a square?

 

[Gary Keramidas]

i believe if you drag the row divider down, you will see the number of
pixels. at 8.43, the column is 64 pixels wide. if you drag the row down to
64 pixels, you will see a row height of 48.

 

[Sol Moriarty]

Gary,
thank you.
You are absolutely correct.
I never knew that before. it's a most useful thing know.

Regards,
SM

 

[bighead]

This is the question in other forum I answered.
Question:
I know that the standard columns width is 8.43 CHARACTERS (=64 pixel)
but I don't know what is the relation between characters and pixel.
Answer:
The relation is not solid,when the standard font and fontsize in EXCE
option is changed,the relation will be changed.
The relation can be gotten with VBA


Code
-------------------
relation = Columns(1).Width / Columns(1).ColumnWidth
MsgBox relation
-------------------



Because characters are not same width,according to EXCEL HELP said,it'
the average width of "0123456789" ten characters