Editing and Deleting Comments and Unknown Members

You can edit comments and unknown members using the Comment Edit dialog.

Before you begin, complete the steps in Enabling Comment Display in the Sheet.

Note:

The procedure in this topic shows you how to edit comments on an ad hoc sheet using the View Comments command and the Comment Edit dialog box in Smart View. You can also edit comments directly in the grid, without using the Smart View interface elements in this topic.

To edit and delete comments on an ad hoc grid:

1. Open an ad hoc grid containing comments, and click Refresh.

   In the example shown below, the grid displays some comments in the sheet.

   Figure 9-10 Grid Showing Cells Marked with Comment Style

   
2. In the Extensions menu, select Smart View for Google Workspace, and then select Ad Hoc.
3. Select Data, More, and then select View Comments.

   The Comment Edit dialog box is launched.

   Based on the grid in the above example, the Comment Edit dialog shows the comments present in the sheet which can be edited.

   Figure 9-11 Comment Edit Dialog

   
4. To edit the text in a comment cell, in the Comment Edit dialog, click in the comment cell text box to edit; and then modify the text as required.

   Using the example Comment Edit dialog, click in the "Total Entities" comment cell text box, and then change "Total Entities" to "Total Entity".

5. Click Apply Changes and note the change in the grid.

   Cells that were edited are now marked in the dirty cell style.

6. Click Refresh; the dirty cell style is cleared in the cells you edited and the appropriate cell style is applied.
7. To delete comments:
   1. Launch the Comment Edit dialog, click in the comment cell text box to highlight the editable text; and press the Delete key.
   2. Click Apply Changes in the Comment Edit dialog to return to the ad hoc grid sheet.
   3. Click Refresh.