Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Connie Martin
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down list box width - data validation Laura Excel Discussion (Misc queries) 1 March 17th 06 10:58 PM
Data Validation - width of drop down box Laura Excel Discussion (Misc queries) 0 March 16th 06 11:18 PM
How can I widen the page header/footer width? Schabby Excel Discussion (Misc queries) 1 February 16th 06 10:49 PM
Adjust an Excel table with the width of a Word page [email protected] Excel Discussion (Misc queries) 1 August 2nd 05 10:24 AM
Changed column width keeps reverting back to original size David Boone Excel Discussion (Misc queries) 3 May 29th 05 01:22 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"