How Can I See Track Changes Comments if I Do Not Have Word Installed?

Watch Video – How to Track Changes in Excel

If you work with an Excel file that needs to be updated or reviewed by other people, the option to track changes 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 tutorial, I will show you how to track changes in Excel.

• Enabling the Track Changes in Excel Feature
• How do 'Track Changes' work in Excel?
• Getting a List of All the Changes
• Accepting/Rejecting Changes
• Disabling Track Changes in Excel
• Difference Between Comments and Track Changes

Enabling the Track Changes in Excel Feature

By default, this feature is disabled in Excel.

Here are the steps to enable track changes in Excel:

The above steps would enable 'Track Changes' in Excel and now it will highlight any change done to the workbook.

Note: For this option to work, you need to have the workbook saved on your system or a network drive. If the file has not been saved, it will first ask you to save it before enabling the 'Track Changes' option. If the file is already saved, it will still save it before enabling the tracking.

How do 'Track Changes' work in Excel?

Once you have enabled the tracking, whenever you or anybody who accesses the workbook makes any changes to it, it will get highlighted with a blue border and get a small blue triangle in the top left of the cell. This is similar to the red triangle you see when you insert a comment in a cell.

For example, below I have a dummy project plan and I have made changes in column B (cell B4 and B6).

When you hover the cursor over the cell that has a change, it will show a message that specifies what the change is, who made the change, and when it was done.

Note that when 'track changes' option is enabled in Excel, the workbook is shared and some of the features are automatically disabled. For example, you will not be able to protect a sheet when 'track changes' are ON. You will notice that some of the options in the ribbon are grayed out.

Getting a List of All the Changes

If you have a workbook that has a lot of changes made to it, you may want to get a list of all the changes separately as a list.

Here are the steps to get a list of all the changes in a new worksheet:

This will instantly create a new worksheet that will list all the changes that you have made.

Accepting/Rejecting Changes

When the changes are made, these are not final until you review these changes. This can be useful when you have the reviewed file from your colleague/boss/client, and you have to decide on what changes are to be kept and which ones are to be rejected.

Here are the steps to accept/reject changes in Excel:

If you reject a change, it will revert back to the original value.

Note that when you accept a change, you can not undo it.

Disabling Track Changes in Excel

Once your work is finalized, you can disable the track changes feature in Excel. That will remove any existing blue box in the cells and will stop tracking any further changes.

Here are the steps to disable 'track changes' in Excel:

Difference Between Comments and Track Changes

A lot of people prefer adding comments while reviewing other people's work in Excel.

Here are the major differences in 'comments' and the 'track changes' functionality:

• You don't need to edit a cell's content in order to leave a comment. Track changes, on the other hand, would insert a note whenever there is any change in the cell.
• Adding comment is a manual process, while track changes, when enabled, would automatically record everything that happens in the worksheet.
• You can not get a list of all the comments separately in a worksheet (unless you use VBA as shown here) while you can get it with the tracking functionality with a simple click.
• When you enable track changes in Excel, some of the functionalities are disabled. This is not the case with comments.

You May Also Like the Following Tutorials:

• How to Use Spell Check in Excel.
• Using Input Message in Excel to Display Message when a Cell is Selected.

How Can I See Track Changes Comments if I Do Not Have Word Installed?

Source: https://trumpexcel.com/track-changes-in-excel/

Share this post