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
 
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
 
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