To resize an image so it fits an Excel cell, insert it with Insert > Pictures > Place in Cell, then adjust the row height or column width. The picture will resize with the cell. If the picture is already floating over the worksheet, right-click it and choose Place in Cell if that option is available, or resize it manually and set it to move and size with cells.
This guide is for Excel for Microsoft 365 on Windows. An image placed in a cell behaves differently from a picture that merely sits on top of the grid: the in-cell image is stored in the cell, while a floating picture is a separate object. Knowing which kind you have makes sizing and troubleshooting much easier.
What You’ll Need
- A workbook in Excel for Microsoft 365, preferably with the latest updates installed. The Place in Cell feature may not appear in older or not-yet-updated versions.
- The image file you want to use, such as a JPG or PNG, saved somewhere you can access. If you are working with a workbook from someone else, save a copy before changing its layout.
- A worksheet with the target row and column identified. Decide whether the image should fill the cell or simply appear as a small, readable thumbnail.
Step-by-Step
- Select the target cell. Click the cell where the image should appear. If you are making a list of product photos or employee portraits, put the picture in the row that belongs to that record. You can insert a picture into a blank cell or into a cell that already contains data, but an in-cell picture becomes the cell’s content. Move any text or formula from that cell to another column first if you need to keep it.
- Insert the image as an in-cell picture. On the Windows ribbon, choose Insert > Pictures > Place in Cell, then choose the source, such as This Device, and select the file. In some Excel builds, the picture-source menu first asks where the image is stored. Choose the option that explicitly says Place in Cell, rather than the regular picture insertion option. The image should appear within the selected cell rather than floating freely over several cells.
- Convert an existing picture if you already inserted it. Click the picture, right-click it, and choose Place in Cell from the context menu. The command may be absent for some picture types or versions. If it is available, Excel converts the picture to an in-cell image, generally placing it in the cell underneath its upper-left corner. Check that this is the intended cell; if not, undo the conversion and select or position the picture over the correct cell before trying again.
- Set a useful column width. Drag the boundary between the column letters to widen or narrow the column. For a precise setting, select the column, then use Home > Format > Column Width and enter a value. Column width is measured in character-based units, not pixels, so adjust it until the image is a practical size on screen. If several picture columns should match, select them together before setting the width.
- Set the row height. Drag the boundary below the row number, or select the row and choose Home > Format > Row Height. Type a value and select OK. A larger row and wider column create a larger cell area for the picture; a narrow row or column makes the display smaller. To make a group of thumbnails uniform, select all their rows and apply the same row height.
- Check the image’s proportions and framing. Excel displays the picture within the cell area, but the cell’s shape may not match the original image. A square cell can make a wide photo appear tightly framed or less prominent than expected. Widen the column or increase the row height to give the image a more suitable shape. If the subject looks cut off, use a cell shape closer to the image’s original proportions, or use a floating picture and adjust its crop before placing it.
- Confirm that the picture stays with the right record. Change the row height slightly and verify that the picture remains in the intended cell and scales with it. Sort or filter a small test range if appropriate, then check that each picture remains associated with its corresponding row. Save the workbook after confirming the layout.
Alternative: resize a floating picture. If your Excel version does not offer Place in Cell, select the picture and drag one of its corner handles inward or outward. Corner handles are preferable to side handles because they are less likely to distort the picture. For exact dimensions, open the Picture Format tab and enter values in the Height and Width boxes. To make the picture follow cell changes, right-click it, choose Format Picture, open Size & Properties, expand Properties, and select Move and size with cells. This keeps it aligned with the grid but does not turn it into cell content.
On Mac or Excel for the web, look for the same Place in Cell option in the Insert or picture context menus; the menu layout can differ by platform and update. If the option is not present, use the floating-picture method. The Format Picture pane and its property controls may also be arranged differently in the Mac app. Do not assume that a picture is in a cell just because it visually covers one: select it and check whether Excel offers a Place in Cell command.
Common Mistakes
- Choosing the regular picture command. A picture inserted with the standard floating-picture option sits above the worksheet grid. Changing its row or column will not necessarily resize it. Use Place in Cell when you want the cell itself to contain the image; otherwise, configure the floating picture’s properties.
- Expecting a cell to have a separate picture and text at once. An in-cell picture is the cell’s value, so inserting it into a cell that contains a name, label, or formula replaces that content. Keep the text in a neighboring cell or add a separate column for the image.
- Resizing from a side handle and stretching the photo. Pulling a side handle can make faces or objects look unnaturally wide or tall. Adjust the row and column for an in-cell picture, or use a corner handle for a floating picture. If exact dimensions are needed, keep the original proportions in mind.
- Changing the cell size without checking adjacent content. A taller row can make a table uneven, while a wider column can push the worksheet beyond the screen or print area. Review nearby rows, columns, and page layout after resizing.
- Using a merged cell without planning for it. Merged ranges can make sorting, filtering, and table layouts harder to manage. If the image is for a sortable list, use a normal cell and adjust its row or column rather than merging cells solely to make a larger picture area.
Tips
- Make a consistent thumbnail grid. Set the image column width and all relevant row heights to the same values. This gives a catalog, inventory, or staff list a tidy appearance. You can select several row numbers or column letters at once before applying the dimensions.
- Keep a separate text column. Use one column for the image and the next for the item name, ID, or description. This preserves useful text and makes the list easier to sort, filter, and read with assistive technology.
- Choose a suitable source image. A clear, reasonably sized picture is easier to view than a tiny source enlarged to fill a large cell. Very large images can increase workbook size, especially when there are many of them. Crop or reduce image dimensions with an image editor before inserting if file size is a concern.
- Use a floating picture only when you need free positioning. A floating image can be positioned across multiple cells and resized independently, which can suit a dashboard or title page. For a row-by-row data list, an in-cell image is usually easier to keep aligned when cells change.
- Check the workbook at its intended zoom and print size. A thumbnail that looks clear at high zoom may be too small on a printed page. Use View > Page Layout or print preview to inspect how the rows and images will appear on paper.
Troubleshooting
- Place in Cell is missing. Confirm that you are using an updated version of Excel for Microsoft 365 and that you selected a picture object, not a shape or another object type. The feature may not have rolled out to your installation or may not be supported for that image source. Update Office and reopen the workbook. If the command remains unavailable, use a floating picture and set its property to Move and size with cells.
- The image is too small after insertion. Increase the row height, column width, or both. Remember that the picture cannot display larger than its cell area when it is an in-cell image. If you want a larger image, give the cell more space; changing the worksheet zoom only changes how large the entire sheet appears on screen.
- The picture looks cropped or the subject is missing. First try changing the cell’s shape by adjusting row height and column width. If you are using a floating picture, select it and use Picture Format > Crop to adjust the visible area; choose Fit when available to show the whole image, or use Fill when a fully covered frame matters more than showing every edge. The exact crop controls depend on the picture type and Excel build.
- The picture does not move when rows are sorted or resized. It is probably a floating object with a different placement setting. Select it, open Format Picture > Size & Properties > Properties, and choose Move and size with cells. For reliable sorting with a record list, convert to Place in Cell if the option is available, and keep the image within the same table row as its related data.
- The image appears in the wrong cell. For a floating image, drag it until its upper-left corner is over the intended cell, then convert it using the context menu if supported. If it is already an in-cell image, cut it, select the correct destination cell, and paste. Check the row and column headings before saving.
- The workbook becomes slow or unusually large. Reduce the source image dimensions or compress image files before insertion, especially when a sheet contains many photos. Avoid inserting multiple full-resolution copies of the same image when a smaller thumbnail is enough. Save, close, and reopen the workbook to check whether performance improves.
Frequently Asked Questions
Can I resize a picture without changing the row height or column width?
Not as an in-cell image: its display area is tied to the cell. If you need to change the picture size independently of the grid, use a floating picture and resize it with the corner handles or the Height and Width boxes on Picture Format. Set its placement property appropriately if it should still follow cell changes.
How do I fit an image to an Excel cell automatically?
Insert it through Insert > Pictures > Place in Cell. Excel puts the picture in the selected cell, and changing the row height or column width changes the available display area. The cell may not have the same proportions as the original image, so adjust both dimensions if the framing is unsuitable.
Can I put more than one picture in a single cell?
A cell holds one in-cell picture value at a time. To show several images together, use separate cells or create a collage outside Excel and insert that as one picture. Floating images can overlap cells, but they are separate objects rather than multiple pictures stored in one cell.
Will an in-cell picture stay with its row when I sort the table?
It is designed to be associated with its cell, so sorting a properly selected table range should keep the image with the corresponding row. Make sure the picture column is included in the table or sort range. Test the sort on a copy or a small sample first, particularly when the workbook also contains floating pictures.
Why does resizing the cell change the picture’s appearance?
The cell’s width-to-height ratio may differ from the source image’s ratio, so changing one dimension can alter how much of the picture is visible or how it is framed. Try adjusting both the row height and column width. If keeping the entire picture visible is more important than filling the cell, a floating picture with crop settings may give you more control.
Does this work in Excel for Mac and Excel for the web?
Current versions may offer in-cell pictures, but the command location and availability can vary with platform and update. Look for Place in Cell under the Insert or picture context menus. If you cannot find it, insert a floating picture and use the platform’s picture-format controls to size it and set how it behaves with cells.
Related
- How to Paste in Excel Only Visible Cells Without Hidden Rows
- Paste in a Filtered List in Excel Without Hidden Rows
- How to Paste in Excel in Multiple Cells at the Same Time
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Comparison Plot in Excel With R²: Steps and MeaningTo make a comparison plot with R² in Excel, put the shared X values and each dataset’s Y…
- How to Strikethrough Numbers in Excel: Steps and TipsTo put a line through a number in Excel for Microsoft 365 on Windows, select the cell and…
- How to Retrieve Archived Emails in Outlook on Any DeviceTo retrieve an archived email in Outlook, open the Archive folder, find the message, then move it back…
- How to Archive Emails in Outlook to the CloudTo archive Outlook email in the cloud, move messages into the Archive folder of a cloud-hosted account, or—if…
- Combine Excel Files: Practical Methods and StepsTo combine Excel files with the same column layout, put them in one folder, then in Excel for…
- Microsoft Excel Protect Sheet: Steps, Limits, and TipsTo protect a worksheet in Microsoft Excel for Microsoft 365 on Windows, open the sheet and choose Review…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.