Adding Data, Charts or Other Information to a Cell Comment in Microsoft Excel 2010

In this article, we will learn how to add data, charts or other information to a cell comment. You can use the Format Comment option in Microsoft Excel 2010.

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, insert a picture, etc.

Let’s take an example to understand how to add data, charts or other information to a cell comment.

We have sales data. Now, we need to add a chart or picture in the cell comment in this data.

To add a picture to a cell Comment, follow the below given steps:-

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

 
img1
 

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

 
img2
 

  • Right-click on the comment edge, and from Format Comment, select Colors and Lines.

 
img3
 

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

 
img4
 

  • Select a picture and click on OK twice.

 
img5
 
img6
 
img7
 
To add a Chart to a 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 in your desktop or as per your convenience.
  • We will use the Snipping tool to save the chart as picture.
  • Select a cell, and press Shift+F2 to add a new Comment. If a Comment exists in the cell then, press Shift+F2 to edit the Comment.

 
img8
 

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

 
img9
 

  • 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.

 
img10
 
img11
 

  • Select a picture and click OK twice.

 
img12
 
img13
 
This is the way you can add a comment in the Cell as a picture.  
 
 

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>

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