How to make a cell a perfect square?

[James0816]

I know, must be an odd question but I'm making a chart and would like to have the length and width the same size. How exactly does one go about doing that?

Thx

 

[texasalynn]

take a look at this
http://excel-tips.blogspot.com/2004/12/square-cells-in-excel.html#

 

[jim may]

A bit CRUDE, but here's a way...

Sub Tester()  ' YOU MUST SELECT THE DESIRED RANGE BEFORE RUNNING THIS MACRO
Mult = 5.42   ' the multiple to equal rowheight to column width
'Selection.RowHeight = (Cells.ColumnWidth + 0) * Mult   ' to do complete sheet
Selection.RowHeight = (Selection.ColumnWidth + 0) * Mult  'to do only selected range
End Sub