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

Chapter 17. Sharing Workbooks > Tracking and Reviewing Changes

Tracking and Reviewing Changes

You can share Excel workbooks with others and automatically track the changes they make. This makes managerial review especially convenient.

To set up change tracking:

1.
Choose Tools > Track Changes > Highlight Changes (Figure 17.23).

Figure 17.23. Choose Tools > Track Changes > Highlight Changes.


2.
In the Highlight Changes dialog box that appears, use the selections to determine which changes to highlight. To fill in the Where field, you can simply drag through the appropriate cells (Figure 17.24).

Figure 17.24. Choose which changes to track.


3.
Tracked cells display a colored triangle in the upper-left corner. To see a change notation, move the pointer onto the cell (Figure 17.25).

Figure 17.25. Move the pointer over a changed cell to see details.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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