How to Insert an Image in an Excel Cell and Make It Fit

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select a cell, choose Insert > Pictures > Place in Cell, then choose the image source and file. Excel puts the picture in the selected cell and adjusts it to the cell’s space. If Place in Cell is unavailable, insert a regular picture, resize it over the cell, and set it to move and size with cells.

Before inserting, decide whether the image should behave like cell content—for example, stay associated with a product row when you sort—or simply sit over the grid. The first method is usually best for lists and catalogs. The second is useful when you need more control over cropping or placement.

What You’ll Need

  • An Excel workbook and the image file you want to use, such as a JPG or PNG.
  • A worksheet with the target cell identified. For a catalog, make the image column wide enough and the rows tall enough to see the pictures.
  • Excel for Microsoft 365 on Windows for the Place in Cell directions below. The feature may not appear in older perpetual versions or in every update channel; use the floating-picture alternative if it is missing.

Step-by-Step

  1. Choose the destination cell. Open the worksheet and click the cell where the image should go. If you are adding several pictures, set up one image column first and plan to put one picture in each row. Keep any names, descriptions, or other data in separate columns so each picture stays associated with the right record.
  2. Make the cell area usable. Widen the image column by dragging the boundary between its column letters. Increase a row’s height by dragging the boundary below its row number. For exact dimensions, select the column or row, open Home > Format, and choose Column Width or Row Height. Choose dimensions that make the image easy to recognize without making the sheet cumbersome to scroll.
  3. Insert the image into the cell. With the destination cell selected, go to Insert > Pictures > Place in Cell. Choose This Device to browse for a file on your computer, select the picture, and choose Insert. Depending on the Excel build and available sources, the Pictures menu may also offer online or stock image options. The important choice is Place in Cell rather than the regular picture insertion command.
  4. Check the result in the grid. The image should appear within the selected cell rather than as a separate object that you can freely drag over the sheet. If the image looks too small, enlarge the row or column. If it looks awkwardly cropped or its subject is hard to see, try a different cell shape or use an image with a more suitable aspect ratio. The cell’s dimensions determine how much space is available.
  5. Adjust the row and column for consistent sizing. For a catalog, select all the image rows and use Home > Format > Row Height to give them the same height. Set the image column’s width as well. Uniform cells make the list easier to scan. If a row contains wrapped text or other content, check that increasing or standardizing the height does not hide that information.
  6. Convert an existing floating picture if needed. If you already inserted a picture as an object, select it and look on the Picture Format tab for Place in Cell. Choose that command to move the picture into the active cell. The command may be unavailable for some picture types or in older Excel builds. If you cannot find it, use the floating-picture method in the next step instead.
  7. Use a floating picture when you need manual positioning. Choose Insert > Pictures and insert the file as a regular picture, then drag it over the intended cell. Resize from a corner handle to preserve the image’s proportions; dragging a side handle can stretch the subject. To control how it responds to grid changes, right-click the picture, choose Format Picture, open Size & Properties, expand Properties, and select Move and size with cells. Adjust the row or column afterward to check its alignment.
  8. Save and test the layout. Save the workbook, then change a row height or column width slightly. An in-cell image remains part of its cell; a floating picture set to Move and size with cells should move or resize along with the grid. If the sheet will be sorted or filtered, test a small sample before applying the operation to the full list, especially if you used floating pictures.

Mac and Excel for the web: The ribbon and feature availability can differ by platform and update. In Excel for Mac, check Insert > Pictures for a Place in Cell choice; if it is not shown, insert a regular picture and use the floating method, where available, or open the workbook in an up-to-date Microsoft 365 version that offers in-cell pictures. Excel for the web may show different picture sources or commands. If you cannot see Place in Cell, do not assume a regular inserted picture is already part of the cell; use the available in-cell command or make the picture move and size with its cell.

Common Mistakes

  • Choosing the wrong insertion command. Regular Insert > Pictures adds a floating object over the worksheet. It can look as though it is inside a cell, but it is not cell content. Use Place in Cell when you want the image tied to a cell.
  • Making the cell too small. A narrow column or short row leaves little room to display the picture. Widen the column and increase the row height before deciding that the image file itself is the problem.
  • Dragging a side handle to force a fit. This can distort faces, logos, or product shapes. Preserve proportions by dragging a corner, or alter the cell dimensions to better suit the picture.
  • Assuming every image will look good in the same rectangle. A tall portrait and a wide landscape image need different proportions. A consistent catalog layout may require choosing similarly framed images or accepting that some subjects appear smaller.
  • Sorting only part of the data. If pictures and descriptions are in separate ranges, sorting one column alone can disconnect images from their records. Select the full data range, including the image column, before sorting.
  • Expecting a floating image to follow cells automatically. A picture may remain in place when rows or columns change unless its properties are set appropriately. For a floating picture, check Move and size with cells.

Tips

  • Set up a repeatable catalog layout. Decide on the image column width and row height before adding many pictures. Apply the same dimensions to the full set of rows, then insert images into their matching records. This reduces later adjustment and makes the sheet more consistent.
  • Prepare images with similar framing. If the important subject is near the edge, a tight cell fit may make it hard to see. Crop or reframe the source image before inserting it, or choose an image where the subject is centered with a little space around it.
  • Keep the original files organized. Use clear filenames that match product IDs or record names. This makes it easier to identify the right image when inserting or replacing pictures, especially in a large worksheet.
  • Use in-cell pictures for sortable data. When the feature is available, placing pictures in cells is generally more reliable than manually aligning floating objects in a table. Still, verify a small sort or filter operation first, and keep the image column inside the same table range as the related data.
  • Consider workbook size. Large, high-resolution images can make a workbook slow to open, save, or share. Use appropriately sized copies for worksheet display rather than inserting unnecessarily huge originals. Keep separate full-resolution files if you need them for another purpose.
  • Make the sheet readable for other people. Add a nearby text label or product name instead of relying on the image alone. For floating pictures, use the picture’s Alt Text option if your workflow supports it, so people using assistive technology can understand its purpose.

Troubleshooting

  • Place in Cell is missing. Confirm that you are using a Microsoft 365 build that supports the feature, and check the Pictures menu on the Insert tab rather than looking only for a general picture button. Update Office if your organization allows it. If the command remains unavailable, use a regular picture and set its placement properties, or open the workbook in a supported current version.
  • The image appears over the grid instead of inside the cell. It was likely inserted as a regular picture. Select it and check Picture Format for Place in Cell. If that command is not available, remove it and insert it again using Insert > Pictures > Place in Cell, or keep it as a floating picture and set Move and size with cells.
  • The picture looks too small or hard to identify. Increase the row height or column width, then reassess the display. If the cell is already large, the source image may have a wide border or a subject that occupies only a small part of the frame. Use a tighter crop or a better-framed source rather than stretching the image out of proportion.
  • The picture looks stretched. For a floating picture, undo the last resize if possible and use a corner handle instead of a side handle. If it is an in-cell picture, adjust the row and column proportions or replace the source with an image closer to the cell’s shape. Avoid trying to make a portrait image fill a wide rectangle by distorting it.
  • The picture does not move or resize when the grid changes. This commonly affects floating pictures. Right-click the image, open Format Picture > Size & Properties > Properties, and choose Move and size with cells. Then test by changing the row height. In-cell pictures are associated with their cells, but the visible result still depends on the cell dimensions.
  • Pictures and records no longer match after sorting. Undo immediately if the sort has just happened, then select the entire table or data range—including the image column—and sort again. In-cell pictures are preferable for this workflow. For floating pictures, check their placement settings and confirm that each image is associated with the correct row before sorting a large list.

Frequently Asked Questions

Can I put an image directly inside an Excel cell?
Yes. In supported Microsoft 365 versions, choose the destination cell and use Insert > Pictures > Place in Cell. This makes the image cell content rather than a freely positioned picture object.

How do I make a picture fit without distorting it?
Use Place in Cell and adjust the row height or column width to provide a suitable shape. For a floating image, resize with a corner handle to preserve its proportions. Do not stretch it with a side handle just to fill a mismatched rectangle.

Can I resize the image by changing the cell size?
Changing row height or column width changes the space available to an in-cell picture. A floating picture changes with the cells only when its properties are set to Move and size with cells. Check the display after changing dimensions because different image shapes may not appear equally large.

Will an image stay with its row when I sort?
In-cell pictures are designed to stay associated with their cells. Include the image column in the same sort range as the related names and values. If you use floating pictures, test the sort first and verify that each picture remains with the correct record.

Can I insert several pictures at once?
You can insert pictures into multiple cells, but the exact workflow depends on your Excel build and the files selected. For dependable results, insert one image into each intended cell and verify the row association as you go. If adding many images, first standardize the image column and row heights.

Why does my Excel not have Place in Cell?
The command may be absent because of the Excel version, update channel, or platform. Check for Office updates and inspect Insert > Pictures. If it is still missing, insert a regular picture and use Move and size with cells, or use a Microsoft 365 version where in-cell pictures are supported.

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.