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

Tracking Changes in Excel 2

| | Information Helpful? Why Not Donate.

Displaying the Changes

Click here to go back to Track Changes Page 1

Highlight Changes on Screen See Also: Track/Report Excel Changes VBA Method

Selecting this option means each time a change is made to your Workbook, a cell comment will be inserted into the changed cell and will have: Username, Date, Time, Changed from and Changed to. A small comment flag (triangle) will be in the upper right of the cell and be a different colour to a normal cell comment.

Once you have made your choices for the options and click OK, Excel will warn us that doing so will Save the Workbook and allow you to Continue or Cancel. When you opt to Continue our Workbook will become a Shared Workbook. From now on any changes that are made will be tracked. The type of changes that are tracked are :

Changes to cell contents, including moved and pasted contents
Inserted and deleted rows and columns

List changes on a New Sheet

Remembering that we must first save our Workbook as a Shared Workbook, have some changes made and those changes saved, this option provides far more information of what changes have taken place. After you have saved the Workbook as Shared and selected this option, it means that you can then go to Tools>Track Changes>Accept or Reject Changes (after changes have been made) and have the following information automatically listed on a another Worksheet named History. This sheet will also, by default, have Excels AutoFilters turned on for easier viewing.

Action number This is the order in which the changes were made in numeric order

Date

Time

Who User name.

Change The type of change made eg; Cell change, row deletion etc.

Sheet Name of the Worksheet that the change occurred on.

Range Address of the change.

New Value Value of the cell before it was changed.

Old Value Value of the cell after it was changed.

Action Type This will list whether the change was the "Result of rejected action", "Undo" or "Won" See Accept or Reject Changes below.

Losing Action This relates to the Action Number if the change was the result of the Accept or Reject Changes dialog box. See Accept or Reject Changes below.

The History Sheet will only be available until the Workbook is re-saved. Once the Workbook is re-saved the History sheet will be deleted. To display it again simply go to Tools>Track Changes>Highlight Changes and check the Highlight changes on screen option and click OK.

Click here to go to Track Changes Page 3

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

Action number	This is the order in which the changes were made in numeric order
Date
Time
Who	User name.
Change	The type of change made eg; Cell change, row deletion etc.
Sheet	Name of the Worksheet that the change occurred on.
Range	Address of the change.
New Value	Value of the cell before it was changed.
Old Value	Value of the cell after it was changed.
Action Type	This will list whether the change was the "Result of rejected action", "Undo" or "Won" See Accept or Reject Changes below.
Losing Action	This relates to the Action Number if the change was the result of the Accept or Reject Changes dialog box. See Accept or Reject Changes below.