About comments

A comment is a note that you attach to a cell, separate from other cell content. Comments are useful as reminders to yourself, such as noting how a complex formula works, or to provide feedback to other users.

Viewing comments Microsoft Excel provides several ways to view comments. Cells with comments have indicator triangles in the upper-right corners. If you rest the pointer over a cell that has an indicator, its comment appears. You can also display comments continuously— either individual comments or all the comments on the worksheet. The Reviewing toolbar steps you through each comment in a workbook in sequence. You can also print out the comments, either in place on the worksheet or as a list at the end of the printout.

User names in comments Comments are identified by user name, so that you can tell who entered each comment in a shared workbook(shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users. You must have Excel 97 or later to modify a shared workbook.) or a workbook being routed to several users for review. When you merge changes from several workbooks, the comments are also combined so all comment text for a cell appears in sequence.

Add a comment to a cell

Comments are notes that you enter for a cell.

1.  Click the cell you want to comment on.

2.  On the Insert menu, click Comment.

3.  In the box, type the comment text.

If you don't want your name in the comment, select and delete the name.

4.  When you finish typing the text, click outside the comment box.

Note When you sort, comments are sorted along with the data. In PivotTable reports, however, comments do not move when you change the layout of the report.

Print comments

1.  Click the worksheet.

2.  If you want to print the comments in place on the worksheet, display the comments you want to print.

To display an individual comment, right-click its cell and then click Show Comment on the shortcut menu. To display all comments, click Comments on the View menu. Move and resize any overlapping comments as necessary.

How?

1.  Click the border of the comment box so that handles appear:

2.  Do one or more of the following:

To move the comment, drag the border of the comment box.

To change the size, drag the handles on the sides and corners of the comment box.

3.  On the File menu, click Page Setup, and then click the Sheet tab.

4.  Do one of the following:

To print the comments where they appear on the worksheet, click As displayed on sheet in the Comments box.

To print the comments at the end of the sheet, click At end of sheet in the Comments box.

5.  Click Print

From Excel XP help menu