Excel 2010 tracking changes made to a worksheet

Excel provides a change tracking tool that makes it easier for groups of people to work together. Change tracking makes sure that the changes made by different people are carefully logged, giving you the power to inspect each person’s changes individually and reverse them if you choose. It’s a little like keeping several versions of the same worksheet in a single spreadsheet file.

Switching On Change Tracking
To turn on change tracking, follow these steps:

1. Select Review➝Track Changes➝Highlight Changes.
The Highlight Changes dialog box appears.

2. Turn on the “Track changes while editing” checkbox.
When you turn on change tracking, you also automatically switch on workbook sharing a separate feature, which will be discussed in some other post. As there’s no way to turn on change tracking without also turning on workbook sharing.

3. Ignore the Who, When, and Where checkboxes for now, and click OK to return to your worksheet.

To see how change tracking works, just enter text in a new cell or edit an existing cell. Excel uses several visual indicators to show that a cell has been changed. Most obviously, it draws a blue outline around the cell and adds a small blue triangle to the cell’s top-right corner. Additionally, Excel changes the column headers at the top of your sheet to use red text if that column or row contains changed data. To get the specifics about the change, you can hover over the cell with your mouse. When you do, a yellow box appears that looks just like a comment box.

Excel doesn’t track every possible change. In fact, it ignores the following changes:
• Formatting changes (like when you change the font or background color of a cell)
• Hiding or unhiding rows or columns.
• Adding, changing, or deleting comments.
• Inserting or deleting worksheets.

Changes don’t remain in the change history log forever. In fact, once 30 days have
passed since a change was made, Excel discards it from the log.

You can also clear changes from the change history log —by turning off change
tracking altogether. Just choose Review➝Track Changes➝Highlight
Changes to show the Highlight Changes dialog box, and turn off the checkmark in
the “Track changes while editing” checkbox. You can turn change tracking back on
later, but you can’t recover the information about the changes you made earlier.

To highlight the changes made to a document, go to Review➝Track
Changes➝Highlight Changes.


What you do next depends on the types of changes you want to see. Here are some
of your choices:

Show all changes

Show recent changes

Show changes in a specific date

Show changes that haven’t been reviewed

Show changes made by a specific person

Show changes made in specific cells

This article showed you on how to enable change tracking and view changes, in the upcoming articles i will be talking about accepting rejecting these changes and merging the changes made by many authors on a workbook while it was shared with them.

  • http://crohnsdisease.tk Camille Setzler

    It’s hard to come by decent info on the web.

  • http://eye-mask.org Isidro Nakanishi

    Mind if I use some of the information from this post if I provide a link back to your site?

  • http://www.facebook.com/david.r.crutchfield David R. Crutchfield

    I am able to turn on track changes and the workbook remembers those changes but I cannot get the workbook to; 1) keep the changes highlighted after saving and opening. I can go to Track Changes button and the When: is checked but it shows “Since I last saved”. I change it to All and then all the changes are highlighted. 2) the history tab (“List changes on a new sheet”) does not save. So not only are the changes not highIighted when I open the workbook, but the History tab is missing too. I tried e-mailing the workbook while the tab is showing but the resulting attachment will not open – Excel says it is corrupt. Yes, I am using Excel 2010. Workbook is a new, blank one that I typed into, saved locally, opened, shared, and turned on track changes. Then I tried everything I know how to make it work and have been searching through the internet to no avail – it appears no one else is having this problem except I am working on this problem for someone else who is having the same problem on their computer. They want to e-mail the workbook to someone and not have to give them a long list of instructions on how to find the changes.

  • three_toe

    nope, everybody is having these problems because MS’s attempt at implementing this feature probably lasted about 20 minutes and then that specific intern was fired for failing a drug test.

  • arrowhot

    They ought to just go look at Microsoft Word for an example of how to track changes. drug test……lol.

  • drconrad

    how can I change the name in track changes

  • Manny

    Hi There, I did turn on track changes in excel 2013 and worked seamlessly however when I re-open the file , tracker doesn’t exist. I cannot see any changes.

  • Manny

    Is there a way where cell colour changes if a user made an amendment?