M
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
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