This will open the ‘Accept or Reject Changes’ dialog box. In ‘Where’, you can select a range of cells in which you want to review the changes.In ‘Who’ you can select whose changes you want to review.In ‘When’ you can select all changes that have not been reviewed or specify a date.In the ‘Select Changes to be Accepted or Rejected’ dialog box, specify the When, Who, and, Where options.In the Changes group, click on the ‘Track Changes’ and select ‘Accept/Reject Changes’.Here are the steps to accept/reject changes in Excel: This can be useful when you have the reviewed file from your colleague/boss/client, and you have to decide on what changes are to be kept and which ones are to be rejected. When the changes are made, these are not final until you review these changes. This will instantly create a new worksheet that will list all the changes that you have made. In the ‘When’ option, you can specify if you want all changes or changes that are not reviewed or ‘changes since last saved’. In the ‘Highlight Changes’ dialog box, check the option – ‘List changes on a new sheet’.In the Changes group, click on Track Changes and select Highlight Changes.Save the workbook so that the changes that are made are saved as well.Here are the steps to get a list of all the changes in a new worksheet: If you have a workbook that has a lot of changes made to it, you may want to get a list of all the changes separately as a list. You will notice that some of the options in the ribbon are grayed out. For example, you will not be able to protect a sheet when ‘track changes’ are ON. Note that when ‘track changes’ option is enabled in Excel, the workbook is shared and some of the features are automatically disabled. When you hover the cursor over the cell that has a change, it will show a message that specifies what the change is, who made the change, and when it was done. This is similar to the red triangle you see when you insert a comment in a cell.įor example, below I have a dummy project plan and I have made changes in column B (cell B4 and B6). Once you have enabled the tracking, whenever you or anybody who accesses the workbook makes any changes to it, it will get highlighted with a blue border and get a small blue triangle in the top left of the cell. If the file is already saved, it will still save it before enabling the tracking. If the file has not been saved, it will first ask you to save it before enabling the ‘Track Changes’ option. Note: For this option to work, you need to have the workbook saved on your system or a network drive. The above steps would enable ‘Track Changes’ in Excel and now it will highlight any change done to the workbook. For this tutorial, I will go with the default settings. You can also specify the ‘When’, ‘Who’, and ‘Where’ options.

In the Highlight Changes dialog box, check the option – ‘Track changes while editing.In the Changes group, click on the Track Changes option and select Highlight Changes.Here are the steps to enable track changes in Excel: Difference Between Comments and Track ChangesĮnabling the Track Changes in Excel Featureīy default, this feature is disabled in Excel.Enabling the Track Changes in Excel Feature.

Enable tracking changes in exce for mac