Inserting Images in Excel: Steps, Sizing, and Tips

How-to basics · Updated November 20, 2026

To insert an image in Excel for Microsoft 365 on Windows, select the worksheet, choose Insert > Pictures > This Device, select the picture, and choose Insert. For a picture that should sit inside a cell and move or resize with it, use Insert > Pictures > Place in Cell and select a source.

Choose How the Picture Should Behave

Excel can treat a picture as an object placed over the worksheet grid or, in supported versions, as content within a cell. The distinction matters when you sort a table, change row heights, filter records, or share a workbook with someone who will edit its layout.

  • Picture over cells: The image floats above the grid. You can drag it freely, layer it with other objects, and adjust its size independently. This is useful for a logo, a decorative image, or a diagram positioned beside data.
  • Picture in a cell: The image belongs to a particular cell. It can follow that cell when rows or columns are moved, and it can be easier to manage in a table of product photos or employee headshots. Availability and exact options can depend on the Excel version.

Before inserting several images, decide which behavior fits the job. A catalog with one photo per product usually benefits from cell-based pictures. A dashboard with a logo in its header may be better served by a floating picture, since the logo does not represent one data record.

Insert a Picture Over the Worksheet

For a standard floating picture in Excel for Microsoft 365 on Windows, follow these steps:

  1. Open the worksheet and select the approximate area where you want the image. The selection is not a permanent anchor point, but starting near the destination makes placement easier.
  2. Choose Insert > Pictures > This Device.
  3. Browse to the image file, select it, and click Insert.
  4. Drag the picture to position it. Drag a corner sizing handle to change its size while keeping its proportions.

The picture is an object layered over cells, not data stored in the selected cell. It can cover values without deleting them. If a number or label seems to disappear after insertion, move the image aside to check whether the cell contents are underneath it.

The Insert > Pictures menu may also offer sources such as stock or online pictures, depending on the installed Excel version and available Microsoft 365 services. Online access, account settings, and organizational policies can affect what appears. Use an image you have permission to use, and consider whether an online source is appropriate for confidential workbooks.

Insert a Picture Inside a Cell

In versions that support it, choose Insert > Pictures > Place in Cell, then pick the available file or image source and select the picture. Excel places it in the active cell rather than leaving it as a freely floating object. The row height and column width determine how much of the picture is visible, so adjust them if the result looks too small.

You can also convert an existing floating picture in supported versions: select the picture, open its context menu, and choose Place in Cell if that command is available. The reverse command may appear as Place over Cells. Menu availability can vary with the update channel and Excel platform; if you do not see these commands, check that Excel is up to date or use a floating picture instead.

Cell-based pictures can be useful in structured data, but they do not turn an image into searchable text. A photo of a receipt, for example, will not automatically become the receipt amount in a neighboring cell. Add a separate text or numeric value when the workbook needs to sort, calculate, or report on that information.

Position, Resize, and Crop Pictures

For a floating picture, select it to display the Picture Format tab. Drag a corner handle to resize proportionally; dragging a side handle changes one dimension and can distort the picture. For more controlled sizing, use the Height and Width boxes on the Picture Format tab. When exact dimensions matter, check whether the aspect ratio is locked in the size options before changing only one measurement.

To show only part of an image, select it and choose Picture Format > Crop. Drag the black crop handles to define the visible area, then click outside the picture or choose Crop again to finish. Cropping changes what is displayed, but it is not the same as editing the original file in a photo editor. Use Reset Picture from the Picture Format options if you need to undo picture formatting or restore the original appearance.

For objects that should follow worksheet layout changes, select a floating picture, open its formatting pane, and find the size and properties options. Under Properties, Excel commonly provides choices to move and size the object with cells, move it without sizing it, or keep it independent of cells. These settings are useful when changing row heights or column widths. They do not make a floating picture cell content; they only control how the object responds to grid changes.

Keep Images Aligned with Table Data

Images in a list often need careful alignment. Set a consistent column width and row height, then use the same image dimensions or crop style for each entry. If each picture is floating, verify its object properties before sorting the associated rows. A picture set to remain independent of cells can become visually separated from the record it describes after a sort or layout change.

Cell-based pictures are often more convenient when each image belongs to a table row, but test the workflow with a copy of the data before applying it to a large catalog. Filtering hides rows, while sorting rearranges records; check that pictures remain associated with the intended items in the version of Excel used by the people who will edit the file. A workbook opened in an older or different spreadsheet application may not preserve newer picture features in the same way.

For example, a product table might have columns for SKU, description, price, and image. Keep the SKU and product information in ordinary cells so those values remain searchable and usable in formulas. Treat the picture as a visual aid, not a replacement for the identifying data.

File Types, Workbook Size, and Image Sources

Excel supports common picture formats such as JPEG and PNG, along with other formats depending on the platform and Office version. If Excel will not insert a file, try opening it in an image editor and saving a copy as PNG or JPEG. This can resolve unsupported-format or damaged-file problems, though it may remove features such as transparency or animation. Vector formats may be available in current desktop versions, but compatibility can differ across Excel releases and other spreadsheet programs.

Large, high-resolution pictures can make a workbook slow to open, save, upload, or email. Resize images to a sensible pixel resolution before inserting them if the workbook only displays them as small thumbnails. In desktop Excel, select a picture and look for Picture Format > Compress Pictures to reduce image data in the workbook. Read the dialog options carefully: compression can reduce visual quality, and applying it to all pictures may affect images that need to remain sharp.

Consider the image’s source as well as its size. Use pictures you created, licensed, or are otherwise permitted to use. For confidential material, avoid uploading it to an unapproved online service merely to convert its format. Keep a separate copy of important source images if you may need to replace or edit them later.

Common Insertion Problems and Fixes

  • The picture covers cells: This is normal for a floating picture. Move it, resize it, or use Place in Cell if that feature is available and the image belongs to a specific cell.
  • The image looks stretched: Resize from a corner handle, or check the picture’s aspect-ratio setting. Use Crop rather than dragging a side handle when you want a different framing.
  • The picture moves unexpectedly: Review its cell-related properties. A floating object may be set to move or resize when rows and columns change.
  • The file cannot be inserted: Confirm the file opens normally, then try a copy saved as PNG or JPEG. Also check whether the file is stored in a location you can access.
  • The workbook becomes too large: Reduce image dimensions or use picture compression, balancing smaller file size against the quality needed on screen or in print.

Excel on Mac and Excel for the Web

On a Mac, the ribbon layout and labels can differ from Windows. In Excel for Mac, use the Insert tab and its picture option, then choose the command for a picture from a file; available image placement and formatting features depend on the installed version. The Windows path Insert > Pictures > This Device may not appear with exactly the same wording. If you cannot find a command, use Excel’s ribbon search or consult the menu shown in your specific release.

Excel for the web also supports inserting pictures, but its available sources and picture controls can differ from desktop Excel. Some newer cell-picture features may not be available to every user or may behave differently across platforms. If the workbook will be edited on several devices, test the picture layout in those environments rather than assuming the desktop appearance will be identical everywhere.

Frequently Asked Questions

How do I insert a picture into an Excel cell?
In a version that supports cell pictures, choose Insert > Pictures > Place in Cell, then select an image source and file. If that option is missing, insert a floating picture and position it over the cell, or update Excel if your organization permits updates.

How do I insert multiple pictures in Excel?
Use the picture insertion command and select multiple files in the file picker if it allows multiselection, then insert them. You may need to arrange and resize each picture afterward. For a table of many pictures, standardize row heights and column widths before organizing the images.

How do I keep a picture from moving in Excel?
Select the floating picture and open its formatting options. Under object properties, choose the setting that does not move or size the picture with cells. The exact pane labels can vary by release. This keeps it independent of grid changes, though it can still be moved manually.

Can I put a picture behind text or cell values?
A normal inserted picture sits above the worksheet grid and may cover cell contents. You can move or resize it, or use a worksheet background for decoration where that feature suits the task. A background image is not a substitute for a picture attached to a particular record, and printing behavior may differ.

Can Excel read text from an inserted image?
Inserting an image alone does not convert its text into worksheet values. You may need an optical character recognition tool or manual transcription, then should check the extracted text for errors before using it in calculations or records.

Related

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.