How to Insert a Picture in Excel (Over Cells or in a Cell)

A product list with a small photo next to each item is far easier to scan than a column of stock codes. Excel gives you two kinds of picture: one that floats over the grid like a sticker, and one that sits inside a cell like any other value. Knowing which you've got saves you a lot of dragging, especially once you start sorting the list.

Adding a floating picture over the sheet

1. Click roughly where you want the picture.
2. Go to Insert, then Pictures.
3. Choose This Device for a photo on your computer, Stock Images for Microsoft's library, or Online Pictures to search the web.
4. Pick the image and select Insert.
5. Drag a corner handle to resize it, which keeps the proportions right.

This is the classic method Microsoft describes for all Office apps. The picture sits on top of the cells, so you can place it anywhere, such as a logo at the top of an order form.

Putting a picture inside a cell

For a product or stock list, you usually want the photo locked to its row. That's what Microsoft's Place in Cell feature does:

1. Click the cell where the picture should go.
2. Go to Insert, Illustrations, Pictures, then Place in Cell.
3. Choose This Device, Stock Images or Online Pictures.
4. Select the image and select Insert.

The picture shrinks to fit the cell. Make the row taller and the column wider if you want it bigger. Because it's now part of the cell, it moves when you sort, filter or insert rows, exactly like the text beside it.

Floating or in-cell: which to use

Picture type	Best for	Moves when you sort?
Over cells (floating)	Logos, headers, a one-off image	No
In cell (Place in Cell)	Product photos in a list	Yes

Adding lots of product photos at once

If you've got a folder of product photos, you don't need to add them one by one. Click the first cell in your picture column, choose Place in Cell, select several images, and select Insert. Microsoft says they go in starting from the active cell and running down the column, one per cell.

Here's the catch: Microsoft also says this overwrites anything already in those cells. Make sure the column below your starting cell is empty before you insert, or you'll lose data. And check the order afterwards, because the photos may not land in the same order as your product names.

Pasting a copied picture into a cell

Copied an image from somewhere else? Right-click the cell and, under Paste Options, choose Paste Picture in Cell. Don't just press Ctrl+V: Microsoft notes that the normal paste puts the picture over the cells, not in one.

Switching a picture between the two types

• Floating to in-cell: select the picture and choose Place in Cell on the Picture Format tab, or right-click it and choose Place in Cell. It drops into the top-left cell it was covering.
• In-cell to floating: right-click the picture and choose Picture in Cell, then Place over Cells.

File types and limits worth knowing

Microsoft lists the formats Excel accepts for pictures in cells: JPG or JPEG, PNG, BMP, ICO, WEBP, TIF or TIFF, and GIF, though not animated GIFs. If an image won't go in, save it as a JPG or PNG and try again. Microsoft also says EPS files can no longer be inserted into Office documents at all.

Large photos make large files. If your stock sheet gets slow or too big to email, use smaller images, such as photos resized for the web, rather than full-size camera shots.

Add alt text while you're there

Microsoft recommends alt text for pictures so people using screen readers know what each image shows. For an in-cell picture, right-click it, choose View Alt Text and type a short description, like Blue ceramic mug, small. It takes seconds per image and makes your sheet usable by more people.

When the text beside your photos gets cut off, autofitting columns in Excel sizes them to fit in one click. And once your list has photos and quantities side by side, my guide to dividing in Excel helps with per-item averages.

Making room for in-cell photos

An in-cell picture shrinks to fit whatever space the cell has, so a standard row gives you a thumbnail you can barely see. Before inserting a batch, select the whole picture column and make it wider, then select the rows and make them taller. Doing it first means every photo arrives at a readable size, rather than resizing rows one at a time afterwards. Keep the photo column next to the product name so anyone scanning the list can match them at a glance.

My take

For a logo or a one-off image, Insert, Pictures is all you need. For anything that sits in a list, use Place in Cell so the photo stays with its row when you sort. I'd always start with an empty picture column before inserting in bulk, because overwritten data is a painful way to learn that lesson.

Frequently asked questions

How do I insert a picture into a cell in Excel?

Select the cell, then go to Insert, Illustrations, Pictures, Place in Cell, choose the picture and select Insert.

Why does my picture not move when I sort?

It's floating over the cells. Select it and choose Place in Cell to lock it into a cell.

Can I insert several pictures at once?

Yes. Select multiple images when you insert with Place in Cell; they fill the column from the active cell down and overwrite what's there.

What picture formats does Excel support in cells?

JPG, PNG, BMP, ICO, WEBP, TIF and non-animated GIF, according to Microsoft.

How do I paste a picture into a cell?

Right-click the cell and choose Paste Picture in Cell under Paste Options. A normal paste puts it over the cells.