MrExcel Publishing
Your One Stop for Excel Tips & Solutions

creating square cell


Posted by JF lay on December 27, 2001 11:40 AM

Hello
how do I create cells with same height and width...like graph paper.
thanks


Posted by Scott on December 27, 2001 11:51 AM

This Macro sets widths and Heights:

Sub Square_Cells()

Cells.Select
Selection.RowHeight = 13
Selection.ColumnWidth = 2
Range("A1").Select
End Sub

Not sure if they're exactly square, but they appear to be.