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.

Advertisement
  • XlsAddin

    Easily done with this add in for Excel:
    http://www.excel-image-assistant.com

  • Zman

    I right click the data cell in Excel Starter 2010 but do not get an “add comment” option. Ideas? Thaks!

  • Neels

    I also wanted to insert comments in Excel Starter 2010 and couldn’t find that option… so here’s what I did: I decided to stop using yet another CRIPPLED Microsoft product – I’m using OpenOffice from now on! It’s free and has the ability to add comments, as well as loads more features :-)

  • hassan

    thanks…

  • Renjith

    Dear
    I have checked this thing in the same way for many times. but i didnt get the insert comment option.i think this option is not available in excel 2010.If any one can help me pleasee….. its very urgent for me..

    • luuhue

      Me too, I cannot insert comment option. If a have an file excel 2003 or 2007 with the comment i can read but i cant delete or edit them. What is happens with excel 2010?

  • Matt Brown

    Zman, Neels, Renjith: Are you currently getting a “Format Comment” window with only a “Font” tab when you click “Format Comment”? This happens when you right-click inside the cell. What you need to do, and yes I agree that this is poorly designed by Microsoft, is to right-click on the dotted border portion of the comment, outside of the comment itself. Then all of the tabs, not just “Font”, should appear in the window that pops up.

    • Cici

      Thank you a lot~~

    • Ziegler

      Thanks Matt!!!

  • Medinadan61

    Great post….Congrat

  • Medinadan61

    Great post….Congrat

  • Parklanerobin

    Great info but I have a different issue… when I right-click to Insert Comment… this function is not llisted on the right-click menu.
    ????
    Robin

    • Babiedoll21

      I have the same problem.  When I go to file – options – advanced it even shows the indicator for the comment option is not disabed….I’m running out of ideas!

      • Hopethishelps

         Are you running the full version of Excel? The option is not there if you are using Excel Starter. Hope this helps :)

  • Sharonb

    I’ve always been able to copy comments to other cells.  How can I do this in 2010?  No option to paste comment in the Paste menu.

  • disqus_NPy8VLb8JW

    I added a comment for a cell, but it remains visible and covers other data in the spreadsheet. How do I get the comment box to disappear until I’m ready to look at it? I have never had this problem before

  • Steve

    I am also missing the ‘Insert Comment’ from the option box when I right-click on a specific cell. Any more ideas would be appreciated. Not sure which Excel version this author is using but it does not appear to be Excel 2010

  • Steve

    Think I just found my answer below thanks to ‘Hopethishelps’ . I am running Excel Starter with the disabled option. Though I am very surprised that a basic option such as ‘Insert comment’ is not included in this Excel version when it was always available in previous versions

  • Frustrated no more …

    Commemts are apparently not available on the 2010 starter version of Excel. : ( As I have no intention of spending that kind of money for a program I don’t use that often (my old version doesn’t run on Windows 7) I downloaded Libre Office. Spreadsheet looks the same as Excel, will save in Excel format if I want and IT GIVES ME MY COMMENTS BACK! Yay.

  • Kateemo07

    Is it possible to paste into a comment box? I’m on Version 7 -

  • alistair

    still running excel 2007. i’ll be darned. tremendous help. been sweating it. youre give away secret = click on corner. my gosh. all smiles here.