Microsoft Office Tutorials and References
In Depth Information
Track Workbook Changes
Whether you are a company employee, a
consultant, or a freelancer, you will almost
certainly work with other people in one
capacity or another. Most of the time, your
work with others will be informal and consist
of ideas exchanged during meetings, phone
calls, or e-mail messages. However, you may
often be called upon to work with others more
closely by collaborating with them on a
One way to do this is to ask another person to
make changes to a workbook. This method can
save you a lot of time and effort, but it can also
lead to problems if you do not know what
parts of the document the user edited. For
example, if you do not know what the user
changed, you have no way of checking the
changes for errors.
When you turn on the Excel Track Changes
feature, the program monitors the activity of
each reviewer and stores their cell edits, row
and column additions and deletions, range
moves, worksheet insertions, and worksheet
renames. You can also filter the changes by
date, reviewer, or worksheet location.
1 Open the workbook you
want to use for the
2 Click the Review tab.
3 Click Track Changes.
4 Click Highlight Changes.
The Highlight Changes
dialog box appears.
5 Click to select the Track
Changes while Editing
To filter the displayed
changes by time, click to
select the When check
box and then use the
drop-down list to specify
the time interval.