Make Cell Perfectly Square

J

J-Man

How do you make a Cell perfectly square? As you probably know, the Row Height and Column Widths are measured in different units...or, maybe the same units but 1 unit is not the same for both. Is there some sort of ratio that can be used to make a cell perfectly square? I read somewhere that it is 16:2 (height to width), but that doesn't look right to me...unless I'm doing the calculation wrong. If this is indeed the right ratio, could someone provide me with an example of how to calculate this? If this isn't the correct ratio...or there's some other way to make the cell perfectly square...please let me know. Thanks in advance!!!
 
A

Andy B

J-Man

Couldn't you just use the drawing toolbar to create a square and use that
for reference?

Andy.

J-Man said:
How do you make a Cell perfectly square? As you probably know, the Row
Click to expand...
Height and Column Widths are measured in different units...or, maybe the
same units but 1 unit is not the same for both. Is there some sort of ratio
that can be used to make a cell perfectly square? I read somewhere that it
is 16:2 (height to width), but that doesn't look right to me...unless I'm
doing the calculation wrong. If this is indeed the right ratio, could
someone provide me with an example of how to calculate this? If this isn't
the correct ratio...or there's some other way to make the cell perfectly
square...please let me know. Thanks in advance!!!
 
J

J-Man

I can't use the drawing tool as a "template" for a square because the cells are dimensioned via a macro...so, I don't know exactly what the sizes of the cells will be. However, I guess I could use the drawing tool to determine the ratio!!! Thanks, I'll give that a shot

Does anyone know this ratio right off hand?
 
Top