Excel Pictures in Cells: What to Know & How to Insert

Excel’s new “Insert Picture in Cell” feature lets you place images directly inside a cell, where they behave like data—they sort, filter, and move with the cell. To use it, go to the Insert tab, click Picture, and choose Place in Cell, then select a file from your device or stock images. This guide explains what you need to know about the feature, how to insert pictures, and how to avoid common pitfalls.

Background: Why Put Pictures in Cells?

For decades, Excel users had two ways to add images: floating objects that sit on top of the grid, or comments that hide pictures until hovered. Both had drawbacks—floating pictures don’t sort or filter with your data, and comment pictures are awkward to view. The in-cell picture feature, rolled out to Microsoft 365 subscribers in 2023, treats images as true cell values. This means you can use them in tables, pivot tables, and even formulas like =IMAGE() for URLs. It’s a game-changer for inventory lists, employee directories, product catalogs, and any spreadsheet that benefits from visual context.

How the Feature Works

When you insert a picture into a cell, Excel stores it as a special data type, not just a floating shape. The image is anchored to that specific cell—if you filter the row, the picture hides; if you sort, it moves with the data. You can still resize the image by dragging its corners, but it will always stay within the cell boundaries unless you choose to let it overflow. The cell itself can hold text and a picture simultaneously, though the picture may cover the text if both are present. You can also use the =IMAGE("url") function to pull images from the web directly into a cell, which updates when the source changes.

How to Insert Pictures in Cells

The exact steps depend on your Excel version, but the main path is consistent. For Microsoft 365 (desktop and web):

Select the cell where you want the picture.
Go to Insert > Picture > Place in Cell.
Choose This Device to browse your files, or Stock Images for built-in options.
Select the image and click Insert. The picture appears in the cell, automatically resized to fit.

For Excel 2021 or older, you won’t have this feature. Instead, you can use the classic method: Insert > Pictures > This Device to place a floating image, then manually position it over a cell. That works but lacks the data-like behavior. If you need in-cell pictures in an older version, consider using the =IMAGE() function if you have Microsoft 365, or upgrade to a version that supports it.

Choosing the Right Image Format and Size

Not every image works well in a cell. Excel accepts common formats like PNG, JPG, GIF, and BMP, but PNG is usually best because it supports transparency and compresses well. Avoid huge images (over 10 MB) because they slow down the workbook. Aim for images that are roughly square or that match the cell’s aspect ratio. If your cell is narrow and tall, a wide landscape photo will be cropped or distorted. You can adjust the cell size to fit, but it’s easier to resize the image before inserting. For logos or icons, use small, clean PNGs. For photos, compress them to under 1 MB for better performance.

Common Problems and How to Fix Them

Picture doesn’t move with sort/filter: This happens if you used the old floating method. Use Place in Cell instead.
Cell shows a placeholder icon instead of the image: This occurs when the workbook is opened in an older Excel version or when the image link is broken. Re-insert the picture or check the file path.
Image is too large or too small: Right-click the cell, choose Format Picture, and adjust the size under the Size & Properties tab. Or resize the cell itself.
Can’t see the picture in the formula bar: That’s normal—the formula bar shows the cell value (like text), not the image. The picture is an overlay, not a character.
Picture disappears when filtering: This is actually expected behavior—the picture is tied to the row, so it hides when the row is hidden. If you don’t want that, use a floating picture instead.

Comparisons: In-Cell vs. Floating vs. Comment Pictures

In-cell pictures are the best choice when you need the image to behave like data—sorting, filtering, and using in formulas. They’re also easier to manage because they stay in one place. Floating pictures are more flexible for design—you can overlap them, rotate them, and place them anywhere on the sheet. They’re better for dashboards or decorative elements. Comment pictures are useful for adding a visual note that doesn’t clutter the grid—hover over the red triangle to see the image. They’re not ideal for viewing multiple images at once. For most data-driven uses, in-cell wins. For presentations, floating might be better. For quick annotations, comments work.

Costs and Requirements

The in-cell picture feature is part of Microsoft 365, which requires a subscription (personal or business). If you have a perpetual license like Office 2021, you won’t get this feature unless you upgrade. There’s no extra cost beyond the subscription. The =IMAGE() function also requires Microsoft 365. If you’re using Excel for the web, the feature is available with a free Microsoft account, but you may have limitations on file size and image sources. For organizations, IT admins may need to enable the feature in some cases, though it’s typically on by default.

Safety and Privacy Considerations

When you insert a picture from your device, Excel embeds the image data into the workbook file. That means the file size increases, and if you share the workbook, the image goes with it. Be cautious with sensitive images—if you don’t want them shared, don’t insert them. For images from the web using =IMAGE(), the URL is stored in the formula, and Excel fetches the image when the file opens. If the URL is to a private server, anyone with the workbook can see the URL and potentially access the image if they have permissions. Also, stock images from Microsoft are royalty-free for most uses, but check the license if you plan to use them commercially. Always ensure you have the right to use any image you insert.

Frequently Asked Questions

Can I insert multiple pictures at once into different cells?

Yes, you can select multiple cells and insert multiple pictures at once, but they will all go to the same cell. To place different images in different cells, you need to insert them one by one, or use a VBA macro to automate the process. There’s no built-in bulk insert that maps images to specific cells.

Why can’t I see the “Place in Cell” option?

This option only appears if you have Microsoft 365 and the feature is enabled. If you’re using an older Excel version or a free web version without a Microsoft account, you won’t see it. Check your Excel version by going to File > Account. If you have Microsoft 365 but still don’t see it, try updating Excel to the latest version.

Can I use a picture in a cell in a formula?

Yes, you can reference the cell containing the picture in formulas, but the picture itself isn’t a value. For example, you can use =A1 to return the cell’s text, but not the image. However, you can use the IMAGE function to embed a picture based on a URL that you build with a formula, like =IMAGE("https://example.com/"&A1&".png").

Will the picture print when I print the worksheet?

Yes, in-cell pictures print by default. If you don’t want them to print, you can set the print area to exclude those cells, or change the picture’s properties to not print (right-click the cell, go to Format Picture, and uncheck “Print object” under the Properties tab).

Can I convert a floating picture to an in-cell picture?

No, there’s no direct conversion. You’ll need to delete the floating picture and re-insert it using the “Place in Cell” option. Or, you can use a workaround: copy the floating picture, then paste it into a cell using “Paste Special” > “Picture” > “Place in Cell” in newer versions.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →