Insert a Picture Into a Cell in Excel

To insert a picture in a cell in Excel, use Insert > Pictures > Place in Cell in Microsoft 365. The image then lives inside the cell, like a number or a word, so it stays with its row when you sort, filter or resize. You can also show a picture from a web address with the IMAGE function, or, in older Excel, pin a floating picture to a cell. This guide covers all three, plus how to look up a product photo with XLOOKUP.

Picture in a cell vs picture over cells#

Excel has two kinds of pictures, and the difference explains most problems people have.

A picture over cells is the classic kind: you can drag it anywhere, but it doesn't belong to any cell. A picture in a cell behaves like data. For product lists, staff directories and catalogues, the in-cell kind is almost always what you want.

How to insert a picture into a cell (Microsoft 365)#

In Microsoft 365 on Windows, Mac or the web, follow these steps:

1. Make the cell big enough first. Drag the row border down and the column border right, or set the size with Home > Format > Row Height. The cells, rows and columns lesson practises resizing.
2. Click the cell where the picture should go.
3. Go to Insert > Pictures > Place in Cell.
4. Choose This Device for a file on your computer, or Stock Images or Online Pictures.
5. Pick the image and click Insert.

The picture shrinks to fit inside the cell and keeps its shape. Make the cell bigger and the picture grows with it. Because the picture is the cell's value, the cell can't also hold text. Put names or labels in the next column.

To give the picture a description for screen readers, look for Alt Text in the cell's right-click menu.

How to change a floating picture into an in-cell picture#

If a picture already floats over the sheet, you can move it into a cell. Select the picture, right-click it and choose Place in Cell. Excel moves it into the cell near its top-left corner.

To go the other way, right-click the cell and choose Place over Cells. The picture becomes a normal floating image again, which is useful when you want it larger than one cell.

Don't merge cells to make room for a big picture. Merged cells cause trouble with sorting and copying, as explained in the guide to merge and center and its alternatives. Make the row taller instead.

How to show a picture from a web address with IMAGE#

The IMAGE function shows a picture from an internet address inside a cell. It's part of Microsoft 365. The syntax is:

=IMAGE(source, [alt_text], [sizing], [height], [width])

For example, if D2 holds a link such as https://example.com/img/mug-blue.png, this shows the mug in the cell with a description:

=IMAGE(D2,"Blue mug")

The address must start with https:// and point straight at an image file, such as a .png or .jpg. A link to a web page that contains the picture won't work. If the picture can't be loaded, the cell shows an error instead.

How to look up a picture with XLOOKUP#

Because an in-cell picture is a value, a lookup formula can return it. This is how you build a product card or a staff directory where the photo changes when you type a different ID.

Type an ID in E2 and this formula in F2:

=XLOOKUP(E2,A2:A5,C2:C5)

With P-103 in E2, F2 shows the notebook picture. Change E2 to P-101 and the mug appears. The XLOOKUP function reference lists the optional arguments, and the guide to XLOOKUP in Excel covers the not-found message. For a full example with names, departments and photos, see the employee lookup sheet.

If column C holds web addresses instead of pictures, wrap the lookup in IMAGE: =IMAGE(XLOOKUP(E2,A2:A5,C2:C5)).

How to lock a picture to a cell in older Excel#

Excel 2021 and older can't put pictures inside cells, but you can make a floating picture stick to one.

1. Insert the picture with Insert > Pictures > This Device.
2. Hold Alt (Windows) while you drag and resize it. Its edges snap to the cell borders. On a Mac, resize it by eye or type an exact height and width in the next step.
3. Right-click the picture and choose Size and Properties (Mac: Format Picture).
4. Under Properties, select Move and size with cells.

Now the picture moves when you insert rows above it and shrinks when you make the row smaller. It still won't follow its row when you sort, so in-cell pictures are better if you have Microsoft 365. The guide to inserting and deleting rows and columns shows the row actions that move pictures around.

Why your picture looks wrong in a cell#

Most problems are about cell size or version.

• The picture is tiny. It fits inside the cell. Make the row taller and the column wider. Autofit won't help here, because it sizes for text. See how autofit column width works.
• Place in Cell is missing. Your Excel isn't Microsoft 365, or it needs an update. Use the older method above.
• Someone else sees an error. In Excel versions that don't support in-cell pictures, those cells can't show the image.
• The file is huge. Large photos make the workbook large. Shrink images before you insert them, or use Picture Format > Compress Pictures on floating pictures.

Practise it#

The picture part is a few clicks. The skill that makes it useful is the lookup. Practise XLOOKUP in a live spreadsheet: you type the formula and it checks the result instantly. If resizing rows and columns still feels clumsy, start with the cells, rows and columns lesson.