If you work with an Excel file that needs to be updated or reviewed by other people, the option to track changes in Excel can come in handy.
You can also use it when you're updating a file and need to keep a track of all the changes you do yourself. This can be helpful when you revisit it sometime later.
In this video, I will show you how to track changes in Excel.
The video first covers how to enable the track changes functionality in Excel.
To do this:
-- Go to the Review tab.
-- In the Changes group, click on the Track Changes option and select Highlight Changes.
-- In the Highlight Changes dialog box, check the option - 'Track changes while editing. This also shares your workbook'. You can also specify the 'When', 'Who', and 'Where' options. For this tutorial, I will go with the default settings (these options are explained later in the article).
-- Click OK.
The above steps would enable 'Track Changes' in Excel and now it will highlight any change done to the workbook.
The video also covers:
-- How to accept/reject changes.
-- How to get a list of all the changes listed in a separate tab.
-- How to disable track changes in Excel.
Read More about track changes in Excel here: [ Ссылка ]
Free Excel Course - [ Ссылка ]
Paid Online Training - [ Ссылка ]
Best Excel Books: [ Ссылка ]
Subscribe to get awesome Excel Tips every week: [ Ссылка ]
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
![](https://i.ytimg.com/vi/d2Zyt56L3fM/maxresdefault.jpg)