In this lesson we will learn how to track changes in Excel workbook.
To track changes in excel click ‘Track Changes’ in ‘Changes’ group under ‘Review’ menu of the excel workbook. There you will find two options – ‘Highlight Changes’ and ‘Accept/Reject Changes’.
Select ‘Highlight Changes’ first.
Now the below pop up can appear.
In that case you need to perform the below steps.
- Click on the Microsoft icon on the top left corner of the workbook. Then Click ‘Excel Options’
- Then go to ‘Trust Center’ and click ‘Trust Center Settings’
- Another pane will be appeared. Go to ‘Privacy Options’ here and then uncheck the checkbox ‘Remove personal information from file properties on save’. Then click OK.
- Now click OK in the Excel Options pane as well.
Now again click ‘Track Changes’ and then ‘Highlight Changes’ in ‘Changes’ group under ‘Review’ menu of the excel workbook.
The below Highlight Changes pane will appear. You can select the respective options as per your requirement to see the changes highlighted in your workbook. If you select the option for ‘List changes on a new sheet’ then the changes will be displayed separately in a new sheet.
You can choose the appropriate option available in ‘When’ dropdown to highlight the changes made since you last saved the workbook or the changes not yet reviewed, or all changes or the changes made since a particular date.
From ‘Who’ dropdown you can select the option to highlight the changes done by everyone or everyone but you or you only. You can also select any specific range of cells to review the changes from ‘Where’ option.
Click OK to see the changes highlighted.
Now there is a provision to review the changes. The changes are not final until you review and accept the change. To do that click ‘Track Changes’ in ‘Changes’ group under ‘Review’ menu of the excel workbook. Here click ‘Accept/Reject Changes’.
The below pane will appear. You can select the changes to accept or reject since any particular date or all changes not yet reviewed from the ‘When’ option. Also you can select the changes to review made by everyone or everyone but you or you only from the ‘Who’ option. You can also select any specific range of cells to review the changes from ‘Where’ option. Then click OK.
Now in the below pane all changes will be displayed. Here all changes will be listed. You can select each of those and accept or reject one by one or you can accept or reject all changes together. If you reject a change, it will be reverted back to it’s original value.
Any time you want to disable the track change feature you need to click ‘Track Changes’ in ‘Changes’ group under ‘Review’ menu of the excel workbook. Here click ‘Highlight Changes’.
In the Highlight Changes pane uncheck the checkbox for ‘Track changes while editing. This also shares your workbook’.
The below dialogue box will appear. It states removing track changes will remove the workbook from shared use. The change history will be erased and the unsaved changes of other users will be lost even if you again share the workbook. If you still want to remove the track changes feature then click Yes.