How To Format & Insert Image Into Microsoft Excel Comment Box

Microsoft Excel comment box

Normally, when you add comment in Excel (that is, Right-Click, Insert Comment or press Shift+F2); the comment by default looks like this:


Microsoft Excel comment box







But how about making your comment look like A or B below?
Yes ... Using Microsoft Excel...

Microsoft Excel comment box

Well, here’s how you can do it?

First you need to add “Change Shape” tool to your Excel Quick Access Toolbar.

Right click the Quick Access Toolbar and then click Customize Quick Access Toolbar (see figure below):


Microsoft Excel Tips

Click Popular Commands and then click Drawing Tools | Format Tab (see below):

Microsoft Excel Tips

Click Change Shape and then click Add and Ok:

Microsoft Excel comment

The Change Shape tool will appear on top of your Excel sheet like this (see where the arrow is pointing):

Microsoft Excel Tips







Now, when you add a new comment or edit an old comment, click the comment border (not the comment text) to select the comment shape like this:

Microsoft Excel Tips






Then click the Change Shape tool and select any shape you want for your comment. I selected the Cloud callout. See below:

Microsoft Excel Tips



















Your comment will now look like this:

add picture to Excel comment box








Once you have your desired shape (I used cloud), you can format further.

Right click on the comment border again, and click Format Comment...:

add picture to excel comment box















This will open up the following dialog. You can then click the Colors and Lines tab, click Color and click Fill Effects. See figure below:

add picture to excel comment box


















Click Picture and Select Picture to add image to your comment. I added my own picture as follows:

Microsoft Excel comment picture



















You will now have a comment like this:

add picture to microsoft Excel comment box






You can see, it isn’t hard at all. 

You try it and and comment below, or contact me for any query or clarifications. 

Enjoy

34 comments:

  1. In Excel 2010 a list is regarded as, and can be formatted as a table. Excel 2010 tables are different from lists in several respects.excel dashboard software

    ReplyDelete
  2. The programmer can take excel to the maximum levels wherein, it will be useful for the overall development of businesses.salesforce datawarehouse

    ReplyDelete
  3. Through professional services of image editing, you can get almost all sorts of images edited, including photos of individuals, as well as images of fine jewelry, garden products, art & crafts, electronics, industrial tools, toys & games, lighting products, sports goods, fashion apparel and accessories etc.content

    ReplyDelete
  4. All computer users know that computer and technical problems go hand in hand. It is just not possible to isolate problems from computers or vice-versa. reset windows 10 password

    ReplyDelete
  5. first-rate knowledge, restructure everybody mind merely reference assign assist to to it Advanced Excel Training Mumbai

    ReplyDelete
  6. The mark is joined to the layered board before kick the bucket cutting. Custom Boxes NYC

    ReplyDelete
  7. Today, printers have developed into multi-useful gadgets that exposed little similarity to their far off sources.custom boxes nyc

    ReplyDelete
  8. I am thankful to you for sharing this plethora of useful information. I found this resource utmost beneficial for me. Thanks a lot for hard work. 2ms office 2016 product key

    ReplyDelete
  9. Introduction is the best way to elevate items and to give it a genuine expert and quality look. Here are scarcely any tips to make cleanser bundling supplies for your hand crafted cleansers. Custom Soap Boxes

    ReplyDelete
  10. This comment has been removed by the author.

    ReplyDelete
  11. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post. microsoft office 2016 free download full version for windows 10

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... image typing data entry

    ReplyDelete
  14. Hi! This is my first comment here so I just wanted to give a quick shout out and say I genuinely enjoy reading your blog posts. Can you recommend any other Fashion Write For Us blogs that go over the same topics? Thanks a ton!

    ReplyDelete
  15. There are particular dissertation web-sites by the online market place to develop acquire secured in a dark noted down in your own web page. Microsoft 365 product key activation free

    ReplyDelete
  16. You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. packaging companies

    ReplyDelete
  17.  backlink is a hyperlink from an external source which points right to your website or webpage. To greatly help me explain this further I possibly could add an url to Wikipedia using this article. If you were to click this link you would be directed to Wikipedia and away from my website. unique blog comments

    ReplyDelete
  18. But wanna remark that you have a very decent internet site , I love the design it really stands out. Excel Expert

    ReplyDelete
  19. I have composed this article to address demands I have been traversing email on the best way to mechanize MS Excel. Excel Expert

    ReplyDelete
  20. Hey what a splendid post I have run over and trust me I have been looking out for this comparative sort of post for recent week and barely ran over this. Much thanks and will search for more postings from you. Custom Boxes with logo

    ReplyDelete
  21. Hey friend, it is very well written article, thank you for the valuable and useful information you provide in this post. Keep up the good work! FYI, please check these depression, stress and anxiety related articles:

    How To Draw Hairs

    Doodle Art

    Learn how to make a painting

    How to Draw Anime

    Create Doodle Art


    You can also contact me at depressioncure.net@gmail.com for link exchange, article exchange or for advertisement.

    Thanks a lot

    Dhruv

    ReplyDelete
  22. Note: There have been various updates and upgrades since I previously distributed this article in 2014. In particular, Microsoft Office 2016 is presently the current form for Windows clients and Office 365 is significantly more powerful. Still some accommodating treats for Office 2013 people. Some alters were made for clearness. help for excel spreadsheet

    ReplyDelete
  23. This is on the grounds that in an enormous spreadsheet like a monetary model, there can frequently be hundreds if not large number of various recipe down and across each page including counts which may contain a few connects to different sheets inside the exercise manual. excel spreadsheet consultant

    ReplyDelete
  24. Hey friend, it is very well written article, thank you for the valuable and useful information you provide in this post. Keep up the good work! FYI, please check these depression, stress and anxiety related articles:

    How To Draw Hairs

    Doodle Art

    Learn how to make a painting

    How to Draw Anime

    Create Doodle Art


    You can also contact me at depressioncure.net@gmail.com for link exchange, article exchange or for advertisement.

    Thanks a lot

    Dhruv

    ReplyDelete
  25. Regardless of whether it's for capacity, moving to another area or aiding a companion or relative move to another home, getting quality boxes for the undertaking is an absolute necessity.mylab

    ReplyDelete
  26. Within this certain content, you will note a summary, meet surf this specific article. [pii_email_8079047078567379049d]

    ReplyDelete
  27. Hey friend, it is very well written article, thank you for the valuable and useful information you provide in this post. Keep up the good work! FYI, please check these depression, stress and anxiety related articles:

    Private Job Kaise Paaye

    How to Get Job in Microsoft

    How to Get Job in Canada

    How to Get Jobs at USA


    Google Search Consoles

    Slow Cooker Taco Soup

    Oven Roasted Asparagus

    Chicken Soup Recipe


    You can also contact me at www.jobsadda.com@gmail.com for link exchange, article exchange or for advertisement.

    Thanks a lot

    Vikas

    ReplyDelete
  28. Get custom luxury apparel boxes packaging at wholesale prices. We offer free shipping and design support on apparel gift boxes. Get Free Quote!

    ReplyDelete

Powered by Blogger.