Resize a Picture in an Excel Cell: Step-by-Step

How-to basics · Updated November 20, 2026

To resize a picture in an Excel cell, place it in the cell, then change the cell’s row height and column width. In Excel for Microsoft 365 on Windows, use Insert > Pictures > Place in Cell; the picture then fits the cell and adjusts when you resize it. If your picture is already floating over the worksheet, convert it to an in-cell picture first, or resize it manually and set it to move and size with cells.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the workbook open and editing enabled. The Place in Cell command may not appear in older Excel versions or in some update channels.
  • The image file you want to use, saved somewhere you can browse to, such as your computer or a synced folder.
  • A worksheet area with enough space for the picture. Decide which column and row should contain it; you can adjust their dimensions after inserting the image.

Step-by-Step

  1. Choose the destination cell. Open the worksheet and click the cell where you want the picture to appear. If the picture is part of a list, choose a cell in the image column on the same row as the related item. For example, if product names are in column A and prices are in column B, put each product image in column C on the matching row. The image is associated with a cell, so selecting the right row and column first helps keep the worksheet organized.
  2. Insert the picture as a cell image. On the ribbon, choose Insert > Pictures > Place in Cell > This Device. Browse to the image, select it, and choose Insert. Depending on your Excel build, the final option may be named slightly differently or appear in a Pictures menu. The key is to choose Place in Cell, not the regular floating-picture insertion option. Excel places the picture inside the selected cell and scales it to fit the cell’s available space.
  3. Check whether the picture is actually in the cell. Click the picture once. If it behaves like the cell’s content and you can select the cell normally, it is likely an in-cell image. If you see picture-selection handles and can drag the image freely over gridlines, it is probably a floating picture. You can also right-click the image and look for Place in Cell. If that command is available, use it to convert the selected floating picture. In some builds, the same command is on the Picture Format tab.
  4. Set the column width. An in-cell picture cannot be resized independently from its cell. To make it wider or narrower, adjust the column containing it. Point to the boundary between that column’s letter and the next column letter, then drag left or right. For a precise value, select the column and choose Home > Format > Column Width, enter a number, and select OK. Column width uses Excel’s character-based measurement, so dragging is often the quickest way to judge the result visually.
  5. Set the row height. Drag the boundary between the row number and the next row number to make the row taller or shorter. For a measured height, select the row and choose Home > Format > Row Height, type a value, and select OK. The image updates to fit the cell’s new dimensions. If you are preparing several rows of pictures, select all those rows before entering a shared height so they stay consistent.
  6. Fine-tune the cell shape. Look at the image after changing both dimensions. A wide, short cell may make a portrait image appear small, while a square cell often works better for a square thumbnail. Excel fits the image within its cell rather than offering separate drag handles for changing only the picture’s width or height. If the picture appears too small, make the cell larger or use an image with a shape closer to the cell’s proportions. Avoid stretching the row or column so far that the worksheet becomes difficult to read.
  7. Repeat the layout for other pictures. If the worksheet is a gallery or image list, use the same column width and row height for every picture. You can select multiple columns or rows and apply a shared size. Insert each picture into its own cell using Place in Cell. To fill a range from files, repeat the insertion for each destination cell; inserting one image does not automatically distribute a group of files across multiple cells.
  8. Save and test the result. Save the workbook, then change the width of the image column or the height of its row slightly and check that the picture follows the cell. Undo the test if needed, or restore the dimensions you chose. If you sort or filter a table, confirm that each picture stays with the correct record. In-cell images are a better fit for this kind of worksheet than pictures that simply sit on top of the grid.

Common Mistakes

Using the regular Insert Picture command. A picture inserted as a floating object may sit over a cell without belonging to it. Resizing the row or column might not resize or reposition that picture as expected. Use Place in Cell when available, or change the floating picture’s properties as described in Troubleshooting.

Trying to drag-resize an in-cell image. In-cell pictures are sized through their cell, not by dragging picture handles to an arbitrary size. Adjust the row height and column width instead. If you need a picture to be a custom size that does not match the cell, keep it as a floating picture and set its placement properties.

Changing the wrong row or column. The picture follows the cell it occupies. Widening a neighboring column will not make the image larger. Check the column letter and row number around the destination cell before changing dimensions.

Expecting a fixed image size after resizing the cell. A cell image is designed to adapt to its cell. If you later narrow the column or reduce the row height, the image will change too. Set the dimensions before finalizing the layout, or keep a floating picture when independent sizing is essential.

Using merged cells as a quick fix. Merging cells can complicate sorting, filtering, selection, and table layouts. If a picture needs more room, increase the intended row or column size rather than merging several cells just to create a larger area.

Tips

  • Plan a consistent thumbnail grid. Choose a suitable image-column width and row height, then apply those dimensions to all image rows. Uniform cells make product catalogs, staff directories, and comparison sheets easier to scan.
  • Keep the original image proportions in mind. Excel fits the image to the cell, so a cell with a very different shape can leave the subject looking smaller than expected. A square source image is usually convenient for square thumbnail cells; a landscape image generally suits a wider cell.
  • Use a separate image column. Keeping pictures apart from names, quantities, or notes makes it easier to filter and maintain the data. Add a clear header such as “Photo” and make the column wide enough for the chosen thumbnail size.
  • Check adjacent content. Taller picture rows affect every cell in the row, not just the image. Wrap long text where appropriate and review the row so descriptions are not visually cramped or unnecessarily spaced out.
  • Use the right picture type for the job. In-cell pictures are useful when the image should travel with a record and respond to cell dimensions. Floating pictures are more flexible for diagrams, logos, and layouts where an image must overlap several cells or have a size independent of the grid.

Troubleshooting

“Place in Cell” is missing. First select a cell, then open Insert > Pictures and check the available options. If the command is still absent, your Excel version or update channel may not include the feature. Update Microsoft 365 if your organization allows it, or use the floating-picture method below. In Excel for the web and Excel for Mac, menu availability can vary with the current release; look in the Insert or picture-formatting menus for a Place in Cell option. If it is unavailable, use the size-and-properties fallback rather than assuming the image is cell-based.

The picture is covering cells and does not follow the row. It is probably a floating object. Select it, right-click, and choose Place in Cell if that option appears. Otherwise, keep it floating and set its behavior: right-click the picture, choose Format Picture, open Size & Properties, expand Properties, and select Move and size with cells. This makes the object respond to cell changes, but it remains a floating picture and may need manual alignment.

The image looks too small or the subject is hard to see. Increase the cell’s row height and column width, then check again. If the result still looks unsuitable, try a source image with less empty space around the subject or with proportions closer to the cell. Avoid assuming that enlarging just one dimension will stretch the picture to fill the cell; preserving the image’s appearance is preferable to distorting it.

The picture moved to the wrong record. Check whether it is a floating picture, or whether it was inserted into the wrong cell. Convert it with Place in Cell where supported, then verify its row and column. When working with a table, test sorting on a copy of the workbook first and confirm that images remain associated with the intended entries.

The row keeps changing height. AutoFit or wrapped text can affect row height. Select the row and use Home > Format > Row Height to enter the height you want. If text in the row needs more space, choose a height that accommodates both the text and the picture rather than repeatedly resizing the image.

Frequently Asked Questions

Can I resize a picture without changing the Excel cell?
An in-cell picture is sized to its cell, so changing the picture alone is not the standard method. Keep it as a floating picture if it must have independent dimensions. You can then drag its handles and use Move and size with cells if it should still respond to worksheet changes.

How do I make a picture fit the whole cell?
Use Place in Cell to make the picture cell content, then set the row height and column width. Excel scales the image to fit the cell. If the cell’s proportions differ greatly from the picture’s, the subject may not fill the space as you expect; select a better-shaped source image or adjust the cell shape.

Can I resize several picture cells at once?
Yes. Select the relevant column or columns and set a shared width with Home > Format > Column Width. Select the picture rows and set a shared height with Home > Format > Row Height. Each in-cell image then fits its own cell. This changes every cell in the selected rows or columns, so check the effect on neighboring content.

Will the picture stay with its data when I sort?
In-cell images are intended to be associated with cells, which helps them stay with the related worksheet data. Floating pictures can behave differently depending on their placement settings. Before sorting an important list, save a copy and test the sort to make sure images and records remain correctly matched.

Can I do this in Excel for Mac or Excel for the web?
Feature availability and menu placement can differ by release. If you see Place in Cell in the picture insertion or formatting options, use it and then resize the cell’s row and column. If you do not see it, insert a regular picture and use its sizing handles, or set Move and size with cells where that option is available.

Why does my image look cropped or not fill the cell?
The image and cell may have different proportions, and the cell-image display is not the same as freely stretching a picture. Make the cell closer to the image’s shape or use a source image framed the way you want. If you need precise crop and placement controls, use a floating picture and adjust it separately.

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.