Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell size
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.- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell size
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. "Emece" wrote: 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.- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell size
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/...vbawssetrowcol Gord Dibben Excel MVP On Tue, 24 Nov 2009 11:02:07 -0800, Emece wrote: 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.- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet1 to worksheet2, keep cell format eg cell size | Excel Discussion (Misc queries) | |||
cell size | Excel Worksheet Functions | |||
How can I change the size of a cell and hide what is in the cell? | Excel Worksheet Functions | |||
cell size and font size | Excel Discussion (Misc queries) | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) |