Chapter
Chapter
1
1
1
3
3
3
3

Collaborating
with Other
People
Although you will most often
create and edit an Excel
workbook on your own, you
may have some workbooks
that require input from other
people. For those times when
you need to collaborate with
other people on a workbook,
Excel has the tools to get the
job done.
In this chapter, you learn
many ways to collaborate on
a workbook, including adding
comments to a cell, sharing a workbook, e-mailing a workbook, and even
working on a spreadsheet online. You also learn ways to make collaboration safer
by protecting any data you do not want changed, tracking whatever changes are
made by others, and accepting or rejecting those changes.
15_577639-ch13.indd 21015_577639-ch13.indd 210 3/15/10 2:49 PM3/15/10 2:49 PM

4
Type your comment.
5
Click outside the comment
balloon.
Add a Comment
1
Click the cell you want to
comment on.
2
Click the Review tab.
3
Click New Comment ( ).
Note: You can also right-click
the cell and then click Insert
Comment.
Add a Comment to a Cell
If you have received a workbook from another
person, you can provide feedback to that
person by adding a comment to a cell in the
workbook. A comment is often the best way to
give feedback because it does not change
anything on the worksheet itself.
Comments are attached to a particular cell, and
Excel displays an indicator on any cell that has
a comment. When you hover your mouse
pointer over such a cell, Excel displays the
comment in a balloon.
Add a Comment
to a Cell

) and
Previous (
) to run through
the comments.
•
In the Review tab, you can
also click Show All Comments
(
) to display every comment
at once.
•
Excel adds a comment
indicator (
) to the top
right corner of the cell.
How do I change my Excel user name?
When collaborating, your user name is
important because it tells other people
who added the comments. If your current
user name consists of only your first name
or your initials, you can change it. Click
File and then click Options to open the
Excel Options dialog box. Click the
General tab and then use the User name
text box to edit the name. Click OK. Note,
however, that this does not change your
user name in any existing comments.
15_577639-ch13.indd 21315_577639-ch13.indd 213 3/15/10 2:49 PM3/15/10 2:49 PM
214
11

to unprotect it.
There are two main methods you can use to
safeguard worksheet data: You can unlock
only those cells that users are allowed to edit,
and you can configure a range to require a
password before it can be edited.
Protect a
Worksheet’s Data
15_577639-ch13.indd 21415_577639-ch13.indd 214 3/15/10 2:49 PM3/15/10 2:49 PM