• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Tracking Changes

Tracking Changes

Open the Tools menu, choose Track Changes, and select Highlight Changes to open the Highlight Changes dialog box.

Click the Track Changes While Editing. This Also Shares Your Workbook checkbox to select it.

The Highlight Which Changes options become available; click OK to accept the default change options.

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, you can use Excel's Track Changes feature; that way, each person's edits appear in a different color. An edit can be changing the current information or adding completely new information to the workbook. (The only time the colors won't be different is when two people use the same computer or user information—such as login or password.)


Excel notifies you that the workbook will be saved; click OK. The workbook is now shared, with Track Changes enabled.

Type a change in a cell and press Enter. The upper-left corner of the cell now contains a Track Changes marker, and 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

Stopping sharing/tracking

The word [Shared] in the title bar of your workbook indicates that other people can use it. This is mostly useful in a network setting, where others can easily access your worksheet via the network. When you turn on Excel's Track Changes feature, you automatically share the workbook. To disable sharing and tracking, open the Tools menu, choose Track Changes, and select Highlight Changes to open the Highlight Changes dialog box. Then, deselect the Track Changes While Editing… check box and click OK.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint