Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Adding notes"

Latest revision as of 21:14, 15 July 2018

Calc provides another type of comments (formerly called "notes"), which authors and reviewers often use to exchange ideas, ask for suggestions, or brainstorm in the document.

To add a comment:

1. Select the cell that the comment applies to.
2. Select Insert > Comment or right-click and select Insert Comment. The box shown in the figure below appears.
   

   

   Inserting a comment
3. Type the text of your comment in the box.
4. Click outside the box to close it.

Now the cell to which you added the comment has a colored dot in the upper right-hand corner. It does not have a colored border, unless the cell was also changed.

Colored dot in cell containing a comment

You can change the colors Calc uses for comments by selecting Tools > Options > OpenOffice.org > Appearance.

To view the comment you just added, hover the mouse pointer over the cell that has a comment; the comment appears.

Viewing a comment

Editing comments

You can edit and format the text of a comment, just as you do for any other text.

1. Right-click on the cell containing the comment marker, and choose Show Comment from the pop-up menu.
2. Select the comment, then double-click on it. The cursor changes to the usual blinking text-entry cursor, and the Formatting toolbar changes to show text attributes.
3. When done, click outside the comment to deselect it. To hide the comment again, right-click on the cell and deselect Show Comment on the pop-up menu.

Formatting comments

You can change the background color, border style, transparency, and other other attributes of a comment.

1. Right-click on the cell containing the comment marker, and choose Show comment from the pop-up menu.
2. Click on the comment itself. The Formatting toolbar changes to show many of the comment formatting options. These are the same as the options for formatting graphics; see Graphics in Calc for more information.
   You can also right-click on the comment to see a menu of choices, some of which lead to dialogs in which you can fine-tune the formatting; these dialogs are also discussed in Graphics in Calc.
3. When done, click outside the comment to deselect it. To hide the comment again, right-click on the cell and deselect Show Comment on the pop-up menu.

Finding comments using the Navigator

The small comment markers in the corners of cells can be difficult to see, so Calc provides another way to find them, by using the Navigator. If any comments are in the spreadsheet, the Navigator shows a mark (usually a + or an arrow) next to the word Comments. Click on this mark to display a list of comments. Double-click on the comment you want to jump directly to the cell it is associated with.