Microsoft Office Tutorials and References
In Depth Information
Considering Your Collaboration Options
5. In the resulting Accept or Reject Changes
dialog box (shown in Figure 14-14), view the
changes as they are displayed one at a time—
clicking the Accept or Reject button to move
through them individually.
If you want to restrict the reviewing
process to a certain sheet or range of
cells, simply click in the Where field
(or click the Collapse button at the far
right end of the field to collapse the
dialog box temporarily) and then move
your mouse out onto the workbook to
select a sheet and then select cells
within that sheet. Once you’ve made
your selection, expand the dialog box
(if you collapsed it).
4. With your settings in place, click OK.
Review your changes, one at a time—or not.
You can also make a sweeping decision
and not view all the changes individually,
by clicking Accept All or Reject All. You
can also Close the dialog box without
making any acceptances or rejections,
at any point in the process.
6. To end the process before reviewing all the
edited cells, click Close. Otherwise, if you
accept or reject all the edits (one at a time or
using the All-version buttons), the dialog box
closes on its own.
You Can Review Some Changes Later
You can use this process to review just a few of the edited cells, by making Accept or Reject decisions
one at a time and then clicking Close to leave the rest undecided (for now), and come back to them
later. There’s no requirement that you review and decide on all the changes just because you’ve started
this process. As long as Track Changes remains on, your contributors’ changes will continue to be
tracked and highlighted, and you can review them at any time. If you decide to use the History sheet
as your reviewing tool, when you’re ready, you can use the previous steps to open the Accept or Reject
Changes dialog box and then click Accept All or Reject All.