How to Autofit a Picture in an Excel Cell

How-to basics · Updated November 20, 2026

To make a picture resize with an Excel cell, select it and choose Picture Format > Place in Cell in Excel for Microsoft 365 on Windows. For a new picture, choose Insert > Pictures > Place in Cell. Then set the row height and column width to the space you want: Excel does not automatically enlarge a cell to match an image.

Excel handles pictures in two ways: as images inside cells, or as floating objects layered over the worksheet. An image placed in a cell resizes and moves with that cell. A floating picture can be sized to cover a cell and set to move and resize with it, but it remains an object on top of the grid. The first method is usually the simplest for catalogs, inventories, and lists.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the workbook open and editing enabled. The Place in Cell feature may not appear in older or less-updated Excel versions.
  • The image file you want to use, if you are adding a new picture. Keep a copy somewhere you can find it, such as your Pictures folder.
  • A worksheet with a destination cell chosen. Decide roughly how much space each image should have; pictures in cells use the row height and column width as their display area.

Step-by-Step

  1. Choose how the picture should behave. Use an in-cell picture if it should belong to a particular cell and remain aligned when you sort, filter, or change the grid. Use a floating picture if you need to position it freely over several cells or add decorative artwork. For most table-style uses, choose the in-cell option.
  2. Prepare the destination area. Click the cell where the image should appear. If the worksheet has a table, use the cell in the same row as the item’s other details. Widen the image column by dragging the boundary between its column letters, and increase the row height by dragging the boundary below the row number. This gives the picture room to display. You can also use Home > Format > Column Width and Home > Format > Row Height to enter measurements.
  3. Insert a new picture directly in the cell. Select the destination cell, then choose Insert > Pictures > Place in Cell. Select the picture source or file, choose the image, and confirm the insertion if prompted. The picture is inserted as cell content rather than as an object floating above the worksheet. If the Pictures menu only offers an option such as Place over Cells, check that Excel is updated; otherwise, use the floating-picture method below.
  4. Convert an existing floating picture. Click the picture once to select it. Open the Picture Format tab, then choose Place in Cell. In some updated builds, the same command is available from the picture’s right-click menu. If you cannot see the command, make sure the picture itself is selected, not the cell behind it, and check for Office updates. The picture will be attached to the active cell when converted, so check that it is in the intended row and column.
  5. Adjust the cell to the desired display size. Resize the column and row using their grid boundaries or the Home > Format commands. A column width controls the horizontal space available to the image, while row height controls the vertical space. Excel’s AutoFit commands are designed mainly around cell contents such as text; they do not reliably calculate a row height or column width from an image. Set dimensions deliberately rather than expecting AutoFit to size the grid around the picture.
  6. Check how the whole image appears. In-cell pictures are constrained by the cell’s available space. If the image appears too small, increase the row height, column width, or both. Keep in mind that a photo’s proportions may not match the cell’s proportions, so it may not fill every part of the cell without cropping or distortion. Do not stretch a photo out of proportion just to eliminate blank space.
  7. Verify the result in context. Click another cell, then inspect the picture at normal zoom. Try changing the row height or column width slightly to confirm the picture responds as expected. If the worksheet uses filters or sorting, test those actions on a copy or a small sample first. Save the workbook after confirming that the image is attached to the correct record.

Alternative for a floating picture: Insert it with Insert > Pictures, then drag its edges until it covers the intended cell. For a better fit, select the picture and use Picture Format > Crop > Fit to show the full image within its frame. This can leave unused space around the image when its proportions differ from the frame. Choose Picture Format > Crop > Fill if you prefer the frame to be filled and are comfortable cropping off part of the image. To make the floating object follow grid changes, right-click it, choose Format Picture, open Size & Properties, expand Properties, and select Move and size with cells. This setting makes the object respond to cell changes; it does not convert it into cell content.

Common Mistakes

  • Expecting AutoFit to size a cell around a photo. Home > Format > AutoFit Row Height and AutoFit Column Width are useful for text, but they are not a dependable way to set a cell’s dimensions from an image. Set row height and column width yourself.
  • Confusing Place in Cell with Move and size with cells. Place in Cell makes the image cell content. Move and size with cells changes the behavior of a floating object. They are different approaches, and the latter does not make the picture a sortable cell value.
  • Stretching the picture to fill a mismatched cell. Pulling one side independently can make faces, products, or logos look distorted. Use Fit to preserve the entire image, or Fill to crop the edges while filling the area.
  • Resizing the wrong thing. Dragging a cell border changes the worksheet grid; dragging a floating picture’s handles changes the object. For an in-cell image, change the row or column dimensions, not object handles.
  • Forgetting that a converted picture goes into a cell. When converting an existing image, confirm the selected cell before using Place in Cell. Otherwise the picture may end up beside the matching item’s data.

Tips

  • Use consistent dimensions for a picture column. Select the relevant rows or columns, then use Home > Format > Row Height or Column Width to give every item a uniform display area. Consistency makes a product list or staff directory easier to scan.
  • Keep source images sensibly sized. Very large photos can increase workbook size and slow down opening or saving. If a workbook becomes unwieldy, make appropriately sized copies of the images before inserting them; keep the originals separately if image quality matters.
  • Use short row heights for thumbnails. A compact thumbnail column is often easier to read than full-size images. Readers can still select the cell to work with the image, while the rest of the row stays visible.
  • Choose in-cell images for structured lists. Because the picture is associated with a cell, it is generally easier to keep aligned with the related row when filtering or sorting. Floating pictures can overlap cells and may need extra checking when worksheet data is rearranged.
  • Remember that worksheet zoom changes appearance, not dimensions. Zooming in or out changes how large the grid looks on screen. It does not change the actual row height, column width, or image size settings.
  • Check print layout separately. A picture that looks aligned on screen may not fit the printed page as expected. Use File > Print to preview the sheet, and adjust scaling or page orientation if the image column is clipped.

Troubleshooting

  • Place in Cell is missing. Confirm that you selected a picture and that the Picture Format tab is visible. Check File > Account > Update Options > Update Now on Windows if available. The feature may not be present in older Excel releases or every update channel. If it remains unavailable, use a floating picture and set its properties to Move and size with cells.
  • The image looks tiny or clipped. Increase the row height and column width, then check the picture again. If it is a floating picture, select it and use Picture Format > Crop to choose Fit or Fill. Fit shows the complete picture but can leave blank space; Fill covers the frame but crops some edges.
  • The picture does not change when you resize the grid. It may still be floating. Select it and look for the Place in Cell command. If you want it to remain floating, open Format Picture > Size & Properties > Properties and select Move and size with cells. A floating picture set to Move but don’t size with cells will shift with the grid but keep its original size.
  • The row stays too short after AutoFit. This is expected when the image is not treated like text for AutoFit calculations. Enter a larger value through Home > Format > Row Height or drag the row boundary. Increase the column width separately if the image also needs more horizontal room.
  • The image is attached to the wrong cell. Select the picture and check the active cell before converting it. If it is already an in-cell image, cut it, select the correct destination cell, and paste. Confirm the surrounding labels still match the image after moving it.
  • The command names differ on Mac or Excel for the web. Ribbon layouts and feature availability can vary by platform and update. Look under the Insert or Picture Format controls for Place in Cell. If that command is not offered in your version, use the floating-picture method; the Windows instructions for the Format Picture pane may have different control placement on Mac.

Frequently Asked Questions

Can Excel automatically fit a picture to a cell?
Yes, the Place in Cell option makes a picture part of a cell and constrains it to the cell’s available space. You still need to set the row height and column width to control how large that space is.

Does AutoFit Row Height resize a cell to match its picture?
Do not rely on it to do that. AutoFit is primarily intended to size rows for cell contents such as text. Set the row height manually with Home > Format > Row Height when an image needs more room.

Can I make a picture fill the cell without cropping?
Not always. If the image and cell have different proportions, showing the entire image can leave unused space. Filling every part of the cell usually means cropping the image; stretching it can distort the picture.

Will an in-cell picture move when I sort a list?
It is designed to behave as cell content, which helps it stay with its row when sorting and filtering. Check that the image column is included in the range being sorted, especially if the data is not formatted as an Excel table.

Can I still use a floating picture?
Yes. Size and position it over the cell, then set Move and size with cells in the Format Picture properties if it should follow grid changes. It remains an overlaid object, so it may need additional attention during sorting or rearranging.

Does the picture keep its original proportions?
In-cell display is limited by the cell’s dimensions, and the visible result depends on how the image fits that area. For floating pictures, use Crop > Fit to show the entire image without stretching, or Fill to cover the frame while cropping the excess.

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.