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

G

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.
 
S

Sol Moriarty

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

Regards,
SM
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Seeking Help with Cell/Range Height and Width Properties 4
Measuring Column Width 4
Column width units 1
Column width in pixels how? 2
Auto Column width for new sheets in workbook? 2
Excel 2003 Row and Column Dimensions 4
What does the 8.43 and 12.75 represent in height and width of cell 2
Simplify code copy based on condition 2

Top