How to Insert Picture in Excel Cell with Text (2 Easy Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to insert picture in Excel cell with text for our convenience. Images represent things neatly. So, having images is great for reports. In this article, I am going to discuss how to insert picture in Excel cell with text. I will demonstrate 2 easy methods in this regard.


Download Practice Workbook

Download this workbook and practice while going through the article.


2 Methods to Insert Picture in Excel Cell with Text

This is the dataset for today’s article. I have a list of Animals and will insert images next to these animals along with adding text to it. I have resized the cells in a way that seems suitable to accommodate images in these cells.

how to insert picture in excel cell with text


1. Insert Picture Using Pictures Option

First of all, I will insert images using the Pictures option. This method will directly insert an image in my Excel file.

Steps:

  • Firstly, go to the Insert.
  • Then, go to Illustrations.
  • After that, choose Pictures.
  • Finally, insert images from This Device.

  • Now, the Insert Picture window will open.
  • Select an image and click Insert.

how to insert picture in excel cell with text

  • Excel will insert an Image.
  • Then, position the image in the correct place by dragging and resizing.
  • After correct positioning, your image will look like this.

  • Now, notice that this image is not set with the cell. That’s why when I change the column width, the image does not expand, and some gap is created.

how to insert picture in excel cell with text

  • To set the image with the cell, select the image.
  • Then, right-click your mouse to bring the context menu.
  • After that, select Format Picture.

  • Now, from the Format Picture options available, go to Size and Properties and mark Move and size with cells.

how to insert picture in excel cell with text

  • This time the image size will change along with the cell size. For example, I have reduced the cell size here, and the image also gets contracted.

  • Now I will add text to the image. To do so,
  • Go to the Insert.
  • Then, go to Text.
  • After that, select the Text Box.

how to insert picture in excel cell with text

  • Now, position the text box at the bottom corner of the image.

  • Now, I will remove the fill colors. For this,
  • Select the text box.
  • Then, go to Shape Format.
  • After that, select Shape Fill.
  • Finally, choose No Fill.

how to insert picture in excel cell with text

  • As a result, Excel will remove the fill color.

  • Now, you can edit and modify the text to make them look visually appealing.

how to insert picture in excel cell with text

  • Now, following the same procedure, insert an image for the dog.
  • Finally, your output will be like this.

Read More: How to Insert Picture in Excel Cell Automatically


Similar Readings


2. Add Shapes to Insert Pictures in Excel Cell with Text

Now, I will discuss another method to insert pictures in an Excel cell with text. In this method, I will add shapes and then insert images. Let’s follow this method step by step.

Steps:

  • First of all, go to the Insert
  • Then, select Illustrations.
  • After that, select Shapes.
  • Finally, choose any shape. I am choosing a rectangle.

how to insert picture in excel cell with text

  • After that, draw a rectangle in C5.

  • Then, you have to select an image as Fill.
  • Go to Shape Format.
  • Then, select Shape Fill and choose Pictures from the drop-down list.

how to insert picture in excel cell with text

  • Select From a File to insert an image from your computer.

  • Now, the Insert Picture window will open.
  • Select an image and click Insert.

how to insert picture in excel cell with text

  • As a result, Excel will insert an image.

  • Now I will add text to the image using a Text Box following method-1.

how to insert picture in excel cell with text

  • Now, following the same procedure, insert an image for the dog.
  • Finally, your output will be like this.

how to insert picture in excel cell with text

Read More: Insert Pictures in Excel Automatically Size to Fit Cells


Things to Remember

  • When you are inserting pictures, do not forget to set the image with the cell. Only then, the image size will alter while changing the cell size.
  • When adding shapes, you do not need to set the image with the cell. Excel will by default do so.

Conclusion

In this article, I have demonstrated 2 effective methods on how to insert picture in Excel cell with text. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more useful articles like this.


Related Articles

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo