Microsoft® Office Excel® 2007 Plain & Simple

Accepting or Rejecting Changes

When you and your colleagues have made your changes to a workbook, you can go through the workbook and accept or reject those changes. The best way to accept or reject changes is to move through them one at a time. Although examining each change in a large document can be tedious, it’s far less of a hassle to take an hour to finalize a workbook than it is to spend a day reconstructing a workbook after you accidentally accepted every change. If you want to keep track of every change, you can have Excel create a new worksheet named History and list every change made since you last saved. Whenever you save your workbook, Excel will delete the History worksheet.

View a Change

• Hover over a cell with a blue triangle in ...