Open the Tools menu and select Track Changes, Highlight Changes. The Highlight Changes dialog box opens.
Click the Track Changes While Editing check box to select it.
The Highlight Which Changes options become available; click OK to accept the default options.
Excel notifies you that the workbook will be saved; click OK. The workbook is now shared with Track Changes enabled.
INTRODUCTION
Suppose you're working on a team project and each member has access to the same workbook. To keep track of who makes what changes to the workbook, use Excel's Track Changes feature; each person's edits appear in a different color. An edit can be changing the current information or adding new information to the workbook.
TIP
No Track Changes While Editing Check Box?
If you already performed the steps in the task "Protecting and Sharing Workbooks" to protect your worksheet, the Track Changes While Editing check box featured in step 2 of this task will not be available because Excel's Track Changes feature has already been enabled.
Notice that [Shared] is displayed next to the workbook filename. Type a change in a cell and press Enter.
The upper-left corner of the cell in which you typed now contains a comment marker (the blue triangle), and the cell is surrounded by a colored border.
Move the mouse pointer over the revised cell. A ScreenTip appears, showing the change that was made, who made the change, and when.
TIP
Rejecting Changes
If a member of your team has changed the value in a cell in error, you can reject the change; see the next task to learn how.
TIP
Stop Sharing/Tracking
Notice the word [Shared] in the title bar of your workbook, which indicates that other people can use it. This is useful in a network setting, in which others can access your worksheet via the network. When you turn on Excel's Track Changes feature, you share the workbook. To disable sharing and tracking, open the Tools menu and select Track Changes, Highlight Changes. In the Highlight Changes dialog box, deselect the Track Changes While Editing check box.