Sunday, March 23, 2014

Insert Picture as Background in Comments


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