How to insert picture / photo into comment? - KING OF EXCEL


KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Wednesday, January 22, 2020

How to insert picture / photo into comment?

How to insert picture / photo into comment?

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!
#evba #etipfree #kingexcel
📤You download App installed directly on the latest phone here :

No comments:

Post a Comment