Formatting comments

Excel 2016 2013 2010 2007
Like a common text, any comments can be formatted: Excel represents many allows you to customize most aspects of its appearance, including color, border, and margins.
Examples of comments in Excel 2003

To format a comment, do the following:

   1.   Right-click the cell with comment and choose Edit Comment in the popup menu:

Cells popup in Excel 2003

   2.   Select the text in the comment.

   3.   Use the commands in the Formatting toolbar to make changes to the comment's appearance:

Text editing groups in Excel 2003

   4.   For even more formatting options, right-click the comment's border and choose Format Comment... from the shortcut menu:

Comment popup in Excel 2003

   5.   In the Format Comment dialog box, change the comment appearance, including color, border, and margins:

Format Comment in Excel 2003

To display an image inside a comment, follow next steps:

   1.   Right-click the cell and choose Edit Comment in the popup menu.

   2.   Right-click the comment's border and choose Format Comment....

   3.   In the Format Comment dialog box, on the Colors and Lines tab, click the Color drop-down list and select Fill Effects:

Comment color in Excel 2003

   4.   In the Fill Effects dialog box, click the Picture tab and then click the Select Picture button to specify a graphics file:

Fill Effects in Excel 2003

See also Changing a comment shape.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.