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

Part 8. Editing Worksheets > Tracking Changes

Tracking Changes

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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