We insert comments to a cell for
many reasons like to give additional information regarding the contents of the
cell. But wherever I do that, I feel that Excel comment background is boring. I
try to apply different backgrounds to see which one fits, in the process I discovered
that you can also set a picture as a background to a comment. Interesting? Here
is the way.
Once you are done inserting a
comment, click on the border of it. Make sure you don’t have the cursor inside
the comment. You can check that by the design across the borders. Comments
outline appears like below when you are in edit comment mode or selection of
comment.
When Comment is Selected |
While Editing Comment |
So diagonal lines indicates that
you are in comment editing mode! Series of small dots is the proof that you
just selected the comment. Right click on the dots part now and select Format Comment option. This should
bring up Format Comment dialogue box;
notice the tabs in this box, there should be more than 1 tab (if there is only
Font tab, you might have right
clicked in editing mode. So close the dialogue box and try again).
Click on Colors and Lines tab, in the color dropdown, select Fill Effects. In the new dialogue,
click Picture tab and Select picture… button. Browse to your picture and select it. Click on Insert. Click OK in all
the open boxes. You should be able to see selected picture in the comment
background. (Look at the below pic, beautiful, isn't it? I selected blue hills which is available as a sample picture in MS Windows)
You can also change font, color, size, italic, bold and many other formatting optoins using Format Comment dialogue box.
No comments:
Post a Comment