See all How-To Articles

How to Insert a Picture Into a Cell in Excel & Google Sheets

This tutorial demonstrates how to insert a picture into a cell in Excel and Google Sheets.

 

insert a picture into a cell final

 

Insert Picture Into Cell

By default, Excel positions inserted pictures over cells. If you resize cells, the picture will remain unchanged. To insert a picture into a cell that will resize along with cells, follow these steps:

  1. In the Ribbon, go to Insert > Pictures > This Device

 

insert a picture into a cell

 

  1. In the Insert Picture window, select the picture you want to insert (in this example, Computer.png), and click Insert.

 

insert a picture into a cell 2

 

The picture is inserted in the worksheet, but it’s positioned over the cells, and won’t resize when you resize cells.

 

insert a picture into a cell 3

 

  1. Now resize the picture in order to fit the cell (in this example B2). Click on the picture, grab one of the white circles that appear on the picture border, and drag them. You can also press and hold ALT on the keyboard and move the picture to the cell. It will automatically position in that cell.

 

insert a picture into a cell 4

 

  1. Now your picture is positioned in cell B2, but to lock it to the cell, right-click the picture, and choose Format Picture…

 

insert a picture into a cell 5

 

  1. In the Format Picture window on the right, go to the Size & Properties icon (the third one), and check Move and size with cells.

 

insert a picture into a cell 6

 

As a result, the picture is locked in cell B2.

 

insert a picture into a cell final

 

  1. If you resize the cell (e.g., expand its height), the picture’s size will automatically change too, to fit the cell.

 

insert a picture into a cell 7

You can also insert a picture into a cell using VBA.

Insert a Picture in Google Sheets

You can also insert a picture into a cell in Google Sheets.

  1. Select the cell where you want to insert a picture (here, B2), and in the Menu, go to Insert > Image > Image in cell.

 

google sheets insert a picture 1

 

  1. In the Insert image window, go to Upload, and click Browse (to upload an image from the computer). You can also choose to insert an image by URL, from the camera or Google search.

 

google sheets insert a picture 2

 

  1. In the pop-up window, choose a picture to insert (Computer.png), and click Open.

 

google sheets insert a picture 3

 

As a result, the image is inserted and positioned in cell B2.

 

google sheets insert a picture 4

See all How-To Articles