square cells

[rockhammer]

How can I change the row heights and column widths such that the cells are
exactly square? It appears the numbers we enter in the row height and column
width popups are not in the same units.

Moreover, if there is a way to specify the dimensions of the cells such that
they will be a specified size on the printed page, say in easy to define
units like 1 inch by 1 inch, that would be really helpful.

Your help greatly appreciated.

 

[Sheeloo]

Row height is measured in points, 1/72 of an inch
Column widht is measured in pixels required for a character in the normal
used.

Set the column width you want... measure it in inches and divide by 72...
set row height equal to the number you get as a result.

If you are open (and familiar with) to macro solution then see
http://exceltip.com/st/Set_row_heig...imeters_using_VBA_in_Microsoft_Excel/489.html

See http://support.microsoft.com/kb/214123 if you want to understand how it
works.