How to size rows and columns in pixels rather than units
 

Hi,

I want to specify the length and height of my rows and columns in pixels,
since the measurements for height and row seem to differ ...if I want square
cells, I have to specify height 9.75 (which is 13 pixels) and width 1.14 to
get the same 13 pixels.

This seems an odd way of doing things! Does anyone know if there's a reason
for it and /or what exactly are the units it is measuring, and why do they
differ for the vertical and horizontal dimension? Anyone know?

Help much appreciated, regards,Mark

How to size rows and columns in pixels rather than units
 

It measures them with an overly complicated font method. This should get you
going
http://support.microsoft.com/kb/213422
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Mark Stephens" wrote:

Hi,

I want to specify the length and height of my rows and columns in pixels,
since the measurements for height and row seem to differ ...if I want square
cells, I have to specify height 9.75 (which is 13 pixels) and width 1.14 to
get the same 13 pixels.

This seems an odd way of doing things! Does anyone know if there's a reason
for it and /or what exactly are the units it is measuring, and why do they
differ for the vertical and horizontal dimension? Anyone know?

Help much appreciated, regards,Mark

How to size rows and columns in pixels rather than units
 

And this should help if you decide to, or not to, convert
Points Pixels Inches
18 24 .25
36 48 .5
72 96 1
108 144 1.5
144 192 2

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Mark Stephens" wrote:

Hi,

I want to specify the length and height of my rows and columns in pixels,
since the measurements for height and row seem to differ ...if I want square
cells, I have to specify height 9.75 (which is 13 pixels) and width 1.14 to
get the same 13 pixels.

This seems an odd way of doing things! Does anyone know if there's a reason
for it and /or what exactly are the units it is measuring, and why do they
differ for the vertical and horizontal dimension? Anyone know?

Help much appreciated, regards,Mark

How to size rows and columns in pixels rather than units
 

Hi John,

Thanks for that, my solution is to do the same kind of thing as microsoft
give but to convert from the default to pixels, thanks very much for that,
regards, Mark

"John Bundy" (remove) wrote in message
...
And this should help if you decide to, or not to, convert
Points Pixels Inches
18 24 .25
36 48 .5
72 96 1
108 144 1.5
144 192 2

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Mark Stephens" wrote:

Hi,

I want to specify the length and height of my rows and columns in pixels,
since the measurements for height and row seem to differ ...if I want
square
cells, I have to specify height 9.75 (which is 13 pixels) and width 1.14
to
get the same 13 pixels.

This seems an odd way of doing things! Does anyone know if there's a
reason
for it and /or what exactly are the units it is measuring, and why do
they
differ for the vertical and horizontal dimension? Anyone know?

Help much appreciated, regards,Mark