column pixels vs column width

[Marc C]

I have an Excel worksheet that I have fit the columns to a column width of 2.
I copy every cell from this worksheet into a new worksheet that I have set
the column widths to 2 also. However, when I paste the cells into the new
worksheet, the column width of the new worksheet is changed to 2.86. I've
notcied that in the existing worksheet, when the column width is 2, the
pixels is 25. In the new worksheet, when the cell width is 2.86, the pixels
is 25. I can only conclude that when I paste to the new worksheet, Excel is
pasting based on the pixel size, not the column width. I CANNOT have a column
width of 2.86. It needs to be 2 so that the worksheet prints correctly.
However, if I change the new worksheet to have a column width of 2, the text
is overlapping and unreadable. Please help!!

Thanks,
Marc

 

[Jim Thomlinson]

Perhaps this will help you understand what is happening...

http://support.microsoft.com/default.aspx/kb/214123

 

[Gord Dibben]

On my computer display resolution setup a width of 2 equates to 19 pixels

In addition to Jim's reply................................

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/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP