How to Insert an Image in an Excel Cell and Resize It

How-to basics · Updated November 20, 2026

In Microsoft Excel for Microsoft 365 on Windows, select a cell, choose Insert > Pictures > Place in Cell, and pick an image. The picture becomes cell content and changes size when you resize that cell’s row or column. This is useful for product lists, staff directories, inventories, and other sheets where pictures should stay with their records when you sort or filter. You’ll need an image file and a workbook you can edit; save the workbook as an Excel file such as .xlsx to keep your changes.

What You’ll Need

  • Microsoft Excel for Microsoft 365: Use an up-to-date desktop version for the Place in Cell command described below. If you don’t see it, check for Office updates or use the floating-picture alternative in the steps.
  • An image file: Keep the image somewhere you can find it, such as a local folder. Common formats such as PNG and JPG work for typical pictures.
  • A worksheet layout: Decide which cell will contain the image and how large its row and column should be. If you are making a catalogue, plan a consistent size for all image cells.

Step-by-Step

  1. Select the destination cell. Open the workbook and worksheet, then click the cell where the picture should live. If the sheet has a label or product name in the same row, use the cell in a dedicated image column. For example, put the image in A2 and its matching description in B2. Keeping each image on the same row as its details makes the table easier to read and helps prevent mix-ups when sorting.
  2. Choose the in-cell picture command. On the Windows ribbon, open Insert > Pictures > Place in Cell. Choose This Device to browse for an image stored on your computer. Depending on your Excel build and available sources, the Pictures menu may also show options such as Stock Images or Online Pictures. Select the source that contains your image; do not choose a regular floating-picture option if you specifically want the picture stored in the cell.
  3. Pick and insert the image. Browse to the image, select it, and choose Insert. Excel places the picture in the selected cell. If you select several images at once, Excel may place them across cells; for a controlled table, insert one at a time and confirm each image’s position before continuing. If Excel opens a preview or selection window, choose the correct file and confirm rather than clicking a similarly named thumbnail by mistake.
  4. Check that the image is really in the cell. Click the picture. An in-cell image behaves as cell content, rather than as a separate object floating over the worksheet. You can also right-click an existing floating picture and choose Place in Cell when that command is available. If the picture moves independently across the grid when dragged, it is likely still a floating picture; use the Place in Cell command or follow the alternative method later in this guide.
  5. Make room by widening the column. Point to the boundary between the image column’s letter and the next column letter at the top of the sheet. Drag the boundary to the right to widen it. For a precise setting, select the column and choose Home > Format > Column Width, enter a value, and select OK. Column width is measured in Excel’s character-based units, not pixels, so adjust it until the picture has the space you want.
  6. Increase the row height. Point to the boundary between the row number and the next row number on the left, then drag downward. For a specific height, select the row and choose Home > Format > Row Height, enter a point value, and click OK. The in-cell picture adjusts with its cell. Change both the column width and row height as needed; changing only one dimension can leave the picture looking too small or the cell looking unusually narrow or tall.
  7. Set a consistent size for a list. If several pictures need matching boxes, select the relevant row numbers and set one row height through Home > Format > Row Height. Select the image column and set its width once. All selected rows and that column will have consistent cell dimensions, which gives a product list or directory a tidy appearance. Check a few images afterward because different source pictures may have different shapes or compositions.
  8. Finish the layout and save. Adjust nearby columns so text is not hidden, and use a suitable zoom level to review the sheet. Save with Ctrl+S on Windows. On a Mac, use Command+S. If you are sharing the workbook, reopen the saved file or check it in the intended Excel version to make sure the images and row sizes appear as expected.

Alternative for Excel versions without Place in Cell: Choose Insert > Pictures and insert the picture as a regular object. Resize it with the corner handles, then right-click it and select Format Picture. In the formatting pane, open Size & Properties > Properties and select Move and size with cells. This setting makes the floating picture move and resize with the underlying cells, but it is still an object over the grid, not image content in a cell. The exact pane layout can vary by Excel version. On Mac, use the Picture Format controls or the Format Picture pane, and look for the same move-and-size property.

Common Mistakes

  • Inserting a floating picture by accident. Excel’s Pictures options can include more than one way to add an image. Pick Place in Cell for an actual in-cell image. A floating picture can cover cells and may not travel with the intended record during sorting, even if it appears to sit inside a cell.
  • Resizing the picture instead of its cell. With an in-cell image, use the row height and column width to change its displayed area. Dragging picture handles is for selected floating pictures, not the normal way to resize an image stored in a cell.
  • Changing only the column width or only the row height. A cell’s shape affects how the picture appears. If it looks too squat, narrow, or cramped, adjust both dimensions gradually rather than making one extreme change.
  • Sorting only part of the table. An image can become separated from its description if you sort one column without the associated rows. Select the whole data range or convert it to a table before sorting, and confirm that each image and its related information stay together.
  • Expecting a picture to behave like a cell background. An in-cell image is content in a particular cell. It does not automatically become a background behind text in that cell. Keep labels in neighbouring cells if you need both a picture and readable text.

Tips

  • Prepare images before inserting them. Crop unnecessary margins and use a sensible image size in an image editor when files are very large. This can make a workbook lighter and make the subject easier to see. Keep an original copy if you may need to make a different crop later.
  • Use one image column. A dedicated column makes it easier to apply the same width and keep pictures aligned. Put names, descriptions, or IDs in adjacent columns, and keep each record on one row.
  • Keep the source images organized. Use clear filenames such as a product code or employee ID. This reduces the chance of inserting the wrong picture when several files look alike. Check the selected filename before confirming the insertion.
  • Test sorting and filtering on a copy first. In-cell images are designed to stay with their cells, but a quick check can reveal problems in a complicated range or mixed layout. If a record is split across separate ranges, bring the data into one well-formed table before sorting.
  • Use an appropriate cell size. A larger cell is not always better: it can make a worksheet cumbersome to scroll and print. Set a useful thumbnail size for the everyday view, and open the original image separately if readers need fine detail.
  • Consider accessibility and context. Add a nearby text label, such as a product name or image description, so the picture’s purpose is clear to readers and when the sheet is printed or viewed at a small zoom. Do not rely on the image alone to communicate an important value.

Troubleshooting

Place in Cell is missing. First confirm that you are using a current Microsoft 365 version of Excel and that you opened the desktop app rather than a limited editing view. Update Office, restart Excel, and check the Insert tab again. The command can differ by platform or build. If it remains unavailable, insert a regular picture and set its property to Move and size with cells, or use a version that supports in-cell pictures.

The picture appears over the grid or will not stay aligned. It was probably inserted as a floating object. Right-click it and look for Place in Cell. If that option is not present, use the floating-picture alternative above and set Move and size with cells. When sorting, include the complete table range; a floating object’s positioning settings alone do not fix a sort that excludes related columns.

The image looks too small, too large, or hard to recognize. Change the cell’s row height and column width, then review the result at normal zoom. Different image proportions can make subjects look different even when the cells have matching dimensions. Try a wider or taller cell, or prepare a better crop in an image editor and insert that version. Avoid stretching a floating picture by dragging a side handle if preserving its proportions matters; use a corner handle instead.

The row height or column width will not change. Check whether the worksheet is protected. A protected sheet may prevent formatting changes, in which case you need permission to unprotect it or change the sheet’s protection settings. Also check whether you selected the row or column headers before choosing the Format command; selecting a cell alone may not apply a size change to the whole row or column as intended.

The workbook becomes slow or large. Large, high-resolution images can add substantial file size. Use smaller copies for spreadsheet thumbnails and remove images that are not needed. If you insert many images, save the workbook and allow Excel time to finish processing before making further edits. Keep a backup before making bulk changes.

Frequently Asked Questions

Can I insert an image into a cell in Excel?
Yes. In supported Microsoft 365 versions, select a cell and choose Insert > Pictures > Place in Cell. If the command is unavailable, you can use a floating picture and set it to move and size with cells, but that is not the same as storing the picture in the cell.

How do I resize an image that is in a cell?
Change the cell’s dimensions. Drag the row and column boundaries, or use Home > Format > Row Height and Home > Format > Column Width. The in-cell picture adjusts to the available cell area.

Can I resize an in-cell image to an exact number of pixels?
Not by setting a separate pixel size on the in-cell picture. Its display follows the cell’s row height and column width, which use Excel’s own measurement units. Set the cell dimensions and check the visual result; use an image editor if the source itself needs an exact pixel size.

Will the image stay with its row when I sort?
An image placed in a cell is intended to behave as cell content, so it can stay with the record during sorting. Sort the full table or complete data range, not just one column. A floating picture may not follow the record correctly unless the range and object properties are handled carefully.

Can I do this in Excel for Mac or Excel for the web?
Ribbon names and feature availability can vary by platform and update. On Mac, check the Insert tab for a Pictures option that includes Place in Cell; if it is missing, update Excel or use the floating-picture method. In Excel for the web, use the available Insert picture options and check whether Place in Cell is offered in your account. When it is not, edit the workbook in a supported desktop version.

Can I put more than one picture in the same cell?
A cell is not a gallery: use one in-cell image per cell. To show several pictures, place them in separate cells or use a separate worksheet for a larger gallery. This keeps the layout predictable and makes each image easier to associate with its own label.

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.