How to Track Changes in Excel – Knowligent
How to Track Changes in Excel

How to Track Changes in Excel

HomeHow to, TechHow to Track Changes in Excel

Are you looking for a way to track changes in an Excel spreadsheet? There are many instances where you need to distribute a file to multiple people and keep track of what changes were made. You may want to keep track of when the change was made, who made the change, what cell the change occurred in, and what data was changed.

How to Use Track Changes in Excel

Excel has built-in tracking features that can handle all of the above cases. You can easily view all changes directly on the worksheet and you can also accept or reject any change. There are a few points to remember about Excel’s tracking features:

1. Enabling tracking does not mean that you can revert the spreadsheet back in time to a previous state by undoing the changes. It is essentially a log file that records everything and that is it. You can manually go and see what data has been deleted or added, but you will have to make the changes in the spreadsheet itself.

2. Turning on tracking does not mean that every change you make will be recorded. All data stored in a cell is tracked, but other changes such as formatting are not. Other changes that are not tracked include hiding/unhiding rows and columns, comments, and cell values that change as a result of a formula recalculation.