Copy the entire sheet to overlay existing sheet?

[LurfysMa]

Is there anyway to copy an entire sheet to an existing sheet and
overlay whatever was there?

I know I can copy a sheet and create a new sheet, but then I have to
rename it.

Thanks

 

[Paul Sheppard]

Is there anyway to copy an entire sheet to an existing sheet and
overlay whatever was there?

I know I can copy a sheet and create a new sheet, but then I have to
rename it.

Thanks

Hi LurfysMa

Select the whole sheet you want to copy, by clicking in the square to
right corner above 1 and left of A, all cells will go grey, then fro
the Edit Menu click copy, go to the sheet you want to overlay the dat
on to and click in cell A1, then from the Edit menu click on past

 

[LurfysMa]

Hi LurfysMa

Select the whole sheet you want to copy, by clicking in the square top
right corner above 1 and left of A, all cells will go grey, then from
the Edit Menu click copy, go to the sheet you want to overlay the data
on to and click in cell A1, then from the Edit menu click on paste

That's essentially what I tried. I thought it didn't work because the
text on the new sheet was much larger than the text on the old one.
What I didn't notice was that I had set the Zoom factor to 75% on the
old sheet, whereas it was 100% on the new one.

It works just as you describe.

Thanks