How to Insert Images in an Excel Table

To insert an image into an Excel table, select the destination cell, choose Insert > Pictures > Place in Cell > This Device, select the picture, and choose Insert. The image will sit inside the cell rather than float over the worksheet, so it stays associated with its row when you sort or filter. If you have not made a table yet, convert your data range into an Excel Table first.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows, with the latest updates installed. The Place in Cell feature may not appear in older or out-of-date Excel versions.
A workbook with a column reserved for pictures, such as a Product Image or Employee Photo column.
Image files you can access, such as JPG or PNG files. Keep the pictures in a known folder if you plan to insert several.
Optional: a table of records with a header row. You can insert pictures into ordinary worksheet cells too, but a formatted Excel Table makes sorting and filtering the records easier.

Step-by-Step

Prepare your data and image column. Put one record on each row, with headings in the first row. For example, a product list might have Product, SKU, Price, and Product Image headings. Leave a blank cell under the image heading for each record. If your data is already organized as an Excel Table, use its image column; otherwise, select a cell in the data and press Ctrl+T on Windows. Check that My table has headers is selected if your first row contains headings, then choose OK. On Mac, press Command+T to create a table. Make sure each image will have its own row and its own cell; do not merge cells in the table.
Select the cell for the first image. Click the blank cell on the correct record’s row, below the image heading. Confirm the row before inserting, especially if the table is sorted or filtered. The image is placed into the active cell, so selecting the header or a neighboring record can put it in the wrong location. If the table has filters applied, check that you are working on the intended visible record.
Choose the in-cell picture command. On the Windows ribbon, select Insert > Pictures > Place in Cell > This Device. Browse to the image file, select it, and choose Insert in the file picker. The exact wording of the picker can vary slightly by Excel update. If you want a picture from another supported source, check the other options under Place in Cell; availability depends on your Excel version and account. Avoid choosing a regular floating picture command if you want the picture to behave as cell content.
Check that the picture is inside the cell. Excel should size the picture to fit within the selected cell. Click the picture: an in-cell picture is selected as the cell’s content, whereas a floating picture can be selected and dragged independently over the grid. If you accidentally inserted a floating picture, select it and look for Picture Format > Place in Cell. Choosing that command converts the selected picture to an in-cell image. In some builds, you can also right-click a cell and choose Paste Picture in Cell after copying an image.
Adjust the row and column dimensions. In-cell pictures are constrained by the cell’s size. If the image looks too small, widen the image column by dragging the boundary between its column letters, or select the row and increase its height by dragging the boundary between row numbers. For a specific size, use Home > Format to access the row-height and column-width commands. Excel preserves the picture’s proportions when it fits the image into the cell; making the cell larger gives it more room, but does not necessarily make every picture fill the entire cell.
Insert the remaining pictures in the matching rows. Repeat the selection and insertion process for each record, checking that the picture matches the name, item number, or other identifying information in that row. If you select several destination cells first, do not assume one image will automatically be matched to each row. Insert pictures deliberately, one at a time, unless your version offers a bulk workflow that you have confirmed works with your file arrangement. For a small catalog, careful individual placement is often the safest approach.
Test the table before relying on it. Sort by a different column or apply a filter, then confirm each picture remains with its corresponding record. If the rows move but the pictures do not, they may be floating objects rather than in-cell pictures. Undo the test or clear the filter when finished. Save the workbook, then close and reopen it if the images are important; this helps confirm they display as expected after the file is reopened.

Common Mistakes

Using Insert Picture instead of Place in Cell. A regular inserted picture floats above the worksheet grid. It may cover cells and can appear detached from records when rows are sorted, resized, or filtered. Use the explicit Place in Cell command, or convert the existing picture with Picture Format > Place in Cell.
Inserting into the wrong row. Pictures are easy to misassign when the table is sorted, filtered, or scrolled. Check a unique value in the same row before inserting, and verify the pairing afterward. Do not rely on the screen position alone if rows are hidden by a filter.
Expecting a thumbnail to fill a cell automatically. The picture must fit inside the cell boundaries. A narrow column or short row can make a clear image look like a tiny thumbnail. Resize the row or column, then check whether the image is legible without making the worksheet unwieldy.
Merging cells in the image column. Merged cells can interfere with table structure and sorting. Keep one picture in one ordinary cell and one record per row. If a larger display is needed, increase the row height instead of merging cells.
Using very large image files unnecessarily. High-resolution photos can make a workbook slow to open, edit, or share. Resize or compress copies of the pictures before inserting them when their full original resolution is not needed, and keep a separate original if image quality matters.

Tips

Standardize picture dimensions before inserting. Crop or resize copies so they have similar proportions. Excel can fit different shapes into cells, but consistent source images make a catalog look more orderly. Keep a backup of originals if you crop them outside Excel.
Use clear, consistent filenames. Names such as SKU-1042.jpg are easier to match to records than names such as IMG_5831.jpg. A filename convention does not replace checking the row, but it reduces the chance of selecting the wrong file.
Make the image column wide enough to be useful. A column that is too narrow can turn every picture into an unhelpful sliver. Set a practical width and row height, then use the same dimensions for all records. You can select several rows and adjust their height together.
Keep the table’s structure simple. Use one header row, avoid blank rows inside the data, and put one record on each row. This makes filters and sorting easier to use and gives each picture a clear relationship to the other fields.
Use descriptive alternative text when appropriate. For a picture that communicates important information, add alt text through the picture’s accessibility or alt-text controls if available in your Excel build. A short description can help people using screen readers understand what the image represents.
Save in a format that supports your workbook features. For a normal Excel workbook, save as an .xlsx file. If the workbook contains macros, use a macro-enabled format such as .xlsm instead. Avoid exporting to CSV if you need to preserve pictures, formatting, or the table itself; CSV stores plain text values, not embedded images.

Troubleshooting

Place in Cell is missing. First check that you are using an updated version of Excel for Microsoft 365. Select the Insert tab and open the Pictures menu; the command may be nested under its dropdown. If it remains unavailable, your Excel release, update channel, or organizational settings may not include the feature yet. Update Office if permitted, or use a floating picture as a temporary alternative and keep it aligned manually. On Mac or Excel for the web, the menu labels and availability can differ by build; check the Insert tab for a Place in Cell option.
The picture covers cells or moves separately. It was probably inserted as a floating object. Select it, open Picture Format, and choose Place in Cell if that command is available. If the image is already in the cell, clicking it should select the cell content rather than let you drag the picture freely over the sheet. Retest by sorting a copy of the table or using Undo immediately if the result is wrong.
The image is too small, clipped, or hard to recognize. Increase the row height and column width, then check the picture again. If the source image has a very wide or tall shape, it may still have unused space inside the cell because Excel maintains its proportions. Crop a copy to a more suitable shape or use a larger cell. Avoid stretching the picture out of proportion.
The picture appears beside the wrong record after sorting. Confirm it was inserted with Place in Cell, not left as a floating object. If the image is in-cell but the association is still incorrect, the image may have been assigned to the wrong row before the sort. Undo the sort if possible, verify records using a unique ID, and correct the image placements. When using a floating-picture workaround, set its placement properties so it moves and sizes with cells, but recognize that this is less reliable than using in-cell images.
The workbook becomes slow or large. Reduce the dimensions or file size of the source images and remove duplicates you no longer need. Save, close, and reopen the workbook to check whether performance improves. If you share the file, test a copy on the recipient’s Excel version; a feature that is not supported in that version may not behave the same way.

Frequently Asked Questions

Can I put an image inside an Excel table cell?
Yes. In supported Excel versions, select the cell and use Insert > Pictures > Place in Cell. The image becomes associated with that cell instead of floating above the worksheet.

Will an in-cell picture move when I sort or filter a table?
It is designed to stay with its cell and record when table rows are rearranged. Test the behavior with a small sample first if the workbook will be used in older or mixed Excel versions.

Can I turn a floating picture into an in-cell picture?
Usually, yes. Select the picture and choose Picture Format > Place in Cell. The command may be unavailable in older or unsupported builds. After conversion, check that the image is in the intended row.

Can one cell contain more than one picture?
An in-cell picture is intended to be the picture content of a single cell. For several pictures, use separate rows or columns, or create a composite image outside Excel and insert that as one picture.

Can I insert images into cells in Excel for Mac or Excel for the web?
Availability depends on the Excel version and update. In current versions that support the feature, look under Insert > Pictures for Place in Cell. If the command is absent, update Excel where possible or use a floating picture as a workaround.

Will pictures remain if I save the table as a CSV file?
No. CSV files do not preserve embedded pictures, table formatting, or other workbook features. Save as an Excel workbook, such as .xlsx, to keep the images.

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.