How to fit each cell into a perfect square?


G

Guest

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
 
Ad

Advertisements

G

Guest

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

Guest

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
 
Ad

Advertisements

M

MartinW

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 Format>Column>Column Width and set it to 12.57
then select your rows
go to Format>Row>Row 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
 

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