Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
How to change column pixels to the standard size? | Excel Worksheet Functions | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Size of column in pixels | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |