Microsoft Office Tutorials and References
In Depth Information
Track and Review Worksheet Changes
Track and Review
Worksheet Changes
Tom’s W orkshe et
M ay 2
Ma y 5
May 8
May 11
XL
If you share your Excel workbooks with others,
you can use the program’s Track Changes feature
to help you keep track of what edits others have
made, including formatting changes and data
additions or deletions. The Track Changes feature
uses different colors for each person’s edits,
making it easy to see who changed what in the
workbook. When you review the workbook, you
can choose to accept or reject the changes.
101.50
116.20
120.21
98.94
101.55
98.21
10 0.27
101.00
95.26
100.25
11 6.23
May 8
May 11
110. 22
May 20
May 24
Ma y 30
M
113.30
114 .78
Track and Review Worksheet Changes
Turn On Tracking
1 Click the Review tab on the
Ribbon.
2 Click the Track Changes
1
3 2
.
3 Click Highlight Changes .
The Highlight Changes dialog box
appears.
4 Select the Track changes while
editing check box.
4
This option automatically creates
a shared workbook file if you
have not already activated the
Share Workbook feature.
5
You can select options to choose
when, by whom, or where you
track changes.
You can leave this check box
selected to view changes in the file.
5 Click OK.
182
 
Search JabSto ::




Custom Search