To track changes and comments in Excel worksheets, follow these steps:
Open the Excel worksheet that you want to track changes and comments in.
Go to the "Review" tab in the Excel ribbon.
In the "Changes" group, click on the "Track Changes" button. This will open the "Highlight Changes" dialog box.
In the "Highlight Changes" dialog box, check the box next to "Track changes while editing. This also shares your workbook." You can also choose to highlight changes on the screen or have them saved in a separate history sheet.
Select any additional options you want, such as choosing how changes are marked or specifying when changes should be made.
Click OK to close the dialog box.
Now, any changes made to the worksheet will be tracked. When you click on a cell that has changed, Excel will display a small triangle in the corner of the cell. You can hover over the cell and click on the triangle to see the history of changes.
To add comments to a cell, simply right-click on the cell and choose "Insert Comment." Type your comment in the comment box that appears.
You can also view and edit existing comments by right-clicking on the cell and selecting "Edit Comment" or "Delete Comment."
To easily navigate between comments, go to the "Review" tab and click on the "Next" or "Previous" button in the "Comments" group.
By following these steps, you can effectively track changes and add comments to your Excel worksheets.