Copy row/column- height/width and data

  • Thread starter Thread starter rekoop
  • Start date Start date
R

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.
 
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)
 
Back
Top