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

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.