Excel has many useful features for users. Here we will discuss about the feature track changes in Excel.
If your Excel has been modified by other people, you will certainly want to know which cell has changed. And you need to evaluate whether the change is acceptable or not. Thus, you can use the track changes feature in Excel to help you achieve this function.
- Click “File” in the ribbon.
- And then click “Options”.
- In the “Excel Options” window, click “Trust Center”.
- And then click “Trust Center Settings” on the left.
- Then in the “Trust Center” window, uncheck the option “Remove personal information from file properties on save” under the “Privacy Options”.
- Next click “OK”.
- Continue click “OK” in the “Excel Options” window.
- And then click tab “Review” in the ribbon.
- Next click the button “Track Changes”.
- In the menu, choose “Highlight Changes”.
- And then you will see the window of “Highlight Changes”. Here check the option “Track changes while editing”. And in the part of “Highlight which changes” part, you can set other conditions according to your need.
- Last click “OK”.
- And in the warning dialog, click “OK”. Thus, the setting and the workbook will all be saved. What’s more, the file will be in the shared form.
Now you open the file that has been modified by other people. And you can choose to accept or reject the changes.
- Click the tab “Review” in the ribbon.
- And then click “Track Changes” button.
- Next click “Accept/Reject Changes” in the menu.
- In the new window, set the different conditions in the part of “Which changes”. You can choose according to your need.
- And then click “OK”.
- Next you will see the changes in this window.
Here the target area will be highlighted. And you can choose to accept or reject the change by clicking the button in this window.
Now if you have checked all the changes and want to cancel the shared mode, you need to delete the information in the “Highlight Changes” window. And next check the option in the “Trust Center” that you have unchecked in step 5 of the first part of this article.
Excel Crash can Do Harm to Your Settings
If you use Excel frequently, you will certainly have many settings in Excel. And all those settings are set to help you finish tasks better. However, if Excel crashes, the settings will most probably lose. Hence, to repair Excel is the most important thing. And you can use our sophisticated software to recover all the settings in Excel. With this tool, you can rest assured and wait for the process to finish.
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com