Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height/column width
How can I equate the size of row and column with inches? If I want a column
to be 1" wide and the row 1/2" high, how do I do it? I have a work-around, but it is tedious. I've discovered that 36 is the height for 1/2" and 13 is the width for 1". But that is by creating a box by that size and sizing the column and row to fit it. That's the only way I know to get the size of column and row I want, but surely there is a simpler way of doing this! Connie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height/column width
Height is measured in points (72 points to the inch)
Width is measured in points (12 points to the inch) -- Gary's Student "Connie Martin" wrote: How can I equate the size of row and column with inches? If I want a column to be 1" wide and the row 1/2" high, how do I do it? I have a work-around, but it is tedious. I've discovered that 36 is the height for 1/2" and 13 is the width for 1". But that is by creating a box by that size and sizing the column and row to fit it. That's the only way I know to get the size of column and row I want, but surely there is a simpler way of doing this! Connie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height/column width
Hi,
I have made the row A1 cell height & width by 72-12 ratio respectivily, but the results r not correct. I have also made a square of 1" and put the same on A1, but the square is bigger than A1. You can also do the practicle and suggest the exact match. Thanks Mujeeb "Gary''s Student" wrote: Height is measured in points (72 points to the inch) Width is measured in points (12 points to the inch) -- Gary's Student "Connie Martin" wrote: How can I equate the size of row and column with inches? If I want a column to be 1" wide and the row 1/2" high, how do I do it? I have a work-around, but it is tedious. I've discovered that 36 is the height for 1/2" and 13 is the width for 1". But that is by creating a box by that size and sizing the column and row to fit it. That's the only way I know to get the size of column and row I want, but surely there is a simpler way of doing this! Connie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height/column width
Width is not measured in points at 12 points 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 (standard font: The default text font for worksheets. The standard font determines the default font for the Normal cell style.) that fit in a cell. If you want to use VBA to set height and width in mm with 25.4 mm to the inch. Ole Erlandson has code for setting row and column dimensions which will not be affected by resolution. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Sat, 20 Jun 2009 00:24:01 -0700, Mujeeb ur Rehman, FBL-GRW-PK m wrote: Hi, I have made the row A1 cell height & width by 72-12 ratio respectivily, but the results r not correct. I have also made a square of 1" and put the same on A1, but the square is bigger than A1. You can also do the practicle and suggest the exact match. Thanks Mujeeb "Gary''s Student" wrote: Height is measured in points (72 points to the inch) Width is measured in points (12 points to the inch) -- Gary's Student "Connie Martin" wrote: How can I equate the size of row and column with inches? If I want a column to be 1" wide and the row 1/2" high, how do I do it? I have a work-around, but it is tedious. I've discovered that 36 is the height for 1/2" and 13 is the width for 1". But that is by creating a box by that size and sizing the column and row to fit it. That's the only way I know to get the size of column and row I want, but surely there is a simpler way of doing this! Connie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list box width - data validation | Excel Discussion (Misc queries) | |||
Data Validation - width of drop down box | Excel Discussion (Misc queries) | |||
How can I widen the page header/footer width? | Excel Discussion (Misc queries) | |||
Adjust an Excel table with the width of a Word page | Excel Discussion (Misc queries) | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) |