Microsoft Office Tutorials and References
In Depth Information
Excel makes it easy for you and your colleagues to insert comments in workbook cells.
Those comments can add insights that go beyond the cell data; for example, if a regional
processing center’s package volume is exceptionally high on a particular day, the center’s
manager can add a comment to the cell in which shipments are recorded for that day, and
note that two very large bulk shipments accounted for the disparity.
When you add a comment to a cell, a flag appears in the upper-right corner of the cell.
When you point to a cell that contains a comment, the comment appears in a box next to
the cell, along with the user name of the person who was logged on to the computer on
which the comment was created.
IMPORTANT Note that the name attributed to a comment might not be the same as the
name of the person who actually created it. Access controls, such as those that require users to
enter account names and passwords when they access a computer, can help track the person
who made a comment or change.
You can add a comment to a cell by clicking the cell, clicking the Review tab, and then
clicking New Comment. When you do, the comment flag appears in the cell, and a comment
box appears next to the cell. You can enter the comment in the box and, when you’re done,
click another cell to close the box.
If you want a comment to be shown the entire time the workbook is open, click the cell that
contains the comment, click the Review tab and then, in the Comments group, click Show/
Hide Comment. You can hide the comment by clicking the same button when the comment
appears in the workbook, and delete the comment by clicking the Review tab and then, in
the Comments group, clicking Delete. Or you can open the comment for editing by clicking
Edit Comment in the Comments group.