1. Home
  2. MS Office

Insert Comments In Excel 2010

With Excel Comments you will be able to document your datasheet, it would be useful for you if you want your audience, users to understand the data cells more deeply. Adding comments with data cells enables you to add description of it, helps users to understand the complex logic. Importantly, adding images in comments would be even more fascinating, especially if you need to make novice users to comprehend the rationale behind the data cells, describe a particular value, graph, or how formula works. This post will cover adding text and images as comments in Excel worksheet.

To start out with, launch Excel 2010, open a datasheet on which you want to add comments. For Instance, we have created a datasheet, containing Office Items list.

office items

Now we want to add comment with each item in Products field. For this right-click any item (cell) in the desired field and click Insert Comment, as shown in the screen shot below.

insert comeent

You will see a box will appear with selected cell, enter text that you want to show with the cell as comment.

add comment

Now move to other cells to add comment, after adding comments you will notice on hovering pointer over cell, the comment box will automatically pop-up.

pencil

If you want to edit comment, right click the cell containing comment, and click Edit Comment. Upon click, you will see the comment box will be selected, now select the text, and right click the box and hit Format Comment, as shown in the screenshot below.

format comment

Format Comment dialog will appear, here you can change Font, Font Style, and font Size. Under Color, choose the text color. Click Ok to close text formatting

format comment 1

Now we want to add comment which is self-explanatory, so we will be adding a picture with comment. For this, right-click the cell and click insert comment, now right click the corner of comment box, and click Format Comment.

laptop

You will see the extended Format Comment dialog, now navigate to Colors and Lines tab.

extended dialog 1

In this step, click Fill Effects from Color, as shown in the screenshot below.

fill effects

It will bring up Fill Effects dialog, now head over to Picture tab.

fill effects mew

Click Select Picture to select image from the disk, and click Insert.

select pic

You will see the image in Fill Effects dialog, you can switch to other tab; Gradient, Texture, and Pattern to apply different styles on image. Click OK to continue.

click ok in fill

It will bring you back to Format Comment dialog, click OK to proceed further.

click ok format

Upon hovering over cell, you will notice that comment box containing image, will pop-up.

pic added

You can also check out previously reviewed guides on Customizing Gridlines in Excel 2010 & Using Camera tool in Excel 2010.

Leave a comment