How to size rows and columns in pixels rather than units

M

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
 
J

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pixels per Inch 3
Excel 2007 Column and Width pixels not showing 2
How to got the position of a cell/range in pixels (from the left-top corner) ? 1
Control Width and Height limited to 32,767 pixels 3
How to get text width and hieght in a richtext box 3
rows and columns on worksheet 1
How to get an active window's size (width and height) 2
Size of Spreadsheet Displayed - both in Cells and TWIPs 3

Top