4 Quick Tips To Customize a Cell Comment In Excel

A cell comment is like a small note which you can put add on a cell to deliver an important message.

Today, I will show you how can you customize it [4 ways] to add a plus to your data presentation.

Quick Navigation

Change Font Style

Text is the major part of a cell comment and you change it's font style as you can change in a cell.

  • To customize its font style, hold your cursor on the border of the cell comment and press right click.
  • After that, click on the “Format Comment” option.
change font style in a cell comment
  • From "Format Comment" window, you can change font type, style, size, color and add effects (strike through, superscript, subscript).
customize-cell-comment-with-text

Customize Cell Comment

Cell Comment is like a Small Note in Excel which you can put on the cell to deliver an important message related to that particular cell. 

By using customized cell comment you can add a plus to your data presentation.

Here, I have listed 4 useful tips to customize cell comment in excel which can help you to make best out this Presentation Weapon.

  • Change Font Style
  • Change Background
  • Insert Image
  • Change the Shape

How to Change Font Style In Cell Comment In Excel

The text is the major part of the cell comment. So, to customize cell comment you have to customize the text font.

To customize font style – hold your cursor on the border of the cell comment & press right click. After that, click on the “Format Comment” option. You will get a popup window.

change font properties in a cell comment

Now, you have options to change font type, style, size, color, add effects (strikethrough, superscript, subscript). This will allow you to customize the cell format in different ways.cell comment customization

Change Background

To change box color, open comment format option & go to color & lines tab. Select color from the color drop-down menu.

change box color

This will allow you to add different colors to the comment box.

add color to comment box

Insert Image

This is a very useful feature of the cell comment. You can add images to describe the content of the cell.

You can add images to describe the content of the cell.

To Add Pictures to your Cell Comment In Excel. Open format comment option, go to color & lines option. Click on the color drop down menu & then click on fill effects.

click on fill effect

Select picture tab and click on select picture to add the picture.

select picture

After selecting the picture, you can adjust its height & width are per your need.

add picture into the comment box

Change Shape

This is another useful option to customize cell comment by changing its shape. Unfortunately, this option is not in the format comment option.

But this is not the matter of worry, you can pull it by following simple steps.

Go to File Menu -. Options -> Quick Access Toolbar -> Select “Drawing Tools | Format Tab from the “Choose Command From” Option.

select drawing tool

Now, select “Change Shape” option & add it to the quick access toolbar.

add change shapes

This will add an option to your quick access toolbar to change shape.

change shape option

Now, select your comment & then select any of the shapes from the change shape option.

comment box with different shapes

Over To You

A Customize Cell Comment In Excel is a good tool to make you presentation effective.

Inserting an Image in a cell comment is the best part of the Cell Comment Customization.

You can also use other customizations where you need them.

Do you use cell comment in excel?

What do you think about these customizations in cell comment?

Share your views in the comment box?