Microsoft Office Tutorials and References
In Depth Information
Considering Your Collaboration Options
Where. This option allows you to type a
cell or range of cells into the field, or you
can click the Collapse button at the right
end of the field to shrink the dialog box.
Once shrunken, as shown in Figure 14-5,
you can click and drag through cells in
your worksheet to specify a range of cells
to be tracked. You can click any other
worksheet in the workbook (note that the
sheet name appears in the field if you do
so), and once you’ve selected a range of
cells to track, press Enter to display them
in the dialog box, as shown in Figure 14-6.
Tracking the Whole Workbook
If you don’t make any selection in the
Where box, the entire workbook will be
tracked—so you only need to specify a range
if you want to restrict the tracking to that
range of cells.
Highlight Changes Onscreen. This option
is turned on by default, and simply means
that you want some kind of visual
notification that Track Changes has detected a
change to a cell or cells within the
specified range. As shown in Figure 14-7, once
a cell has been changed, a blue triangle
appears in the upper-left corner of the
cell, and if you mouse over the cell, a
comment bubble pops up to indicate who
made the change, when it was made, and
what the change consisted of.
Shrink the dialog box to give yourself more
elbowroom for selecting the cells you want to track.
Mouse over a highlighted cell to find out what
was done to change that cell’s content.
Once you’ve picked the worksheet and range of
cells within it to track, your selection appears in the
dialog box, where you can tweak it as needed.