Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Row and Column Dimensions
If I open a new work book the row height is 12.75 and column width is 8.43
but visually the width is wider than the height! If I select and area say A10:I10 and then go to the format menu and enter a Row height of 50 and Column width of 50......i.e. equal dimensions to produce a block of squares .......the aspect ratio is still rectangular. I know this has to be something silly Please advise. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Row and Column Dimensions
hi
see this site. http://office.microsoft.com/en-us/ex...375451033.aspx row heght is measured in points. 1 point = about 1/72 inch. column width is measured in characters. that's the difference. Regards FSt1 "Dermot" wrote: If I open a new work book the row height is 12.75 and column width is 8.43 but visually the width is wider than the height! If I select and area say A10:I10 and then go to the format menu and enter a Row height of 50 and Column width of 50......i.e. equal dimensions to produce a block of squares .......the aspect ratio is still rectangular. I know this has to be something silly Please advise. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Row and Column Dimensions
Hi
Thanks for the reply and link. I hadn't noticed this before as I usually just drag to get grid dimensions I require....but tonight I entered specific data via the format menu which brought it to my attension. I suppose it makes sense as the any number length in a cell will be "X" characters wide and the space above or below them expressed in points. Thanks again for the help "FSt1" wrote: hi see this site. http://office.microsoft.com/en-us/ex...375451033.aspx row heght is measured in points. 1 point = about 1/72 inch. column width is measured in characters. that's the difference. Regards FSt1 "Dermot" wrote: If I open a new work book the row height is 12.75 and column width is 8.43 but visually the width is wider than the height! If I select and area say A10:I10 and then go to the format menu and enter a Row height of 50 and Column width of 50......i.e. equal dimensions to produce a block of squares .......the aspect ratio is still rectangular. I know this has to be something silly Please advise. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Row and Column Dimensions
Hi,
If you put your mouse between the column letters and hold it down you will see the width in both characters and pixils, same for row height. If you set the row hight and width by pixils then the cell will be much closer to a square. Note screens have different aspect ratios which complicate the problem. Another complication is the number of characters for column width, that is affected by the font type. -- Thanks, Shane Devenshire "Dermot" wrote: Hi Thanks for the reply and link. I hadn't noticed this before as I usually just drag to get grid dimensions I require....but tonight I entered specific data via the format menu which brought it to my attension. I suppose it makes sense as the any number length in a cell will be "X" characters wide and the space above or below them expressed in points. Thanks again for the help "FSt1" wrote: hi see this site. http://office.microsoft.com/en-us/ex...375451033.aspx row heght is measured in points. 1 point = about 1/72 inch. column width is measured in characters. that's the difference. Regards FSt1 "Dermot" wrote: If I open a new work book the row height is 12.75 and column width is 8.43 but visually the width is wider than the height! If I select and area say A10:I10 and then go to the format menu and enter a Row height of 50 and Column width of 50......i.e. equal dimensions to produce a block of squares .......the aspect ratio is still rectangular. I know this has to be something silly Please advise. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Row and Column Dimensions
Hi Shane
Thanks for the reply and explanation. I see what you mean regarding the (Height / Pixels) data being displayed by placing the mouse between headers......oddly though.....the column data is not the same as the row data..... Column Width: 50 (355 Pixels) ROW Height: 49.50 ( 66 Pixels) A square would be: 50 (355 Pixels) x 50 (355 Pixels). So I am still a little confused. 50 x 49.50 = nearly square.......but the cell shape is clearly rectangular. "ShaneDevenshire" wrote: Hi, If you put your mouse between the column letters and hold it down you will see the width in both characters and pixils, same for row height. If you set the row hight and width by pixils then the cell will be much closer to a square. Note screens have different aspect ratios which complicate the problem. Another complication is the number of characters for column width, that is affected by the font type. -- Thanks, Shane Devenshire "Dermot" wrote: Hi Thanks for the reply and link. I hadn't noticed this before as I usually just drag to get grid dimensions I require....but tonight I entered specific data via the format menu which brought it to my attension. I suppose it makes sense as the any number length in a cell will be "X" characters wide and the space above or below them expressed in points. Thanks again for the help "FSt1" wrote: hi see this site. http://office.microsoft.com/en-us/ex...375451033.aspx row heght is measured in points. 1 point = about 1/72 inch. column width is measured in characters. that's the difference. Regards FSt1 "Dermot" wrote: If I open a new work book the row height is 12.75 and column width is 8.43 but visually the width is wider than the height! If I select and area say A10:I10 and then go to the format menu and enter a Row height of 50 and Column width of 50......i.e. equal dimensions to produce a block of squares .......the aspect ratio is still rectangular. I know this has to be something silly Please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Points Dimensions on a 3D Clustered Column Chart | Charts and Charting in Excel | |||
Fix dimensions | Excel Discussion (Misc queries) | |||
frequency in two dimensions? | Excel Worksheet Functions | |||
Specify dimensions for Excel charts | Charts and Charting in Excel | |||
Three Dimensions? | New Users to Excel |