• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Accepting or Rejecting Tracked Changes

Accepting or Rejecting Tracked Changes

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.

INTRODUCTION

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.


TIP

Accepting or rejecting all changes

Click Accept All if you want to accept all changes in the workbook; select Reject All if you want to reject all the changes in the workbook.


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.

TIP

Viewing descriptions of changes

Any changes made to your work book while the Track Changes feature is on will be displayed in the Accept or Reject Changes dialog box.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint