Problem with cell size

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi

I have Excel 2002, I am trying to set my cell size to 15 x 15, when I
select Row Height 15 I get the required height but when I select column
width 15 I get a much wider result, the cells are not square.

What am I doing wrong?

thanks

Daniel
 
The values for each of these sizes are in different units of measurement.
From the help files...

"On a worksheet, you can specify a column width of 0 (zero)
to 255. This value represents the number of characters that
can be displayed in a cell that is formatted with the standard
font (standard font: The default text font for worksheets.
The standard font determines the default font for the Normal
cell style.). If the column width is set to 0, the column is hidden.

You can specify a row height of 0 (zero) to 409. This value
represents the height measurement in points (1 point equals
approximately 1/72 inch). If the row height is set to 0, the
row is hidden."

Rick
 
Rick

thanks for your reply, it looks like I will have to do it by trial and
error, but at least I know now

regards

Daniel
 
You can try settings in Pixels but that is resolution-dependent from machine to
machine.

Rather than trial and error, which will fall apart if you give the file to a
user with different Windows Settings or you change resolution yourself.

If you want to use VBA to set height and width in mm.

Ole Erlandson has code for setting row and column dimensions which will not be
affected by resolution.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP
 
looks good, I'll give it a go.

Thanks

Daniel
Gord Dibben said:
You can try settings in Pixels but that is resolution-dependent from
machine to
machine.

Rather than trial and error, which will fall apart if you give the file to
a
user with different Windows Settings or you change resolution yourself.

If you want to use VBA to set height and width in mm.

Ole Erlandson has code for setting row and column dimensions which will
not be
affected by resolution.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP
Click to expand...
 
Back
Top