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

21 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

Powered by Blogger.