Excel Table Image: How to Insert and Manage Pictures

To put a picture in an Excel table, select a cell and choose Insert > Pictures > Place in Cell, then select the image file. The picture becomes cell content, so it stays with its record when you sort or filter the table. If you want a screenshot of the table instead, use Excel’s Copy as Picture command.

What “Excel table image” can mean

The phrase can refer to two different tasks: adding pictures to a spreadsheet table, or turning a range of cells into a single image. The right method depends on what you need to do with the result. Product photos, employee portraits, and thumbnail previews belong in individual cells; a chart-like snapshot of a finished report is better copied as a picture.

Excel distinguishes between an image in a cell and an image that floats over the worksheet grid. An in-cell image is stored as the content of one cell, much like text or a number. A floating image is a separate object layered over the sheet; it can cover several cells and may not stay associated with the right row when the table changes.

This distinction matters most in tables that people sort, filter, or update. For a list of products, for example, put each product photo in the same row as its name and price. The picture can then travel with that row. For a one-time document or presentation, a static picture of the whole table may be simpler.

Insert a picture into a table cell

In Excel for Microsoft 365 on Windows, first make sure the worksheet has the table and the target column where you want the pictures. A column heading such as “Photo” makes the purpose clear. Then insert the images one at a time:

Select the cell in the table row where the picture should appear.
On the ribbon, choose Insert > Pictures > Place in Cell > This Device.
Choose an image file and select Insert.
Repeat for other rows, checking that each photo lines up with the correct record.

The exact choices under Pictures can vary with the Excel update and the source you choose. Excel may offer other locations, such as stock images or online sources, depending on the installation. If you already inserted a picture as a floating object, right-click it and choose Place in Cell when that command is available. The image is then moved into the cell beneath it, rather than remaining an object over the grid.

For a table with many rows, prepare filenames and records carefully before inserting images. Excel does not infer which local photo belongs with which product just from similar names. Work row by row, or use a consistent naming scheme and verify the completed column against the table’s identifying information.

In-cell pictures versus pictures over cells

Use an in-cell image when the picture is part of a record. It can be selected as cell content and is associated with that cell’s row. When a table is sorted or filtered, the row’s image stays with the other values in the record. This makes the in-cell option a practical choice for catalogs, directories, and inspection lists.

A floating picture is useful when you need more freedom to position or layer an illustration, such as a logo in a worksheet heading. It is not inherently attached to a particular data record. If rows are sorted, resized, or hidden, its apparent position can become confusing unless its object properties are set appropriately. If you right-click an image and see Place in Cell, you can convert it; the reverse command, Place over Cells, returns it to a floating object.

Neither type turns a picture into searchable text. A photo of a label does not automatically become the label’s words in the adjacent cells. Keep important information—such as a product code, name, or status—in ordinary text columns so that it can be searched, sorted, filtered, and read by assistive technology.

Use an image URL with the IMAGE function

If the images are available at public web addresses, the IMAGE function can display them from a URL instead of inserting each local file manually. It is available in Microsoft 365, Excel for the web, and Excel 2024. The source must be an accessible HTTPS image URL; a local file path is not a substitute for a web address, and sign-in-protected sources may not load.

For example, with an image URL in A2 and the output cell in B2, enter =IMAGE(A2,"Blue mug",0) in B2. The cell displays the image from A2, uses “Blue mug” as its alternative text, and uses sizing option 0 to fit the image inside the cell while preserving its proportions. If the URL is in a table column, you can use the same approach in the corresponding image column and fill the formula down, checking that each row refers to its own URL.

IMAGE is convenient when a list of URLs is already maintained, but it depends on network access and a valid image response. If a link is broken, redirects unexpectedly, or points to a page rather than a directly retrievable image, the picture may fail to appear. For a workbook that must work offline, inserting and embedding the image files is generally more dependable than relying on remote links.

Size and organize the image column

Pictures can look tiny or uneven if the cells are too small. Increase the width of the image column and the height of its rows until the image is legible. With an in-cell picture, the displayed image is constrained by the cell; it does not create a larger independent object. For a consistent catalog, use a uniform row height and column width, then review several images with different shapes to make sure the result is acceptable.

Images with different aspect ratios may occupy the available cell area differently. A wide landscape photo and a tall portrait photo will not look equally large when each preserves its proportions. If visual consistency is important, crop or resize the source images to a common shape before adding them. Avoid enlarging small source images too much, since that can make them appear blurry.

Give the column a descriptive heading and keep the image near the identifying text it supports. For accessibility, add useful alternative text where the image type and Excel version allow it. Describe relevant information rather than writing “image”; for example, “Blue ceramic mug, side view” is more informative. If the picture is purely decorative, make sure the data is still understandable without it.

Keep pictures with sorted and filtered records

A frequent reason to choose Place in Cell is to keep photos aligned with table data. If a product table has columns for item number, name, price, and photo, sorting by price rearranges the records. An in-cell photo is part of its row, so it follows that row. Filtering out some products hides their rows and pictures together.

Floating images can cause a common mismatch: the table rows move or become hidden, but an image object remains positioned over a different part of the sheet. A picture may have object-position settings that affect how it behaves when cells move or resize, but those settings do not make a floating picture equivalent to cell content. Converting record photos to in-cell images is the clearer solution when records will be rearranged.

Before sharing a table, test it by sorting on a column with distinct values and confirming that each photo remains beside the correct record. Then undo the sort or restore the intended order. This simple check can catch a misplaced image before someone relies on the workbook.

Copy an Excel table as a single image

To create a snapshot rather than a set of editable pictures, select the cell range you want to show. On Windows, use Home > Copy and open the Copy menu, then choose Copy as Picture. In the dialog, select whether the copy should reflect how the range appears on screen or how it will look when printed, and choose the picture format. Paste the result into a document, presentation, or another application that accepts images.

A copied table image is a snapshot: changing the source cells later does not update the pasted picture. It is useful for a report that needs a fixed visual, but it is not a replacement for the workbook when recipients need to filter, calculate, or edit the data. Keep a copy of the underlying spreadsheet if the values may need checking or revision.

On Mac, ribbon labels and keyboard shortcuts can differ from Windows, and availability can depend on the Excel version. Look for the Copy as Picture command in the Copy menu rather than assuming a Windows shortcut will work. Excel for the web can also differ from the desktop app in picture insertion and copy options; if a command is missing, use the Windows desktop app for the steps above.

Common problems and file considerations

If Place in Cell is missing, confirm that you are using a supported, updated Excel version and that you have selected an image or the intended cell. Features can roll out at different times, and older perpetual editions may not include the same tools as Microsoft 365. On Mac or Excel for the web, menus and feature availability may also vary by update. If you cannot use in-cell images, a floating image is a fallback, but check its alignment after sorting or changing row heights.

The picture is not visible: check the row height and column width, confirm the source file or URL is available, and make sure the cell is not obscured by another object.
The wrong picture is beside a record: compare the image with the row’s ID or name, especially after sorting or inserting several files.
The workbook has become large: high-resolution photos can add substantial file size. Resize or compress source images when full camera resolution is not needed.
The image disappears after sharing: save the workbook in a format that preserves Excel features, such as .xlsx, and avoid converting an image-filled workbook to CSV. CSV stores plain tabular text, not embedded pictures.

Embedded images increase the workbook’s size, so consider whether every picture needs to be included. If recipients only need a visual reference, a smaller set of thumbnails may be enough. If they need to inspect fine detail, keep higher-resolution originals available separately and link or document where they can be found.

Frequently Asked Questions

Can I put a picture inside an Excel table cell?
Yes. In supported Excel versions, select the cell and choose Insert > Pictures > Place in Cell. This stores the image as cell content rather than as a floating object.

Will an image move when I sort an Excel table?
An image placed in the cell moves with that cell’s table row. A floating picture is a separate object and may not remain aligned with the record when the table is rearranged.

How do I turn an Excel table into a picture?
Select the range, choose Home > Copy > Copy as Picture, set the appearance options, and paste it into an application that accepts images. The pasted snapshot does not update when the worksheet changes.

Can Excel display a picture from a URL?
Yes, with the IMAGE function in Microsoft 365, Excel for the web, and Excel 2024. The link must provide an accessible image; protected or unsuitable URLs may not display.

Why can’t I see Place in Cell?
The command may not be available in your Excel version or current update, or the selected item may not be an image. Update Excel if possible; otherwise, insert a floating picture and check its alignment as the worksheet changes.

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.