Why does my typing appear in all sheets?

[corpcc]

Hi there

I have several spreadsheets each containing multiple sheets.

I am using Excel 2010.

When I type on one sheet or copy and paste on one sheet all the sheets are updated with this information.

How can I stop this happening?

Any help would be appreciated.
Thanks
Corpcc

 

[VoG]

It sounds like you have grouped the sheets. Try clicking on the tab of one of the sheets in the middle to ungroup them.

 

[kidwispa]

Are all your tabs grouped at the bottom? Try right clicking on a tab and selecting ungroup sheets... if that doesn't do it I have no idea!



EDIT - Too late!

 

[corpcc]

Hi Kidwispa

Thanks for that - I grouped them for printing yesterday - didn't think to ungroup them!

Thansk again
Corpcc