Add Formatting to Comments in Excel

Add to Favorites

How to format the appearance of a comment and the text within it.

Sections:

Format Text within a Comment

Format the Comments Appearance

Access All Formatting and Adjustment Options for Comments

Notes

Format Text within a Comment

Format the appearance of the text in the comment.

  1. Right-click the cell that contains the comment and click Edit Comment. This makes it easier to work with.
  2. The comment should now be visible and editable; select the text in the comment.
  3. Go to the Home tab and you can change basic text elements, such as size, font, bold, underline, alignment, etc. Make sure to separately select the parts of the comment to which you would like to apply different formatting, such as font size.

Format the Comments Appearance

This includes changing the font color, adding background colors, designs, and other features.

  1. Right-click the cell that contains the comment and click Edit Comment

  2. Right-click the border of the comment and then click Format Comment...; the border is the thick spotted line around the comment.
  3. A window will open with many options for changing a comment's appearance.
  4. The best thing to do is to play around with this window for a while to see what kind of affects you might want for your comment.
    The most-used features are on the Colors and Lines tab. There, you can add some color to the background of the comment, change the border color, add transparency to the comment, and more. These three particular options allow you to make subtly nice looking comments which do not interfere with the usage of the spreadsheet as much as do the default comments.

Sample Formatted Comments:

Access All Formatting and Adjustment Options for Comments

Right-click the cell containing the comment > Click Edit Comment > Right-click the border of the comment > click Format Comment...

In the window that opens, you have access to all of the changes that can be made to a comment, its text, and its appearance.

Notes

Formatting comments can really help make your workbook look A LOT better; this is because Excel's default formatting for comments is incredibly intrusive and quite annoying. Play around with the formatting options for comments to find a suitable look for your workbook.

Download the sample Excel workbook attached to this tutorial to see the examples used here.


Downloadable Files: Excel File

Similar Content on TeachExcel
Add Background Photos / Images to Comments in Excel
Macro: Add background images and photos to your comments in Excel with this macro. This macr...
Add Notes and Comments to Cells in Excel
Tutorial: Did you know that you can add notes and comments to any cell in Excel?  You can write rem...
Get Comment Text from Cell Comments in Excel - UDF
Macro: This free Excel UDF outputs all text from a comment in Excel. This benefit of this UDF is ...
Delete Comments in Excel - Permanently Remove Specific Comments from Excel
Macro: Delete a comment in Excel with this macro. You can permanently remove or delete a specific...
Get Text from Comments in Excel Including the Author of the Comment - UDF
Macro: Output all text from a cell comment, including comment author, with this UDF in Excel. Thi...
Hide Comments in Excel Completely - Even Indicators Will not Appear
Macro: Hide all comments in an Excel workbook. No indicators will be displayed and comments will ...