Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

Excel Sheet changes being duplicated on other sheets - weird behavior

Hi There,

I have a reasonably complex workbook that has just started behaving strangely.  For example, on one sheet, I merged a range of cells and entered a paragraph of text.  Bizarrely, the merged cells and entered text also shows up on multiple other sheets in the workbook.

How can this be?  I have never encountered changes being duplicated across sheets.  Is the Excel file corrupted?  Does anyone know how to un-corrupt the sheet, if that is what has happened?

Thanks
0
billelev
Asked:
billelev
  • 2
  • 2
2 Solutions
 
Rory ArchibaldCommented:
Are you sure you didn't have multiple sheets selected when you made the changes? (the application title bar would have [Group] in its caption somewhere.)
0
 
kgerbChief EngineerCommented:
Is the problem repeatable?  Are you sure you didn't have multiple sheets selected when you made the change?  Have you tried Open and Repair?

Kyle
0
 
billelevAuthor Commented:
Actually...I probably did have multiple sheets selected.  Earlier, when I tried to copy one sheet, ALL sheets were copied...I guess for the same reason.  I have no idea how I copied all sheets...How do I un-select them all so I can just make changes to one?!
0
 
kgerbChief EngineerCommented:
Right click on one of the selected sheets and select Ungroup Sheets.
0
 
billelevAuthor Commented:
Yep...nice one.  Thanks.

Well, at least I now know how to edit multiple sheets at once!

Thanks both of you for your help
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now