Excel® 2013 On Demand

Tracking Workbook Changes

As you build and fine-tune a workbook—particularly if you are sharing workbooks with co-workers—you can keep track of all the changes that are made at each stage in the process. The Track Changes feature makes it easy to see who made what changes and when, and to accept or reject each change, even if you are the only user of a worksheet. When you or another user applies the Track Changes command to a workbook, the message “[Shared]” appears in the title bar of the workbook to alert you that this feature is active. To take full advantage of this feature, turn it on the first time you or a co-worker edits a workbook. Then, when it’s time to review the workbook, all the changes will be recorded. You can review tracked changes ...