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 the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out