Cell size

[Emece]

I have a worksheet where I need the cells to be a square. Is there a way to
do this? Or should I specify same width and heigth so as to obtain a square?

Thanks in advance

Regards,
Emece.-

 

[JLatham]

Well, due to the way Excel measures things, setting height and width to the
same numbers won't give you a square.

And if you're looking for the magic "make this cell square" button, there
ain't no sech animule!

Just adjust the column width/row height by eyeball until it looks square to
you. Or put a square shape on the sheet and adjust column width/row height
until the cell's borders overlay the shapes sides.

Remember that all of the cells in that column are going to take on that
width, and all the cells in the intersecting row will take on that height.
But you said you "need the cells to be square" so I assume that means all the
cells, so this shouldn't be a problem.

 

[Gord Dibben]

Row heights are measured in points or pixels. There are 72 points to an
inch and "maybe" 96 pixels to the inch.

The number that appears in the Standard column width box is the average
number of digits 0-9 of the standard font that fit in a cell.

When dragging the column width you will see two numbers.........one is width
as above, the other is pixels.

For an interesting and enlightening discussion on this subject see

http://snipurl.com/dzz8

If you want to use VBA to set height and width in mm.

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP