Format worksheet comments

When you add a comment to a cell, Excel automatically uses the Tahoma style font in size 9. You can change the formatting for a comment or change the default format for all comments.

  1. To change the format for an individual comment, right-click the cell with the comment and choose Edit Comment.

  2. Select the text you want to reformat, right-click it, and then choose Format Comment.

    format options for comments
  3. Choose the font options you want and click OK.

    Options to change the comment fonts,

In this example, we've changed the font style, size and color of the comment.

view of comment with changed font formatting.

To use the same font formats for all comments, change the default Tool Tips options from your Windows settings. Use the following steps for the version of Windows on your computer.

Change default font for comments in Windows 8

In Windows 8, you can change the font size and make the comment text bold.

  1. Press the Windows key + M to go to your desktop.

  2. Right click on the desktop and choose Personalize.

  3. Click Display at the bottom left.

  4. Under Change only the text size, click the arrow and choose Tooltips. You can change the font size and make the text bold.

    Windows 8 ToolTips format settings
  5. Click Apply to accept the changes.

    Note: The changed default formatting is applied only to new comments and doesn't change the format for existing comments.

Change default font for comments in Windows 7

In Windows 7, you can change the comment text size and color.

  1. Press the Windows key + M to go to your desktop.

  2. Right click anywhere on the desktop and choose Personalize.

  3. Click Window Color and click Advanced appearance settings.

  4. In the Window Color and Appearance box, under Item, pick ToolTip from the list. Change the font and color setting, and click OK.

  5. Click Save Changes in the Window Color and Appearance window.

Note: The changed default formatting is applied only to new comments and doesn't change the format for existing comments.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×