Make Cell Perfectly Square

G

Guest

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
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!!!
 
G

Guest

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?
 
S

Steve McBride

Wouldn't the 'squareness' depend on the monitor resolution being used? I
created a square using the drawing toolbar and then changed my monitor
resolution (normally at 1280 x 1024) to 1280 x 768.

The square no longer 'looked' square. I believe the ratios (height to
width) would change depending on the resolution.

Just something to consider if you're developing a worksheet for use other
than on your own machine.

HTH,
Steve


J-Man said:
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!!!
 
G

Guest

Just an FYI (this is what I was looking for, actually):

If you set Rows.RowHeight = Columns.Width, you will have perfect squares.

I was attempting to use Columns.ColumnWidth, which involves the font size you are using...but, Columns.Width returns "points" which is what Rows.RowHeight is!!

Hope this helps others. Thanks all!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top