This causes your workbook edits to be visible. The center check boxes (When, Who, and Where) have more to do with resolving revisions, as discussed in a later tip.Īt the least, you will want to make sure that the Highlight Changes On Screen check box is selected. The three check boxes in the middle of the dialog box allow you to specify which changes should be highlighted, and the check boxes at the bottom of the dialog box indicate how the highlights appear. With revision marking turned on, you can specify how you want this tool to be used by Excel. If you later want to turn off revision marking, you can display this dialog box again and clear the check box. To turn on revision marking, simply select the check box at the top of the dialog box. Excel displays the Highlight Changes dialog box. This displays a submenu from which you should choose Highlight Changes. You control revision marking by displaying the Review tab of the ribbon and clicking the Track Changes tool. Thus, if you have two workbooks open at the same time, revision marking can be turned on in either, both, or none of the workbooks. Revision marking is turned on or off on a per-workbook basis. It can be used so you can see your own changes over time. However, it can also be a valuable tool even if you are the only one using a workbook.
![excel 2016 review tracking excel 2016 review tracking](https://i0.wp.com/tracyvanderschyff.com/wp-content/uploads/2016/07/trackchanges001.png)
Revision tracking is normally meant for use in a shared environment, so you can track how other people may have changed a workbook for which you are responsible. Thus, you can see what has been added, deleted, or simply changed. In a nutshell, Excel allows you to keep track of the changes made to your workbook. A comment box is displayed with the what, who, and when details of the change.If you are a Microsoft Word user, you may already be familiar with what is meant by the term revision tracking. To display change information, hover the mouse cursor over a cell with the small triangle in the upper-left corner. A change is noted by a small triangle in the upper-left corner of the cell. When someone makes a change to a document, it is tracked. View changes in a Microsoft Excel spreadsheet Hover the mouse cursor over a change to see which change was made, who made the change, and the date of the change. Any change is underlined and in red text.Click the drop-down menu to the right of the Track Changes option, and select All Markup to see changes.In a document with tracking changes turned on, to see the changes, follow the steps below. View changes in a Microsoft Word document Click the Track Changes option and select Highlight Changes.If desired, check the box for the Who entry and choose between Everyone and Everyone but me.For the When entry, choose between Since I last saved, All, Not yet reviewed, or Since date (you need to enter a specific date).In the Highlight Changes window that opens, check the box for the Track changes while editing option.Click the Highlight Changes option in the new Tracking Changes section added above.With the spreadsheet still open, click the Review tab in the Ribbon.With the change tracking options added to the Review tab, now you can turn on change tracking by following the steps below. Click OK to save the addition of the new group and its entries. The Highlight Changes and Accept/Reject Changes entries should now be listed under the new Track Changes group on the right.In the box under Choose commands from, select the Highlight Changes and Accept/Reject Changes entries one at a time, clicking the Add button after selecting each entry.Click the new Tracking Changes group to highlight it.Right-click the new group created under Review, and select the Rename option.Click the New Group button below the Customize the Ribbon box.In the box under Customize the Ribbon, click the Review entry.
![excel 2016 review tracking excel 2016 review tracking](https://cdn.educba.com/academy/wp-content/uploads/2019/01/Track-changes-in-Excel-feature-image-1.png)
In the Excel Options window that opens, click the drop-down list under Choose commands from and select the All Commands entry.
![excel 2016 review tracking excel 2016 review tracking](https://blog.orgos.io/hubfs/employee-performance-review-template.png)
In a blank space on the Ribbon, to the right of the Ink section, right-click and select Customize the Ribbon.In the Highlight Changes window that opens, check the box for the Track changes while editing option. Click the Track Changes option and select Highlight Changes. Open the spreadsheet where you want to track changes. Open the spreadsheet where you want to track changes.In Excel 2019, you need to add the change tracking options to the Review tab in the Ribbon.