How to track changes in an Excel worksheet without using VBA.
Watch the video below:
Today we’ll learn how to track the changes we make on our worksheet without having to use VBA. First click on the ‘Review’ tab and then select ‘Track Changes (Legacy)’. When we hover the mouse over Track Changes we can see the following description: Keep track of changes made to this document. This is especially useful if the document is almost done, and you’re working with others to make revisions or give feedback.
If you are not able to view the ‘Track Changes’ icon, right-click on the ribbon and select ‘Customize Ribbon’ from the options and a new window called ‘Excel Options’ opens.
Under the header ‘Choose commands from’ click on the drop-down arrow and select ‘All Commands’. Scroll down to find ‘Track Changes (Legacy)’ . Select the item and click on ‘Add >>’ to add the item to a New Group under ‘Review’. We can create a New Group by clicking on the New Group button just above the OK button. Finally click OK
Now if we make changes in the worksheet nothing will be indicated because we have not yet activated the ‘Track Changes’.
We click on Track Changes and select ‘Highlight Changes…’ In the Highlight Changes window, we check the box for ‘Track changes while editing. This also shares your workbook.’ We also check the boxes ‘When’ and ‘Highlight changes on screen’ and click OK.
We are now offered to save the file by assigning our workbook a name. We do that by saving our workbook in an appropriate folder.
The Track Changes icon also displays a message with the header ‘Improve your collaboration’. The description of the message is: We can help you improve collaboration with this workbook by turning off the legacy Shared workbook feature so you can upload the file to OneDrive and work with others. We select ‘Not now’. If we now make a change in our worksheet, the cell where the change has been made is highlighted and in the left top corner of the cell a blue triangle apperas. If we point our mose cursor to the blue triangle we can observe a comment: takyar, 28-10-2020 13:18: Changed cell B3 from ‘67000’ to ‘650000’. This indicates the name of the person who made the changes at the specific date and time and the change.
Now if we wish to keep track of all the changes that we have made, we need to go back to Track Changes and in the Highlight Changes window that opens, we will uncheck the ‘When’ box and check the box ‘List changes on a new sheet’.
We will now get a message: Only changes whcih have been saved can be listed on the history sheet. We click OK.
Let’s make some change on our worksheet. Next we click on the ‘floppy’ icon to save the file. We go back to Track Changes and select ‘Highlight Changes…’ We uncheck the ‘When’ box and select the checkbox ‘List changes on a new sheet’ as we did last time and click on OK.
We observe that a new worksheet called ‘History’ has been created. All the changes that we made are recorded in this worksheet. In this manner we can quickly and easily track the changes to the worksheet without having to use VBA.