To make a picture fit an Excel cell, use Picture Format > Place in Cell if that command is available; Excel then treats the image as cell content. For a floating picture, resize it to the cell and set Format Picture > Size & Properties > Properties > Move and size with cells so it follows changes to the row and column.
What autofit means for pictures in Excel
Excel has AutoFit commands for row heights and column widths, but there is no single AutoFit button that automatically sizes every traditional, floating picture to its cell. The term usually refers to one of two tasks: placing an image inside a cell, or sizing a picture over a cell and making it move and resize when the grid changes. These approaches behave differently, so choosing the right one matters.
A floating picture sits above the worksheet grid, much like a shape. It can cover part or all of a cell, but it is not actually stored in that cell. A picture placed in a cell is associated with the cell’s contents. It is generally easier to sort, filter, and keep aligned with a table row. If you are building a product list or photo catalog, an in-cell image is usually the simplest option. If you need to position a logo or illustration freely, a floating picture may be preferable.
Put a picture directly in a cell
In current Microsoft 365 versions of Excel for Windows, use the in-cell picture command when you want Excel to handle the relationship between the image and the grid. The wording and availability can vary with the update channel and Excel version.
- Select the destination cell. Set a suitable row height and column width first if you already know the image layout you want.
- Choose Insert > Pictures, then choose the option to place the picture in a cell and select its source, such as your device.
- To convert an existing floating picture, right-click it and choose Place in Cell, if that command appears.
- Adjust the row height or column width to change the space available for the image. Check the result at the zoom level and worksheet size where it will be used.
For a table of product photographs, for example, put each photo in the same image column and use consistent row heights. The pictures remain tied to their respective records more reliably than a set of independent shapes layered over the cells. If you do not see Place in Cell, check that Excel is up to date, or use the floating-picture method below. Excel for Mac may present the command in a different context or ribbon menu, and older builds may not include it. Excel for the web has a more limited set of picture-formatting controls; if a command is missing, open the workbook in the desktop app.
Make a floating picture move and resize with cells
This setting is useful when a picture is already on the sheet and should track its cell as the worksheet changes. It does not automatically snap the picture to the cell’s edges or correct its initial size; you must position and size it first.
- Click the picture to select it.
- Open Picture Format, then open the Format Picture pane using the dialog launcher in the Size group, or right-click the picture and choose Format Picture.
- In the pane, open Size & Properties, then expand Properties.
- Select Move and size with cells.
- Resize and position the picture so it fits the intended cell or range.
Afterward, changing the width of the relevant column or the height of its row changes the picture’s position and size along with the grid. The precise labels or pane layout can differ slightly between desktop releases. On a Mac, use the picture’s formatting pane and look for the same cell-property choice; if it is not available in your build, use an in-cell picture or check the current Excel version. The web app may not expose all desktop object properties.
Size the picture to the cell before setting its properties
For a single-cell picture, first make the target cell large enough to be useful. Select the row or column, then use Home > Format to set row height or column width. You can also drag row or column boundaries. Excel’s numeric row-height and column-width units are not the same, so equal numbers do not produce a square cell. Adjust visually, or use a consistent layout across the whole image column.
Select the floating picture and drag a corner sizing handle until it fits inside the cell. Corner handles are usually the best choice because they preserve the image’s proportions. Dragging a side handle can change the proportions and make a person, product, or logo look stretched. For closer alignment, use Picture Format sizing controls to enter a height or width, then position the picture inside the cell. If the picture covers several cells, size it to that range rather than trying to fit it to just one.
Excel can snap a floating object to worksheet grid boundaries while you move or resize it. On Windows, holding Alt during a drag can help align an object with cell boundaries. This is a positioning aid, not an automatic image-fit feature, and behavior can depend on the action and Excel build. On Mac, keyboard behavior differs; use the visible grid and the sizing controls rather than assuming the Windows shortcut applies.
Understand image proportions, cropping, and empty space
A cell’s shape may not match a photograph’s shape. A wide image inside a tall, narrow cell cannot fill the space without either leaving empty space, cropping some of the image, or distorting it. For most photographs, avoid distortion. Keep the original proportions and accept empty space, or crop the picture when the edges are not important.
Excel’s Picture Format > Crop tools let you adjust the visible portion of a selected floating picture. The Fit and Fill choices in the Crop menu describe different framing outcomes: fitting shows the full image within the frame, while filling covers the frame and may crop part of the image. These commands affect the picture frame and visible image; they are not substitutes for placing the picture in a cell. If the available crop controls differ for an in-cell image, adjust the source image or use a floating picture where you need more framing control.
For instance, if a square cell contains a landscape photo, Fit can leave space above and below, while Fill can cut off the left and right edges. For a product label where all text must remain visible, showing the whole image is safer than filling the square. For uniform headshots, cropping to a consistent composition may look neater, but inspect each image so faces or important details are not cut off.
Choose the right method for your worksheet
- Use Place in Cell for records such as product photos, employee portraits, or inventory images that should stay associated with a row when sorting and filtering.
- Use a floating picture with Move and size with cells when you need to preserve an existing layered layout but want the picture to follow grid changes.
- Use a floating picture with Move but don’t size with cells when it should follow a cell’s location but keep its own dimensions as the grid changes. Find this choice under the same Properties section.
- Use Don’t move or size with cells for a page decoration or logo that should stay independent of row and column adjustments.
Think about what should happen when someone sorts the data, changes a column width, hides rows, or prints the sheet. In-cell images are often the most predictable for sortable data. Floating pictures can be more flexible for design work, but each object’s placement and properties need attention. If there are many images, switching to in-cell pictures where possible can reduce the amount of manual alignment required.
Common problems and practical fixes
The image does not change when I resize the cell. It may be a floating picture whose property is set to Move but don’t size with cells or Don’t move or size with cells. Select it and check Format Picture > Size & Properties > Properties. Also confirm that you changed the row or column containing the picture, rather than an adjacent one.
The picture moves but does not fit. That is expected if it has not been resized to the cell. The move-and-size setting controls how the object responds to grid changes; it does not perform the initial fitting. Resize it manually, or use Place in Cell where supported.
The image looks stretched. Undo the last resize if possible, then resize with a corner handle or enter dimensions that preserve its original width-to-height ratio. If the cell has a different shape, choose between empty space and cropping instead of forcing the image to fill it.
The picture seems to disappear after sorting. A floating image can become separated visually from the record it was meant to illustrate, especially if its placement or properties were not set appropriately. In-cell images are usually a better choice for sortable table data. Test the sort on a copy of the sheet before changing a large catalog.
The row or column becomes unexpectedly large. AutoFit for cells adjusts row height or column width based on cell contents; it is not a dependable way to size a floating picture. Set row heights and column widths deliberately for image layouts, and check that long text in neighboring cells is not driving the AutoFit result.
Keep picture layouts consistent
For a polished catalog, choose one image-column width and one row height, then apply them consistently. Use source images with similar orientations where practical. A very wide mix of landscapes and portraits can make one uniform cell size look uneven, even when Excel is behaving correctly. If the worksheet will be printed, use Print Preview to check whether the images remain legible and whether rows break across pages as expected.
When working with many floating objects, it can help to use the Selection Pane, available from Home > Find & Select > Selection Pane, to select and manage pictures that overlap or are difficult to click. The pane does not auto-fit pictures, but it can make it easier to identify objects and apply consistent formatting. Keep an untouched copy of the workbook before making broad layout changes, particularly if the sheet contains many carefully positioned objects.
Frequently Asked Questions
Does Excel have an AutoFit Picture button?
No. Excel has AutoFit options for row heights and column widths, but not a universal command that automatically fits floating pictures to cells. Use Place in Cell for supported versions or resize a floating picture manually.
How do I make a picture resize when I change a column width?
Select the floating picture and choose Format Picture > Size & Properties > Properties > Move and size with cells. The picture must also be positioned and sized to the intended cell before the change.
Can I make a picture fit a cell without stretching it?
Yes. Preserve its proportions by resizing from a corner or using a fit-style crop. If the picture and cell have different shapes, preserving proportions means either leaving some blank space or cropping part of the picture.
Why can’t I find Place in Cell?
The command is not present in every Excel version or update channel. Update Microsoft 365 if possible, check the selected picture’s right-click menu, or use a floating picture and set its cell properties instead.
Will an in-cell picture stay with its row when I sort?
In-cell pictures are designed to be associated with cell content, making them a better choice for sortable records than independent floating objects. Try the sort on a copy first if the workbook contains a complex table or a mix of picture types.
Related
- Do Excel Named Ranges Automatically Expand?
- Excel Merge Vertical Cells: Steps, Limits, and Alternatives
- Excel Merge Multiple Cells Into One Cell: A Clear Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Advanced Excel Power Query: Techniques and WorkflowsAdvanced Excel Power Query is the practice of building repeatable, well-organized data import and transformation workflows in Excel,…
- Freeze Panes in Excel: Keep Rows and Columns VisibleTo freeze panes in Excel for Microsoft 365 on Windows, select the cell just below the rows and…
- How to Freeze Rows in Excel and Keep Headers VisibleTo keep a row visible while you scroll in Excel, go to View > Freeze Panes > Freeze…
- How to Make a Monthly Budget Planner in Google SheetsTo make a monthly budget planner in Google Sheets, create one tab for your budget and another for…
- Google Sheets: How to Merge Columns Without Losing DataTo combine values from columns, put the result in a new column: with a first name in A2…
- Excel Row Limit: How Many Rows Can a Worksheet Hold?In modern Microsoft Excel, one worksheet can hold a maximum of 1,048,576 rows, numbered 1 through 1,048,576. That…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.