Videos/Comments in Calc

Foreword




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 (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
Now add a comment to a cell.

Right-click on the cell that you want to add a comment to.

In the menu that appears select [[Media:202005_LOENHB_menu context_Insert Comment.png|]].

A [[Media:202005_LOENHB_yellow field.png|yellow field]] appears, this is the [[Media:202005_LOENHB_Comment still empty.png|comment field]].

The cursor flashes in the comment field.

You can now directly write the desired comment.

E.g. write: "I am currently writing my comment".

Show existing comments
The cells with a small red square in the top right (Example: ) already have a comment.

If you move the mouse pointer to such a cell, the [[Media:202005_LOENHB_a Comment.png|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 and a context menu opens.

There you can select [[Media:202005_LOENHB_menu context_Show Comment.png|]].

Then the comment is now displayed permanently.

Edit a comment
You can now edit the comment field and the comment.

Click with the right mouse button in the cell and select [[Media:202005_LOENHB_menu context_Show Comment.png|]].

Then you click with the right mouse button in the cell and select [[Media:202005_LOENHB_menu context_Edit Comment.png|]].

Click in the comment field.

You can now make the comment field [[Media:202005_LOENHB_Make comment larger.png|larger or smaller]].

With a double click in the comment field you can edit the text.

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.

The comment field can be moved with click-hold-drag.

Hide comment
If the comment is not to be displayed permanently, you can right-click in the cell and select [[Media:202005_LOENHB_menu context_Hide Comment.png|]].

Delete Comment
Click with the right mouse button in the cell and select [[Media:202005_LOENHB_menu context_Delete Comment.png|]].

Work files
Start file:

[[Media:Comments_in_Calc.ods|"Comments_in_Calc.ods"]]

File with additionally inserted comment:

[[Media:Edited_comments_in_Calc.ods|"Edited_comments_in_Calc.ods"]]

Documentation / Manuals
Here you will find the Documentation / Manuals:

Documentation / Manuals

Any questions?
For questions on this topic go to:

Ask.LibreOffice

Get Involved
Join us today and help us to make it even better!

Get Involved

Donate
LibreOffice is Free Software and is made available free of charge.

Your donation, which is purely optional, supports our worldwide community.

If you like the software, please consider a Donation.