Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
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.
Text is the major part of a cell comment and you change it's font style as you can change in a cell.
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.
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.
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.
To change box color, open comment format option & go to color & lines tab. Select color from the color drop-down menu.
This will allow you to add different colors to the comment box.
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.
Select picture tab and click on select picture to add the picture.
After selecting the picture, you can adjust its height & width are per your need.
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.
Now, select “Change Shape” option & add it to the quick access toolbar.
This will add an option to your quick access toolbar to change shape.
Now, select your comment & then select any of the shapes from the change shape option.
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?