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
   270   271   272   273   274   275   276   277   278   279   280