How to size rows and columns in pixels rather than units

[Mark Stephens]

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

 

[John Bundy]

It measures them with an overly complicated font method. This should get you
going
http://support.microsoft.com/kb/213422

 

[John Bundy]

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

 

[Mark Stephens]

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