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

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?

Image
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!
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment