copying one sheet to another

[steve]

Hello Again

I know I've done this before but but be having a brain
fart.
I need to copy my spreadsheet to a sheet in the same book
but when I do it does'nt change the row and colum width
with it. can someone tell me what I am doing wrong.

Thanks
Steve

 

[Paul]

Hello Again

I know I've done this before but but be having a brain
fart.
I need to copy my spreadsheet to a sheet in the same book
but when I do it does'nt change the row and colum width
with it. can someone tell me what I am doing wrong.

Thanks
Steve

There's a big difference between copying the sheet itself (right-clicking
the worksheet tab and using "Move or Copy Sheet") and copying the CONTENTS
of the sheet (using copy/paste). The former will copy everything, including
row height and column width.

 

[STEVE]

Thank you I just tried it again and it work. I don't know
what I was doing wrong before but copying from one sheet
to another is what I was doing.
thanks again
Steve