- Editing Data
- Overwriting and Deleting Data
- Undoing and Redoing Changes
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Cutting, Copying, and Pasting Data
- Flipping Rows and Columns
- Moving Data
- Finding Data
- Replacing Data
- Adding and Viewing Cell Comments
- Editing and Deleting Cell Comments
- Inserting Symbols
- Tracking Changes
- Accepting or Rejecting Tracked Changes
- Checking Spelling
Accepting or Rejecting Tracked Changes
When you are ready to finalize a worksheet containing tracked changes, you must determine which changes you want to keep, or accept, and which you want to reject. When you reject a change, Excel restores the cell to its previous value.
Open the Tools menu, choose Track Changes, and select Accept or Reject Changes to open the Select Changes to Accept or Reject dialog box.
Excel notifies you that the workbook will be saved; click OK. (If you have already saved your changes to the workbook, you won’t get this message.)
Click OK to accept the default options in the When, Who, and Where fields.
Excel locates the first changed cell in your worksheet. To accept the change, click the Accept button.
Excel locates the next changed cell in your workbook. To reject the change, click the Reject button.
When you’re finished searching for tracked changes, click the Close button.
Notice that the Track Changes marker remains for your reference on cells in which you accepted changes, but is removed for rejected changes.