How to fit each cell into a perfect square?
 

Does anyone have any suggestions on how to fit each cell into perfect square?
I would like to make each cell into a perfect square, but the lenght and
height for each cell used different unit. Does anyone know the proportion for
each cell between length and height? so I can multiple the length with a
ratio to get the other length in order to get a perfect square.
Thanks in advance for any suggestions
Eric

How to fit each cell into a perfect square?
 

You could try this:

In between column A and B (column header) you could use pixels as the size
measurement instead of the height or width.

Say 100 pixels each, will give a perfect square.

HTH.

"Eric" wrote:

Does anyone have any suggestions on how to fit each cell into perfect square?
I would like to make each cell into a perfect square, but the lenght and
height for each cell used different unit. Does anyone know the proportion for
each cell between length and height? so I can multiple the length with a
ratio to get the other length in order to get a perfect square.
Thanks in advance for any suggestions
Eric

How to fit each cell into a perfect square?
 

Thank you for your reply
Could you please give any suggestions on how to do it and use what kind of
tools?
Thank you for any suggestions
Eric

" wrote:

You could try this:

In between column A and B (column header) you could use pixels as the size
measurement instead of the height or width.

Say 100 pixels each, will give a perfect square.

HTH.

"Eric" wrote:

Does anyone have any suggestions on how to fit each cell into perfect square?
I would like to make each cell into a perfect square, but the lenght and
height for each cell used different unit. Does anyone know the proportion for
each cell between length and height? so I can multiple the length with a
ratio to get the other length in order to get a perfect square.
Thanks in advance for any suggestions
Eric

How to fit each cell into a perfect square?
 

It's very hard to get an exact square in Excel.
100 pixels x 100 pixels won't do it as pixels aren't square,
in fact pixels aren't even an exact size.

If you select the columns you want to be square and
go to FormatColumnColumn Width and set it to 12.57
then select your rows
go to FormatRowRow Height and set it to 75

You will be very close to square and the
pixel size will be 93 pixels wide by 100 pixels high.

HTH
Martin

" wrote in
message ...
You could try this:

In between column A and B (column header) you could use pixels as the size
measurement instead of the height or width.

Say 100 pixels each, will give a perfect square.

HTH.

"Eric" wrote:

Does anyone have any suggestions on how to fit each cell into perfect
square?
I would like to make each cell into a perfect square, but the lenght and
height for each cell used different unit. Does anyone know the proportion
for
each cell between length and height? so I can multiple the length with a
ratio to get the other length in order to get a perfect square.
Thanks in advance for any suggestions
Eric