Adding Data, Charts, or Other Information to a Cell Comment

In this article, we are going to learn how to add data, charts and other information in a cell comment in Microsoft Excel.

To add data, charts or other information to a cell comment, you can use the Format Comment.

What is Format comment?

Format Comment: – This option is used to change the text font or color, background color, border color and thickness. It can also format the comment to make it dashed or insert a picture, etc.

Let’s take an example to understand

We have sales data. We will insert the comments and, one by one, we will learn 3 types of inserting options of cell comment.

image 1

 

How to insert image in cell comment?

Follow below steps

  • Select a cell, press Shift+F2 to add a new comment.If a comment is already present in the cell, then press Shift+F2 to edit that existing Comment

image 2

 

  • Select the edge of the comment so that it is surrounded by dots, not slashes
  • Right-click on the comment edge, and from Format Comment, select Colors and Lines

image 3

 

  • In the Fill section, open the Color box
  • Choose Fill Effects, click the Picture tab, and then click on Select Picture

image 4

 

  • Select a picture and click on OK twice

image 5

 

image 6

 

image 7

 

 

How to insert chart in cell comment?

Follow the below given steps:-

  • To add the chart to a cell comment, ensure that you have a chart in Excel
  • Select the chart and save it as image at your desktop or as per your convenience
  • We will use the Snipping tool to save the chart as picture
  • Select a cell, press Shift+F2 to add a new Comment; if a Comment is in the cell, then press Shift+F2 to edit the Comment

image 8

 

  • Select the edge of the Comment so that it is surrounded by dots, not slashes

image 9

 

  • Right-click the Comment edge, and from Format Comment, select Colors and Lines
  • In the Fill section, open the Color box
  • Choose Fill Effects, click the Picture tab, and then click Select Picture

image 10

 

image 11

 

  • Select a picture and click OK twice.

image 12

 

image 13

 

Conclusion: -Through this option, you can add more information in a very small report.

 

image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Users are saying about us...

  1. I added a picture to a comment. Now the comment stays exploded and will not shrink to hidden comment. Anybody know what gives? Thanks, Kent.

  2. I added a picture to the comment in cell C6, then clicked on another cell to close the comment. Allthough the view-comment works fine when I pass the cursor over cell C6, editing the comment does not. When I right-click again on cell C6 and choose edit comment, I get only the comment-text, not the picture. To see the picture I need to left- or right-click on the frame of the comment. I’d liked to see the pictue immediately when I edit the comment. Who can help me out of this?

  3. It seems in XL 2000 that if you put a picture in a comment of a header cell, using window=>split; freeze panes so that the header is always visible when you scroll, then the picture is also split. If you scroll all the way up to the top of the sheet, the picture appears normally.

  4. “Be aware that this can rapidly make your workbook file size very large indeed!

    May not matter to you as a developer when working off your hard disk, but if the workbook is then on a network it might be a different issue.

    Alan.”

  5. I added a picture to a comment. Now the comment stays exploded and will not shrink to hidden comment. Anybody know what gives? Thanks, Kent.

  6. I added a picture to the comment in cell C6, then clicked on another cell to close the comment. Allthough the view-comment works fine when I pass the cursor over cell C6, editing the comment does not. When I right-click again on cell C6 and choose edit comment, I get only the comment-text, not the picture. To see the picture I need to left- or right-click on the frame of the comment. I’d liked to see the pictue immediately when I edit the comment. Who can help me out of this?

  7. It seems in XL 2000 that if you put a picture in a comment of a header cell, using window=>split; freeze panes so that the header is always visible when you scroll, then the picture is also split. If you scroll all the way up to the top of the sheet, the picture appears normally.

  8. “Be aware that this can rapidly make your workbook file size very large indeed!

    May not matter to you as a developer when working off your hard disk, but if the workbook is then on a network it might be a different issue.

    Alan.”

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Categories

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube