In Excel track changes and comments when proofreading worksheets. Also share Excel workbooks with others easily.
Sometimes it's difficult to see exactly what has been changed in a shared workbook. Taking in the meaning of a large amount of feedback can also be problematic if your worksheet contains several comments. There are a few settings you can use to adjust the way changes and comments are viewed.
An alternative to viewing changes as highlights on your worksheet, you can view them on a new worksheet of their own, sometimes called the change history. The change history lists everything in your worksheet that has been changed, including the old value—what the cell used to contain—and the new value—what the cell contains now.
To remove the History worksheet from your workbook, you can either save your workbook again or uncheck the box next to List changes on a new sheet.
Click the Show All Comments command to view every comment in your worksheet at once.