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.

27 Comments

  1. With Gain Credit Loans, you can get instant loan/money for a wide range
    of your personal needs like renovation of your home, marriage in the
    family, a family holiday, your child’s education, buying a house,
    medical expenses or any other emergencies. With minimum documentation,
    you can now avail a personal loan at attractive 3% interest rates. This
    is trust and honest loans which you will not regret, Contact us via
    Email: gaincreditloan01@gmail.com

  2. how do i create this box ? – so a cell with instructions written in light grey , then when someone clicks the cell , the instructions disappear and you can type in the cell …

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

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

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

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

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

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

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

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

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

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

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

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

  12. 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 🙂

    • One possibility is that this is not available in the “Starter” editions. Other is something I just did by mistake. Make sure you are not selecting the text that is in the cell. Click off it and then make sure to just select the cell itself. Then the “Insert Comment” option shows up. Good luck.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.