Home >Common Problem >How to insert a picture into a comment box in Microsoft Excel

How to insert a picture into a comment box in Microsoft Excel

WBOY
WBOYforward
2023-05-03 22:55:052981browse

If you have an Excel worksheet that contains a list of products, and you want to attach a picture to each product, this will make Excel look clunky. But how do I add an image as a comment? Are they only visible when you hover over them? Another scenario would be to have a list of employees and append their photos to their data rows. In this case, inserting an image in the form of a comment will also serve you well. So now the question is, is it possible to insert an image in the comment box of an Excel document? Well, absolutely!

Keep reading to learn how to successfully insert an image into an Excel worksheet comment box.

Sample Scenario

Suppose we have an Excel sheet containing the list of Presidents of India since 1987. We must include a photo of each president and his/her name in the comments box. Let's see how to accomplish this in the following steps.

Solution

Step 1: First, select the cell where you want to attach the image as a comment.

如何在 Microsoft Excel 的注释框中插入图片

Step 2: Nowright click on the cellcell and click Insert comment option.

如何在 Microsoft Excel 的注释框中插入图片

Step 3: A comment box will now appear on your Excel worksheet. In the corner of the comment box, you will see 8 small squares. These are for resizing the comment boxes and formatting them.

如何在 Microsoft Excel 的注释框中插入图片

Step 4: You can right-click on any of the 8 small squares . From the right-click context menu, click the "Set Comment Format" option.

如何在 Microsoft Excel 的注释框中插入图片

Step 5: In the Format Comment window, first click on the Colors and Lines option Card.

Now click on the drop down menu named

Color.

Now, from the drop-down options, at the very bottom, click on the option

Fill Effects.

如何在 Microsoft Excel 的注释框中插入图片

Step 6: Under the "Fill Effects" window, click the "Picture" tab.

Next, click on the button

Select Image to browse for the image you want to insert into the comment box.

如何在 Microsoft Excel 的注释框中插入图片

Step 7: You will now have 3 options to select your image. You can browse your computer and find the image, or you can search for the image online, or you can get the image from OneDrive if it exists.

In the example below, since I already have the image saved on my machine, I selected the

From a file option. Click the Browse button to select an image from your machine.

如何在 Microsoft Excel 的注释框中插入图片

Step 8:Navigate to where the image is located and clickto insert image and finally click the "INSERT" button.

如何在 Microsoft Excel 的注释框中插入图片

Step 9: You will now return to the Fill Effects window. Click the OK button.

如何在 Microsoft Excel 的注释框中插入图片

Step 10: When you return to the Format Comment window, click the OK button again.

如何在 Microsoft Excel 的注释框中插入图片

Step 11: That’s it. If you look at your Excel sheet now, you can see that the image you selected has now been successfully inserted into your comment box. You can see this image whenever you hover over the cell where the comment is inserted.

如何在 Microsoft Excel 的注释框中插入图片

Step 12: If you want to change the image in the comment box, right click on the cellcell and click "Edit Comment " option.

如何在 Microsoft Excel 的注释框中插入图片

Step 13: You will now have the little squares in the corners of the comment box, just like you did in step 4. You canright-click on one of the boxes and follow the same steps mentioned in step above to select a new image for your comment box.

如何在 Microsoft Excel 的注释框中插入图片

Step 14: If you want to add text on top of the image in the comment box, just enter the text in the comment box is enough.

如何在 Microsoft Excel 的注释框中插入图片

Step 15: If you now click elsewhere you can see that the text has now been successfully added to the image in your comment box top. enjoy!

如何在 Microsoft Excel 的注释框中插入图片

The above is the detailed content of How to insert a picture into a comment box in Microsoft Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:yundongfang.com. If there is any infringement, please contact admin@php.cn delete