Comments on: How to insert comments in Excel, add pictures, show/hide comments

In this article you'll find out how to add comments to Excel cells, show, hide and delete them. You'll also learn how to insert a picture in a comment and make your cell note more eye-catching by changing its font, shape and size. Continue reading →

Comments page 2. Total comments: 57

  1. I know this site offers quality based content and additional stuff, is there any other
    web site which presents these information in quality?

  2. I am having trouble even finding the show/hide comment command. For me it is non-existent. All there is is "show all comments." I just want an individual comment to show up. I tried modifying the display options but no luck.

  3. To see how to add a picture to a comment, watch the steps in this short video. The written instructions are below the video. Instead of text, you can show a picture in an Excel comment. Watch the steps in this short video, and the written instructions are below.

  4. Assuming that you have set the display of comments to show red markers and comments on hover, you may want to show all comments when you are working on them and then later hide the comments to display the red markers again.

  5. How to change user name in Excel comments, change comment shape, and more tips. Short videos and step by step written instructions. NOTE: Shapes and Pictures are not available with Threaded Comments.

  6. How add comment and image together ?

  7. Wonderful!! It's exactly what I require!! Much appreciated!

  8. Thank you so much. Wonderful and easy to follow directions. You helped me a lot.

  9. Thanks For giving New Techniques in Excel

  10. Hello, I loved the content I hope to spend more times on the blog.

  11. Hello,

    I don't know if anyone else has this problem, but I tried this method of adding picture in the comments. However, when I save it, close it, and try opening it up again the Excel notifies me that the workbook has been corrupted and has to be "recovered." All the pictures (via comments) are all disappeared when I open the workbook back up. I believe it has something to do with privacy/Trust Center issue in my workbook. Can anyone help? Thank you.

  12. thanks a lot for ur clear suggetion..

  13. Thanks a lot ..... Send updates my email .... Very useful

  14. Hi, Congratulations! This side is helpful. There is much to learn here. We can fix our mistakes from here. Thank you for this post shearing me.

  15. Great !, Thank you sir, really useful and helpful

  16. how to add name in comment box or to edit while the name is already added when i am going to use comment option.

  17. Wish there was a way to insert a picture from the clipboard instead of having to have it. I upgraded to Excel 2013 (from 2010) and I still don't see a way to do it.

  18. very helpful information

  19. Very good information, very very helpful to present work.

  20. Good information about comment

  21. Good information about comment, otherwise normally people knows only "yellow square comment.

  22. IF VLOOKUP DATA MATCH THEN SHOW INSERT COMMENT

  23. This was really useful. Awesome option... Cheers...

  24. i would like to lot of thanks for this valuable information

  25. When I right click on the comment box and select ‘format comment’ the only option on the pop up is ‘font’. No ‘colors and lines’ or anything else........ if anybody know any other option......can u share with me that...

  26. When I right click on the comment box and select ‘format comment’ the only option on the pop up is ‘font’. No ‘colors and lines’ or anything else.

  27. Hey, thanks a ton. I've been digging around for some of this information and the depth/detail that you provided REALLY helped. Thank you!

  28. I am trying to have text and picture(s/diagramme(s) in comment boxes, but the picture/diagramme always takes up the whole comment box. How does one resize and position pictures? What am I doing wrong?Your answer will be appreciated.

    Mike

  29. great idea. nicely done

  30. Is there any way to compress images that were put inside comments?

  31. Great

  32. Works Great! Thank you

  33. Very useful instruction. After you familiar with the steps, you work smart, work fun.

  34. very very useful and important trick of excel

  35. I am using conditional formatting and I would like to have the comment box open automatically if the data entered makes the cell change color.

  36. Very use full information

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)