Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Tracking Changes in Excel 3

| | Information Helpful? Why Not Donate.

Displaying the Changes

Click here to go back to Track Changes Page 2

Accept or Reject Changes See Also: Track/Report Excel Changes VBA Method

Once you have selected the options for Highlight Changes AND there has been changes made AND the Workbook has been saved, go to Tools>Track Changes>Accept or Reject Changes and see the Select Changes to Accept or Reject dialog box. It is in here that we determine which changes we want to either Accept or Reject.

The choices here are When, Who and Where. These option are basically the same as the When, Who and Where options under the Track Changes dialog box. To Accept or Reject Changes for the entire Workbook, leave the Where checkbox unchecked.

Once you have made your choices, click OK and Excel will display the Accept or Reject Changes dialog box. You can now move through all the changes made and either Accept or Reject them. Rejecting a change will result in the cell being returned to its changed from value. If there has been more than one change to a cell and the Workbook has been saved between changes, you will see a list of the changes made. You simply select the value you wish to return the cell value back to and click Accept. The Accept All and Reject All buttons will either reject or accept all changes, depending on the choice made. You must either Accept or Reject a change before you can move onto the next change.

A couple of things to remember when you are using Track Changes:

Track Changes doesn't track any formatting changes that may have been made
The Changes History Log is only kept for a period of 30 days as a default, although it can be changed

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft