Thanks Gord! I had no idea there were different definitions of "pixels"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
| To add to and I think, correct Niek's reply a bit.............
|
| Row heights are measured in points or pixels. There are 72 points to an inch
| and "maybe" 96 pixels to the inch.
|
| The number that appears in the Standard column width box is the average number
| of digits 0-9 of the standard font that fit in a cell.
|
| When dragging the column width you will see two numbers.........one is width as
| above, the other is pixels.
|
| For an interesting and enlightening discussion on this subject see
|
| http://snipurl.com/dzz8
|
| If you want to use VBA to set height and width in mm.
|
| Ole Erlandson has code for setting row and column dimensions.
|
| http://www.erlandsendata.no/english/...vbawssetrowcol
|
|
| Gord Dibben Excel MVP
|
| On Tue, 4 Mar 2008 12:40:58 +0100, "Niek Otten" wrote:
|
| Hi Andy,
|
| The width of cells is measured in pixels.
| 1.14 is 13 pixels. 1.29 is 14 pixels, etc. You can see it in a ScreenTip if you drag the column border.
| AFAIK, you can't do anything about it.
|
| Maybe you can increase the column width but display and print scaled to a reduced size?
|