Microsoft Office Tutorials and References
In Depth Information
Considering Your Collaboration Options
Considering Your Collaboration Options
Whenever more than one person is
working on a single Excel worksheet or
workbook, it’s important to keep things straight—who
added or changed the information, where they
got the information, and whether the additions
and changes are to be kept as they are, edited
further, or removed entirely. Much of the process
of collaborating on such a project is manual, in
that you’ll have to ask people to add or change
the information that they’re responsible for,
someone will have to review what’s been added
or changed, and there will have to be meetings
or some other communication between the
collaborators, to make sure everything’s going as
planned.
Track Changes
Options
Track Changes
Button
Figure 14-1
When collaborating on a worksheet, you’ll spend a
good deal of time in Excel 2010’s Review tab.
For Excel’s part, however, the process of tracking
who did what and when it was done is entirely
automatic—once you’ve turned on a feature
called Track Changes. As shown in Figure 14-1,
Track Changes is turned on via the Review tab’s
Track Changes command, through which you
can control how Track Changes works—whose
changes you want to track, which cells you want
to monitor, and whether or not to keep changes
a member of the team has made. But don’t
worry—while there are a lot of variables, Track
Changes is really simple to use.
Turning Track Changes
On and Off
To turn Track Changes on, simply open the
workbook you want to track, and from within
any of its worksheets, click the Review tab on
the Ribbon. As shown in Figure 14-2, the Track
Changes command presents a menu, from which
you can choose to Highlight Changes—this refers
to the very process of tracking changes, which
highlights those cells that are changed in any
way after Track Changes is turned on.
 
 
Search JabSto ::




Custom Search