Microsoft Office Tutorials and References
In Depth Information
to your worksheet
A comment is a bit of descriptive text that enables
you to document your work when you add text or
create a formula. If someone else maintains your
worksheet, or others use it in a workgroup, your
comments can provide useful information. You can
enter comments in any cell you want to document or
Comments in Excel do not appear until you choose to
view them. Excel associates comments with
individual cells and indicates their presence with a
tiny red triangle in the cell’s upper-right corner. View
an individual comment by clicking in the cell or
passing your cursor over it. View all comments in a
worksheet by clicking the Review tab and then
clicking Show All Comments.
When you track your changes, Excel automatically
generates a comment every time you copy or change
a cell. The comment records what changes in the
cell, who makes the change, and the time and date
of the change. To learn more about tracking changes,
see Task #34.
A DD A C OMMENT
Click in the cell to which you
want to add a comment.
Click the Review tab.
Click New Comment in the
A comment box appears.
A tiny red triangle appears in the
upper-right corner of the cell.
Type your comment.
Note: To apply bold and other
formatting effects, select the text,
right-click, click Format Comment,
and then make changes as
Click outside the comment box
when you finish.
The comment box disappears.
Move the cursor over the cell to
display your comment again.