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 - 20 Mar 2008 21:46 GMT
Perhaps this will help you understand what is happening...
http://support.microsoft.com/default.aspx/kb/214123

Signature
HTH...
Jim Thomlinson
> 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
[quoted text clipped - 10 lines]
> Thanks,
> Marc
Gord Dibben - 21 Mar 2008 00:21 GMT
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
>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
[quoted text clipped - 10 lines]
>Thanks,
>Marc