Move Or Copy Cell Widths Along With. Click on the cell in the new worksheet where you want to place the data and then click the Paste button. Open the other worksheet to which you want to copy the data.
Copying data from one Excel column to another often means an additional task. Make each cell width in the header table the same width as the cells in the orginal table header table has one row headerTablefindtd theachfunctionindex var width originalTablerows0cellsindexoffsetWidth thiswidth width. The column widths are attributes of columns not of cells.
Try using offsetWidth something like.
Firstly we will show you how to copy data with column width. The cells will be copied just like they normally would but the column widths will be. Microsoft quietly added Column Widths to the Paste Special dialog a few versions ago. Copy and paste cell sizes.
