software

How can I equate the size of row and column with inches? If I want a column
to be 1quot; wide and the row 1/2quot; 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/2quot; and 13 is
the width for 1quot;. 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

Height is measured in points (72 points to the inch)
Width is measured in points (12 points to the inch)

--
Gary's Studentquot;Connie Martinquot; wrote:

gt; How can I equate the size of row and column with inches? If I want a column
gt; to be 1quot; wide and the row 1/2quot; high, how do I do it? I have a work-around,
gt; but it is tedious. I've discovered that 36 is the height for 1/2quot; and 13 is
gt; the width for 1quot;. But that is by creating a box by that size and sizing the
gt; column and row to fit it. That's the only way I know to get the size of
gt; column and row I want, but surely there is a simpler way of doing this!
gt; Connie

Hi,

I have made the row A1 cell height amp; width by 72-12 ratio respectivily, but
the results r not correct. I have also made a square of 1quot; 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

quot;Gary''s Studentquot; wrote:

gt; Height is measured in points (72 points to the inch)
gt; Width is measured in points (12 points to the inch)
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Connie Martinquot; wrote:
gt;
gt; gt; How can I equate the size of row and column with inches? If I want a column
gt; gt; to be 1quot; wide and the row 1/2quot; high, how do I do it? I have a work-around,
gt; gt; but it is tedious. I've discovered that 36 is the height for 1/2quot; and 13 is
gt; gt; the width for 1quot;. But that is by creating a box by that size and sizing the
gt; gt; column and row to fit it. That's the only way I know to get the size of
gt; gt; column and row I want, but surely there is a simpler way of doing this!
gt; gt; Connie

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.

www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Sat, 20 Jun 2009 00:24:01 -0700, Mujeeb ur Rehman, FBL-GRW-PK mgt; wrote:

gt;Hi,
gt;
gt;I have made the row A1 cell height amp; width by 72-12 ratio respectivily, but
gt;the results r not correct. I have also made a square of 1quot; and put the same
gt;on A1, but the square is bigger than A1. You can also do the practicle and
gt;suggest the exact match.
gt;
gt;Thanks
gt;
gt;Mujeeb
gt;
gt;quot;Gary''s Studentquot; wrote:
gt;
gt;gt; Height is measured in points (72 points to the inch)
gt;gt; Width is measured in points (12 points to the inch)
gt;gt;
gt;gt; --
gt;gt; Gary's Student
gt;gt;
gt;gt;
gt;gt; quot;Connie Martinquot; wrote:
gt;gt;
gt;gt; gt; How can I equate the size of row and column with inches? If I want a column
gt;gt; gt; to be 1quot; wide and the row 1/2quot; high, how do I do it? I have a work-around,
gt;gt; gt; but it is tedious. I've discovered that 36 is the height for 1/2quot; and 13 is
gt;gt; gt; the width for 1quot;. But that is by creating a box by that size and sizing the
gt;gt; gt; column and row to fit it. That's the only way I know to get the size of
gt;gt; gt; column and row I want, but surely there is a simpler way of doing this!
gt;gt; gt; Connie