Microsoft Office Tutorials and References
In Depth Information
Considering Your Collaboration Options
See Who Made
and When in
Before and After
Values Appear in
Filter Any Column in the
The entire history of your collaborative work
can be documented in a new sheet.
Your new History worksheet can be sorted
and filtered to display and organize the
data in any way you choose.
2. With your workbook saved, click the Review
tab, and click the Track Changes command to
display its drop-down menu.
To use the History sheet, review each sheet and
cell that is listed. You can use it to see which
changes you want to keep and which ones you
might want to change again or reject, returning
to the content prior to the collaborative process.
If your History sheet has an abundance of data
in it—row upon row of edited cells, some cells
changed multiple times by multiple people—
which might make it difficult to make decisions
at a glance, you can use the Data tab’s Sort and
Filter commands (discussed in Chapters 7 and 8,
respectively) to change the order in which the
listed changes appear, and to distill the list of
changes down to just the few you want to see—
perhaps only those in a certain range of cells or
performed by a certain person.
3. Choose Highlight Changes. The Highlight
Changes dialog box opens, as shown in
A newly available option appears in the Highlight
Changes dialog box—to create a new sheet listing all
changes made while Track Changes has been in use.
Redisplaying Your Changes
4. Check the box next to List Changes on a New
The History sheet does not remain after you
save the workbook. If you need to see your
listed changes again, you’ll have to repeat
Steps 4 and 5 in the previous procedure to
display the current list of changes.
5. Click OK. A new History worksheet appears,
and is now the active worksheet, as shown in