Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Some strange behaviour I've encountered twice in Excel is that changes made to one sheet would be duplicated on another sheet in the same workbook. The first time, I typed values into a few cells on sheet 1, and the corresponding cells in sheet 2 also changed. There were cell references involved. It was as if there was carbon paper between the two sheets.

The second time, on sheet 1 I copied a formula at A4 over the 1000 cells below it. On sheet 2, a formula that happened to be on A4 got copied over the 1000 cells below it, destroying the sheet in the process.

Does anyone know the cause of this?

share|improve this question
add comment

1 Answer 1

up vote 4 down vote accepted

If you have more than one worksheet selected then any edits you make will be on all of them.

To select/deselect multiple worksheets, hold down Ctrl or Shift while left clicking on the worksheet tabs.

The image below shows Sheet1 and Sheet2 selected, while Sheet3 is not. Any edits made on Sheet2 will also be applied to Sheet1.

Excel tabs

share|improve this answer
    
Thank you! This was exactly my problem. Sometimes I would intend to select an entire area and accidentally click CTRL+SHIFT+PAGEDOWN instead of CTRL+SHIFT+ARROWDOWN. –  Tristan Mar 7 '13 at 5:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.