Steps to Track Changes in Excel
Below is a sample table that shows how to track changes in excelTrack Changes In ExcelTracking changes in Excel is a technique of highlighting changes made in a shared worksheet by any user. It highlights the cell that has been modified. This option is present in the "changes" section of the review tab and can be enabled when we share a workbook..
Steps to track changes in Excel are as follows.
- Now, to enable “Track Changes,” go to “Review” and click on “Track Changes” and select “Highlight Changes.”
- After selecting the highlight changes, a window will pop up.
Highlight changes detect any change in the workbook shared with other users.
- Select the checkbox for “Track changes while editing” this is essential for excel to keep track of records for any change made in the shared workbook.
- Select “When” for the desired time and “Who” checkbox for whose ever changes are needed to be tracked and highlighted for changes.
- The “Highlight changes on screen box” are selected to indicate the cell where the records are changed and provide details in the comments at the corner of the cells. And click OK to save the actions in the workbook.
- Any changes in the workbook would be highlighted in the cell borders along with the details of users in the comments. The comments will be available in the upper left corner of the cell with the name of the user who has made the changes to the cell and the content change.
As we can see, the changes were made in two cells D4. The comment box will appear by hovering the cursor over the highlighted cells.
Viewing Changes in Separate Sheet
- Step 1: Highlight changes also provide the record for the list of changes made to the cells available in a separate sheet for review. This allows different users to make the changes to the workbook, for this to happen to go to Review -> Share Workbook.
- Step 2: After selecting the Share workbook, a window will pop up. Now select the box for “Use the old shared workbooksShared WorkbooksTo share the workbook, open the desired workbook>click on review tab>choose share workbook option>a dialogue box with "editing" and "advanced" tab will open>mark the required checkbox, save changes> upload the file to network location>send the link to the concerned person. features instead of the new co-authoring experience.” Then click the OK.
- Step 3: Next, go to Review – > Track Changes -> Highlight Changes, as shown in Step 1.
- Step 4: Once the window pops-up, select the “Who” checkbox for enabling other users to make changes to the workbook. Then select the checkbox for “List changes on a new sheet” to view all the changes made in a new sheet. Then click the OK. Again click OK for the prompt to save the actions.
- Step 5: This will trigger a new sheet to generate named “History” tab, as shown below.
As we can see, excel provides all the information related to any change in the cell. The Action type and losing action indicates if there are any conflicting changes or changes done to the same cell by different users.
The History tab can be saved as a separate workbook or can be regenerated again to see for any new changes done by different users; the new changes would be merged to the existing records when selecting the “List changes on a new sheet” checkbox again.
Accept or Reject Changes in Workbook
- Step 1: To accept or reject the changes made by a different user in the workbook, go to Review -> Track Changes -> Accept/Reject Changes.
- Step 2: Accept/Reject changes would pop up a window, which needs to be configured for the below selections.
When the selection box, I would ask for the changes which are not reviewed yet or since date.
Who checkbox selection, choose either everyone, everyone but me or a specific user. Then click the OK.
- Step 3: Once the above selections are made, a pop-up will ask whether the changes made be accepted, rejected, or to keep the original content.
If there are any conflicts, that is, if different users have made changes to the same cell, then the pop-up will list down all the changes made to the specific cell, and the selections can be made to accept anyone’s record.
How to Change Number of Days for Maintaining Track History?
Generally, the track changes in excel for the records are usually maintained for 30 days by default; this can be changed as per convenience by going to Review -> Share Workbook.
After the selections, a pop-up window will appear, as can be seen in the below image. Then in the “Advanced” tab, the history can be changed to the desired number of days, else excel would take the default settings. Then click on OK once the necessary settings are updated.
How to Disable Track Changes?
Now go to Review -> Track changes, then select Highlight changes.
Once the pop-up window appears, uncheck the box for “Track changes while editing.” Click OK. Then turn off tracking and stop sharing the workbook to other users.
Things to Remember
- Once the track changes are enabled, the workbook becomes a shared file, which means that other users could also access the excel file.
- Only content changes in cells are tracked; other changes such as formatting or grouping won’t be considered.
- The track record changes will be maintained for only 30 days by default; this could be changed by following how to maintain track history.
- Option for undo is not available; once the changes are made to the cell, they can be brought to its original content by accepting or rejecting in “Track Changes.”
This has been a guide to track changes in excel. Here we discuss how track changes work in excel, which includes Accept or Reject Changes, Maintaining Track History, and Disable Track Changes along with example and downloadable excel template. You may learn more about excel from the following articles –