How to insert picture / photo into comment?

Happy Valentine’s Day!!

Image

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

Image

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)

Image

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

Image

3) The Format Comment dialogue box is opened.

ImageImage

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

Image

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

Image

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

Image

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:

Image

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

Image

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

Image

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)

Image

12) Here you go!

Image

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!

This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

One 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

    Like

Comments, suggestions, corrections are welcome.

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s