How to insert picture / photo into comment?

Happy Valentine’s Day!!


Tomorrow is a very special Valentine’s Day as both Chinese and Western Valentine’s Day fall onto the same day.  It happens only once in every 19 years.

Let’s send your special feeling to a special person subtly via a comment in worksheet of Excel.

What? The boring comment in Excel???


No way!!  Did you notice that the (nice) poster on the top of this post is actually a comment?

How to insert picture / photo into comment?  Follow the simple steps below:

1) Insert comment to a cell as usual (Right-click cell –> Insert Comment)


2) Once it is done, the comment box is activated for editing. Right-click a border of the comment box –> Format Comment…


3) The Format Comment dialogue box is opened.


Note: If you see the dialogue with only one tab (the lower one), it means you have right-click inside the comment box, NOT on its border.  Pls try again.

4) Go to the Tab Colors and Lines –> Click the drop-down arrow for  Fill Color: –> Select Fill Effects


5) The Fill Effects dialogue box is opened.  Go to the Tab Picture –> Select Pictures…


6) Select the picture you want to use; then Insert. (Yes! you need a soft copy of the pic and have it saved somewhere in your computer!)


7) Now you see a sample.  Uncheck “Lock Picture aspect ratio”. To Unlock the ratio means, the whole picture  will fully fill up the entire comment box regardless its size (so that you may adjust the size of the comment box to make it fit you needs later)

ImageNote: This picture comes from Office Clip Art

8) Click OK and OK to return to the worksheet

9) Now you should be able to see the semi-finished comment, as shown below:


10) Now resize the comment box by drag and drop the lower right corner of the comment box (when it is activated).


11) Edit your comment as usual (Right-click cell –> Edit Comment)


Extra tips: You may format text inside a comment box as if a normal text.   Multi-style is also possible.  Just select the texts you need and do the formatting (either from Format Comment or from the Font group on Home Ribbon)


12) Here you go!


With this trick, it is quite easy to make your comment eye-catching and interesting.

p.s. Every single day happens only once in universe.  Don’t wait for a so-called special occasion to treat your beloved ones nice.  Make every day count!


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

1 Response to How to insert picture / photo into comment?

  1. Johne629 says:

    Hey very nice blog!! Man .. Beautiful .. Amazing .. I’ll bookmark your website and take the feeds alsoI am happy to find a lot of useful info here in the post, we need work out more techniques in this regard, thanks for sharing. . . . . . eekddfddfdkd


Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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