Displaying the Comment Edit Dialog on Refresh

You can configure an option to display the Comment Edit dialog each time you refresh the sheet.

Note:

This procedure is optional.

To enable comment display in the sheet upon refresh:
  1. Place an ad hoc grid on the sheet.
  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.
  4. In the Comment Edit dialog, select the Always show on refresh check box.

    Figure 9-8 Comment Edit Dialog


    Comment Edit dialog box
  5. Click Apply Changes.

    The Comment Edit dialog will display each time you refresh the grid.

    The Always show on refresh check box applies not just for the current worksheet but for any new worksheets you open subsequently. You do not have to set it on a per-sheet basis.

  6. Optional: To disable the Comment Edit dialog display on refresh, clear the Always show on refresh check box.