Page 275 - TP_IT_V1.0_C10_flipbpookl
P. 275
Edit Comment
The steps to edit comment in a spreadsheet are:
Step 1: Select the cell containing comment that you want to edit. To insert or edit comment
Step 2: Right-click on the selected cell and select the Edit Comment option. Short key in the spreadsheet:
It will take you again to the comment text box to make any changes. Ctrl + Alt + C
Step 3: Modify the comment in the text box.
Delete Comment
The steps to delete comment in a spreadsheet are:
Step 1: Select the cell containing comment that you want to delete.
Step 2: Right-click on the selected cell and select the Delete Comment option.
The comment from the cell is deleted.
Show or Hide Comment
When comments are visible, you will see all comments displayed on the cells they’re associated with. When comments
are hidden, the comments would not be displayed, but the indicators will still show which cells have comments
attached.
The steps to show comment in a spreadsheet are:
Step 1: Select the cell containing comment that you want to show.
Step 2: Right-click on the selected cell and select the Show Comment option from the context menu.
The comment is displayed in the spreadsheet.
You will notice that the Hide Comment option becomes active instead of the Show Comment option. This change
occurs because when comments are being displayed, they are already in show mode, which needs to be switched to
hide.
The steps to hide comment in a spreadsheet are:
Step 1: Select the cell containing comment that you want to hide.
Step 2: Right-click on the selected cell and select the Hide Comment option from the context menu.
The comment is hidden in the spreadsheet.
Format Comment
In LibreOffice Calc, you can format the text within the comment box and as well format the comment box.
To format the comment, perform the following steps:
Step 1: Select the cell containing comment that you want to format.
Step 2: Right-click on the selected cell and select the Show Comment option from the context menu.
The comment is displayed in the spreadsheet.
Step 3: Right-click on the comment box. A context menu appears that contains the various option for formatting a
comment box, such as Line, Area, Positing and Size, etc.
Electronic Spreadsheet (Advanced) using LibreOffice Calc 273

