Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we change units of column width to pixels? | Excel Discussion (Misc queries) | |||
ChartObjects and Columns: Different Size Units? | Excel Programming | |||
Size of column in pixels | Excel Discussion (Misc queries) | |||
some columns 30 characters 155 pixels others 310 pixels why | Excel Discussion (Misc queries) | |||
How to determine JPG size in pixels? | Excel Programming |