How to Insert an Image Into a Cell in Excel Properly

In Excel for Microsoft 365 on Windows, select a cell, then choose Insert > Pictures > Place in Cell > This Device. Pick an image and select Insert. Excel places the picture inside the selected cell so it can move and resize with that cell, rather than sit above the worksheet as a separate floating object. You will need an image file and a workbook where you can edit the sheet.

What You’ll Need

An editable Excel workbook in Microsoft Excel for Microsoft 365. The newer Place in Cell command is not available in every older Excel version or update channel.
An image saved somewhere you can browse to, such as a PNG or JPEG file on your computer. A clear, reasonably sized image is easier to fit and work with.
A worksheet cell intended to hold the image. Decide which column and row it belongs in before inserting, especially if the sheet has headings or records.

Step-by-Step

Open the workbook and choose the destination cell. Go to the worksheet where you want the picture. Click the cell that should contain it, such as B2 beside the first product name. The cell needs to be selected before you choose the Place in Cell command; clicking the general worksheet area may insert a floating picture instead.
Open the picture insertion menu. On the ribbon, select Insert > Pictures > Place in Cell > This Device. The labels may appear on more than one line in the Pictures menu. Choose This Device to browse to a file stored on your computer. If your ribbon is narrow, widen the Excel window or open the Pictures dropdown to see the available choices.
Choose the image file. In the file-selection window, browse to the folder, click the picture, and select Insert. Use a standard image such as PNG or JPEG when possible. If you are inserting a logo, a PNG can preserve transparent areas; for a photograph, JPEG is often a practical choice. The image is placed in the selected cell, usually scaled to fit the cell’s available space.
Check that it is an in-cell picture. Click a different cell, then click the picture. An in-cell image is treated as the content of its cell: it is associated with a cell address and changes position with the cell when rows or columns move. A floating image instead sits over the grid and can cover several cells. If you see the floating version, select it and look for Picture Format > Place in Cell on the ribbon to convert it.
Adjust the row height and column width. A picture can only display as large as the cell area allows. Drag the boundary between column letters to widen the column, or drag a row boundary to increase row height. For a specific size, select the row or column and use Home > Format to choose Row Height or Column Width. These settings affect the whole row or column, so check that nearby content still fits.
Review the picture’s crop and proportions. Excel fits the image within the cell, but the amount visible depends on the picture’s shape and the cell’s shape. A wide photo in a narrow cell may look small or have a less useful composition. Make the cell wider or taller to suit the picture. Avoid stretching a photo by resizing only one dimension of the cell until the subject looks distorted; use a cell shape that gives the image enough room.
Repeat for other records. Select the destination cell for each additional image and repeat the insertion steps. Keep each image in the row that contains its related item, person, or location. If you have many pictures, insert them one at a time and verify the cell address after each insertion. That small check helps prevent an image from being associated with the wrong record.
Save and test the sheet. Press Ctrl+S on Windows, then try sorting or filtering a small table if that is how the sheet will be used. In-cell pictures are designed to stay with their cell content, unlike many floating pictures. Test on a copy first if the worksheet is important, particularly when it contains formulas, merged cells, or a carefully arranged print layout.

On Excel for the web, look under Insert > Picture for the in-cell option; the exact menu wording can differ from the Windows desktop ribbon. On a Mac, open the Insert tab and inspect the Pictures menu for Place in Cell. Microsoft updates features over time, and availability can depend on your Excel version and update channel. If Place in Cell is not offered, use the floating-picture fallback described below and set its cell behavior.

To convert a picture already on the sheet, click it and choose Picture Format > Place in Cell if that command is available. If it is not, you can keep the image as a floating object and use Picture Format > Size & Properties or the Format Picture pane to set it to Move and size with cells. That makes the object follow cell changes, but it is not the same as storing the picture as cell content. Menu wording may vary by platform or update.

Common Mistakes

Choosing the wrong picture command. Insert > Pictures can offer options that place an image over the worksheet. Choose Place in Cell, not a standard floating-picture option, when the goal is cell content. If the image covers gridlines and overlaps neighboring cells, check whether it was inserted as a floating object.
Trying to resize the image without changing the cell. An in-cell picture is constrained by its row and column. If it looks too small, enlarge the cell by changing row height or column width rather than dragging the picture as if it were an independent object.
Putting the picture in the wrong row or column. A picture can look visually close to the right record while actually belonging to the cell beside it. Confirm the selected cell before insertion and verify the picture’s cell association afterward.
Using merged cells as image containers. Merged ranges can make selecting, sorting, and adjusting layouts more difficult. For a structured list, use one ordinary cell per record and adjust its row and column instead of merging a large area to fit a picture.
Expecting a floating picture to behave like cell content. A picture placed over the grid may not sort or filter along with the corresponding row. Convert it with Place in Cell where available, or set its properties to Move and size with cells and test the behavior carefully.

Tips

Plan image dimensions in the table. Set a consistent column width and row height before adding a batch of pictures. A uniform image column makes a product list, staff directory, or inventory easier to scan.
Use descriptive file names. Names such as blue-mug.jpg are easier to identify in the file picker than a series of generic names. This is especially helpful when selecting many similar images.
Keep the source files accessible. The workbook should retain its inserted pictures when saved, but keep original files if you may need to replace or edit them later. Store the workbook in a location where collaborators can access it, and confirm that it opens correctly after sharing.
Consider accessibility. A picture alone may not tell every reader what a row represents. Keep a text label in another column, such as a product name or employee name. When using floating images, add alternative text through the picture’s context menu or Picture Format tools if available; the steps can vary by Excel version.
Check print and screen views separately. A row height that looks good on screen may use more printed pages than expected. Use File > Print to preview the sheet and adjust scaling or page layout if the image column makes the table too wide.

Troubleshooting

I cannot find Place in Cell. Confirm that you are using a current version of Excel and that the desktop app is updated. The command may not appear in older perpetual-license versions, older builds, or some platform update channels. Check the Pictures dropdown under Insert and, for an existing picture, the Picture Format tab. If the feature is unavailable, insert a regular picture and use the Format Picture pane to choose Move and size with cells. This is a useful fallback, but it remains a floating object rather than true cell content.

The picture is too small or appears cropped. Increase the destination row height or column width, then check the displayed image again. A cell’s proportions affect how a picture fits; try a wider column for landscape photos or a taller row for portrait images. If the file itself has a large blank border around the subject, crop the source image in an image editor and insert the cleaner version.

The image covers other cells or moves independently. It was likely inserted as a floating picture. Select it and use Picture Format > Place in Cell if available. Otherwise open the Format Picture pane and set the object to Move and size with cells. This keeps it aligned as the grid changes, but sorting and filtering may not treat it exactly like an in-cell picture, so test those actions on a duplicate sheet.

The file will not insert. Check that the file opens outside Excel and try a common format such as PNG or JPEG. If the image is stored online or on a drive that is currently disconnected, copy it to a local folder and try again. Very large image files can also slow a workbook; resize or compress a copy of the image before inserting it.

The image does not stay with the right row after sorting. Confirm that it is truly an in-cell picture, not a floating object, then test sorting on a small copy of the table. Avoid merged cells in the data range and keep each image in the same row as its related values. If a workbook was created in another Excel version or is being edited in a different spreadsheet program, check how that program handles in-cell images before relying on the sort.

Frequently Asked Questions

Can I insert a picture into a cell without it floating over the worksheet?
Yes. Use Insert > Pictures > Place in Cell > This Device in a supported Excel version. This places the picture in the selected cell. If you only use a standard picture insertion command, Excel may create a floating object instead.

Can I put more than one image in the same cell?
An in-cell picture is intended to occupy the cell’s image content, so plan on one picture per cell. To show several images, use separate adjacent cells or create a combined image file before inserting it. Keep any labels or descriptions in neighboring cells.

Will an in-cell image move when I sort the table?
In-cell pictures are associated with their cells and are intended to stay with the corresponding row when data is rearranged. Check that the picture was inserted with Place in Cell, keep the data range structured consistently, and test on a copy if sorting is essential to your workflow.

Can I resize the picture independently of the cell?
Not in the same way as a floating picture. An in-cell image is limited by its cell’s dimensions, so adjust the row height or column width to change the displayed area. A floating picture can be resized separately, but it is less reliably tied to a record.

Can I insert a picture into a cell in older Excel versions?
Older versions may not have the Place in Cell feature. Insert the picture as a floating object, align it over the intended cell, and set its properties to Move and size with cells if that option is available. Upgrade or open the workbook in a supported Microsoft 365 version if true in-cell behavior is required.

Does inserting a picture change the cell’s text or number?
For an in-cell picture, the picture is the cell’s content, so it is not a way to keep ordinary text and an image together in the same cell. Put the description in a neighboring cell, or use a floating picture if you need an overlay. Keeping labels in their own cells also makes a table easier to sort, filter, and read.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.