Microsoft Excel allows you to insert images into a comment. This makes allows one to make a comment more insightful, especially, when they need to explain formulas or describe something meaningful. Instead of entering text description, you can insert an image or picture into a comment in Microsoft Excel. In this post, we will show how it’s done.
Insert a Picture into a Comment in Excel
In order to insert a picture into a command in Excel, follow the steps mentioned below.
- Add a new comment.
- Go to the Format Comment utility.
- And then add your preferred image.
Let us see how it’s done.
First of all, we need to add a new comment, for that, right-click in a cell and select Insert Comment or New Comment.
Enter the text you want to be displayed in the comment.
Right-click on the edge of the comment box to display the context menu and then select Format Comment, you need to place your cursor on the highlighted edge of an editable comment before right-clicking to launch the context menu. If your cursor is on the text portion of the comment, the context menu will operate differently.
Go to the Colors and Lines tab, expand the Color drop-down list, and select Fill Effects.
In the window that opens select the Picture tab and then click Select Picture.
Browse for the image file of your selection and then click on Ok.
Later, click on the comment box to display the re-sizing handles. From there you can adjust the size of the comment box. That’s it!
When an inserted picture is selected in the worksheet, Excel adds the Pictures Tools contextual tab to the Ribbon with its sole Format tab. The Format tab is divided into the following 4 groups:
1. Adjust
2. Picture Styles
3. Arrange
4. Size.
Also, you can find a Reset option that allows you to remove all formatting changes made and return the picture to the state it was in when you originally inserted it into the worksheet.
Trust this works for you.
Read: How to format or edit an Image in Excel
How do I insert a picture into an Excel cell?
To insert a picture into a cell, first select a cell, then go to the Insert tab, and click on Pictures > Place in a cell. Now, if you have the image stored locally on your computer, click on This device, navigate to the location where your image is stored, and then insert it.
Also Read: Use Insert Data from Picture feature in Excel.