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

Chapter 16. Sharing Workbooks > Tracking Changes

Tracking Changes

When sharing Excel workbooks, you can automatically track the changes made by the various users. In addition to marking each changed cell with an explanation of the change, you can review and then accept or reject each change.

To enable change tracking

1.
Choose Tools > Track Changes > Highlight Changes.

The Highlight Changes dialog box appears (Figure 16.9).

Figure 16.9. Specify criteria for tracking and displaying changes.


2.
Click the Track changes while editing check box.

Doing so simultaneously enables change tracking and sharing of the workbook.

3.
Set any of these tracking options, as appropriate:

  • When. Specify which changes to track, based on a time period or a save.

  • Who. Indicate whose changes to track.

  • Where. If you're interested in only a particular cell range, click this check box and drag-select the range.

4.
Modified cells will have a colored triangle in their upper-left corner. To view a change explanation, move the pointer over the cell (Figure 16.10).

Figure 16.10. To view the details for a given change, move the cursor over the changed cell.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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