Can I make column width and row height equal (a grid) in Excel?

[Guest]

I'd like to use a worksheet like a piece of graph paper. Is there any simple
way to set the column width and the row height to form perfect squares in a
worksheet?

 

[Gord Dibben]

Buzz

MS Office Excel Template for graph paper........

http://office.microsoft.com/en-us/templates/TC010183751033.aspx

If you want to "roll your own".......

Assuming 96 pixels per inch you could approximate but at different resolutions
your approximation can be off.

If you want to use VBA to set height and width in mm which you then convert to
inches at 25.4 mm per inch..........

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP