Comments in Calc - LibreOffice 6-4

From The Document Foundation Wiki
Jump to: navigation, search
Other languages:
Deutsch • ‎English


"Comments in Calc"
"Comments edited in Calc"

The video "Insert comments in Calc - LibreOffice 6.4" on Windows 10 shows how comments are inserted and edited in Calc. It links to this page here, which contains further information and details.

Link to the Video

Link to the Video: "Insert comments in Calc - LibreOffice 6.4" Video in Work
Link to the Video (in German-DE): "Kommentare einfügen in Calc - LibreOffice 6.4

Insert and edit comments

To work with the comment functions, open Calc and here in the example the working file comments in Calc.ods.

Note: A blue arrow leads from a visible comment field to the cell, in which the comment was created. In this way, the relationship between cell and comment is always visible.

Insert a comment in a cell

We now add a comment to a cell. We right-click on the cell that we want to add a comment to. In the menu that appears we select Insert Comment.
A yellow field appears, this is the comment field. The cursor flashes in the comment field. We can now directly write the desired comment. E.g. we write: "I am currently writing my comment".

Show existing comments

The cells with a small red square in the top right (Example: 202005 LOENHB red square.png already have a comment. If you move the mouse pointer to such a cell, the comment of the cell is displayed.

Display comment permanently

Comments can also be displayed permanently. This is done by right-clicking on such a cell - a context menu opens. There you can select Show Comment. Then the comment is now displayed permanently.

Edit a comment

We can now edit the comment field and the comment. We click with the right mouse button in the cell and select Show Comment. Then we click with the right mouse button in the cell and select Edit Comment. We click in the comment field. We can now make the comment field larger or smaller. With a double click in the comment field we can edit the text. We mark the text and choose the font, e.g. Arial, and font size 16.

Move comment field

To be able to move a comment field, it must be displayed permanently. You click in the comment field so that it is marked. The cursor now has the shape of a four-way arrow. Vierrichtungspfeil.png The comment field can be moved with hold and drag.

Hide comment

If the comment is not to be displayed permanently, you can right-click in the cell and select Hide comment.

Delete Comment

We click with the right mouse button in the cell and select Delete Comment.

Further information

Work files

Start file: "Comments_in_Calc.ods"
File with additionally inserted comment: "Edited_comments_in_Calc.ods"

Documentation / Manuals

Documentation / Manuals

Any questions?

For questions on this topic go to Ask.LibreOffice