Enabling Comment Display in the Sheet

You can set options in Smart View to detect comments and unknown members on an ad hoc sheet.

To enable comment display in an ad hoc sheet:

1. In the Options panel, perform these tasks:
   1. In Members tab, select the Preserve Formulas and Comments in Ad Hoc and Preserve Comments and Unknown Members check boxes.
   2. In the Formatting tab, select the Use Cell Styles check box.
   3. Click the Cell Styles button, expand Miscellaneous Styles, and then click on Comment. Drag the color controls (the circles in the top left corner of each color block) till you arrive at the color you want.
      
      
2. Click X in the top right corner to close the Options panel.

   You are now ready for the steps in Viewing Comments in the Sheet.

   Optionally, to view the Comment Edit dialog with every refresh, complete the steps in Displaying the Comment Edit Dialog on Refresh.