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

Method 1 – Insert Picture Using Pictures Option

Steps:

  • Go to the Insert.
  • Go to Illustrations.
  • Choose Pictures.
  • Insert images from This Device.

  • 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.
  • Position the image in the correct place by dragging and resizing.
  • After correct positioning, your image will look like this.

  • 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.
  • Right-click your mouse to bring the context menu.
  • Select Format Picture.

  • 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. We reduced the cell size here, and the image also gets contracted.

  • Add text to the image. To do so,
  • Go to the Insert.
  • Go to Text.
  • Select the Text Box.

how to insert picture in excel cell with text

  • Position the text box at the bottom corner of the image.

  • Remove the fill colors. For this,
  • Select the text box.
  • Go to Shape Format.
  • Select Shape Fill.
  • Choose No Fill.

how to insert picture in excel cell with text

  • Excel will remove the fill color.

  • Edit and modify the text to make it look visually appealing.

how to insert picture in excel cell with text

  • Following the same procedure, insert an image of the dog.
  • Your output will be like this.


Method 2 – Add Shapes to Insert Pictures in Excel Cell with Text

Steps:

  • Go to the Insert tab.
  • Select Illustrations.
  • Select Shapes.
  • Choose any shape. I am choosing a rectangle.

how to insert picture in excel cell with text

  • Draw a rectangle in C5.

  • Select an image as Fill.
  • Go to Shape Format.
  • 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.

  • 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.

  • Add text to the image using a Text Box following method-1.

how to insert picture in excel cell with text

  • Following the same procedure, insert an image of the dog.
  • Your output will be like this.

how to insert picture in excel cell with text


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.

Download Practice Workbook

Download this workbook and practice while going through the article.


Related Articles


<< Go Back to Excel Insert Pictures | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo