Copy row/column- height/width and data

[rekoop]

Hello,
Is there a way to copy and paste a row(s), or column(s)
from one workbook to another and retain column and width
setting in the new workbook?
I have used the Move/Copy worksheet but this only allows
for a worksheet to be moved/copied, I am hoping for the
same result using only specified column or widths.

Any suggestions appreciated.

 

[Frank Kabel]

Hi
one way:
- click onf the column header (or the row number) to select the entire
column (row)
- Hit CTRL+C to copy the contents
- goto the target worksheet and select the target column (row)
- insert the contents (e.g. with CTRL+V)