Track Editing Changes in Excel

BY STANLEY ZAROWIN

Q. Word has a convenient tool under Tools called Track Changes . I remember in the old days we called that function red lining and it kept track of every change made in a document and then let us choose whether we wanted to keep the changes. I wish we could do that in Excel.

A. You can. In fact, it works the same way and you’ll find it in the same place in Excel—under Tools .


When you edit a cell in the Track Changes mode, Excel outlines the cell in blue and puts a blue triangle in the upper-left corner. And when you position the mouse pointer over the edited cell, Excel displays a comment indicating what change was made.

To launch Track Changes , click on Tools and then Track Changes . That brings up this menu:


When you’re ready to determine which changes to finally accept, click on Track Changes and on Accept or Reject Changes and you will be offered this menu:


After you’re done Excel still shows edited cells with the blue border and tracking changes indicator. The only way to get rid of them is to turn off Track Changes by going back into it through the Tools menu and unchecking the box.


Be aware that Excel is keeping track of only the last edit made. If you want a complete history of changes, you must instruct Excel to keep a complete tracking history on a separate revisions worksheet. To do that place a check in the box List changes on a new sheet.

SPONSORED REPORT

Get your clients ready for tax season

These year-end tax planning strategies address recent tax law changes enacted to help taxpayers deal with the pandemic, such as tax credits for sick leave and family leave and new rules for retirement plan distributions, as well as techniques for putting your clients in the best possible tax position.

RESOURCES

Keeping you informed and prepared amid the coronavirus crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.