<div>
Actually...I probably did have multiple sheets selected. &nbsp;Earlier, when I tried to copy one sheet, ALL sheets were copied...I guess for the same reason. &nbsp;I have no idea how I copied all sheets...How do I un-select them all so I can just make changes to one?!
</div>


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

<div>
Right click on one of the selected sheets and select Ungroup Sheets.
</div>


Right click on one of the selected sheets and select Ungroup Sheets.

<div>
Yep...nice one. &nbsp;Thanks.<br />
<br />
Well, at least I now know how to edit multiple sheets at once!<br />
<br />
Thanks both of you for your help
</div>


Yep...nice one.  Thanks.

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

Thanks both of you for your help

<div>
<div class="content wysiwyg-content">
Hi There,<br />
<br />
I have a reasonably complex workbook that has just started behaving strangely. &nbsp;For example, on one sheet, I merged a range of cells and entered a paragraph of text. &nbsp;Bizarrely, the merged cells and entered text also shows up on multiple other sheets in the workbook.<br />
<br />
How can this be? &nbsp;I have never encountered changes being duplicated across sheets. &nbsp;Is the Excel file corrupted? &nbsp;Does anyone know how to un-corrupt the sheet, if that is what has happened?<br />
<br />
Thanks
</div>
</div>


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

Excel Sheet changes being duplicated on other sheets - weird behavior

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.