copy worksheet


K

KRK

Hello

I have a workbook which contains several worksheets, all identical (except
for their input data). When I create (insert) a new worksheet I can copy &
paste cells from an existing sheet into the new one. This is fine, except
that the column widths & row heights dont come out right.

I can get over this OK, but is there a way to copy an old sheet into a new
one and preserve the rows & columns?

Thanks

K
 
Ad

Advertisements

R

Ron de Bruin

Hi KRK

You must copy the complete columns or use this also when you paste your range
Rightclick on the destination cell
Choose Paste Special
Columnwidth
OK
 
Ad

Advertisements

G

Gordon

KRK said:
Hello

I have a workbook which contains several worksheets, all identical (except
for their input data). When I create (insert) a new worksheet I can copy &
paste cells from an existing sheet into the new one. This is fine, except
that the column widths & row heights dont come out right.

I can get over this OK, but is there a way to copy an old sheet into a new
one and preserve the rows & columns?


Have you tried right-clicking on the worksheet tab, and choosing Copy?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top