Making square cells in Excel
Q: Can anyone tell me the relationship between the numbers for Row Height and Column Width which will reliably allow me to make cells which are exact squares?
A: The relationship is in a factor of about 5.29:1 - this macro will allow you to set cells as square very quickly:
Sub Squarecells()
Selection.RowHeight = (Selection.ColumnWidth * 5.29)
End Sub
Note this works best when applied to a selection of identically-sized cells, like in a newly-opened worksheet.