To align a picture with an Excel cell, use Insert > Pictures > Place in Cell to make it part of the cell, then adjust the row height and column width. For a picture already floating over the worksheet, right-click it and choose Place in Cell, or use Move and size with cells to keep it anchored as the grid changes. The right method depends on whether you need the image to behave like cell content or remain a separate object.
What You’ll Need
- Excel for Microsoft 365 on Windows, with the workbook open.
- The picture file you want to insert, if it is not already in the workbook.
- A worksheet layout with enough row height and column width to show the picture clearly.
The Place in Cell feature is available in current Microsoft 365 versions, but its availability can depend on your update channel. If you do not see it, update Office or use the floating-picture method below. Excel for Mac and Excel for the web may show different picture menus, and feature availability can vary by version.
Step-by-Step
- Choose the right kind of picture placement. Use an in-cell picture when each image belongs to one record, such as a product photo beside its product name. In-cell pictures behave like cell content and are easier to sort and filter with the associated data. Use a floating picture when you want a logo, illustration, or other graphic positioned over several cells, or when you need to layer it with other objects. The two types have different controls, so decide before making detailed adjustments.
- Prepare the worksheet space. Decide which cell will contain the image and whether you want text or other values in neighboring cells. If the picture should have its own space, reserve a column for it. Adjust the column width by dragging the boundary between its lettered headings, or use Home > Format > Column Width and enter a value. Adjust the row height by dragging a row boundary or choosing Home > Format > Row Height. Larger cells make pictures easier to see, but can make the worksheet harder to scan.
- Insert a new picture directly into a cell. Select the destination cell. On the Windows ribbon, choose Insert > Pictures > Place in Cell > This Device, browse to the picture, select it, and choose Insert. If your Pictures menu has a direct Place in Cell command, use that option and then select the file source. Avoid choosing the ordinary floating-picture insertion command if you specifically want the image stored in the cell.
- Convert an existing floating picture, if needed. Select the picture, right-click it, and choose Place in Cell. Excel moves the picture into the cell beneath it. Check that the correct destination cell is selected or directly under the picture before converting; a picture that overlaps several cells can make it less obvious which cell Excel will use. If the context menu does not offer Place in Cell, the feature may not be available in that Excel build, or the selected object may not be a supported picture.
- Check how the image fits. In-cell pictures follow their cells when you adjust row height or column width. Resize the cell to give the image more room. Keep the row and column proportions reasonably close to the image’s proportions so the subject remains easy to see. If the display cuts off an important part of the image or does not suit your layout, try a differently shaped cell or prepare a copy of the image with a more suitable crop before inserting it. Do not expect the standard floating-picture crop handles to work on an in-cell picture in the same way as on a separate object.
- Align a floating picture to the cell grid. If you need the picture to stay a separate object, select it and drag it into position. On Windows, hold Alt while dragging an edge or the picture itself to help snap its boundaries to worksheet cell edges. For more precise placement, zoom in and use the gridlines as guides. Excel does not provide a single cell-specific Center command for a floating picture, so centering a smaller picture inside a larger cell requires visual positioning rather than the standard alignment buttons.
- Set a floating picture to move and resize with cells. Right-click the picture and choose Format Picture. In the Format Picture pane, open Size & Properties, expand Properties, and select Move and size with cells. This setting makes the object move and change size when the underlying rows or columns move or resize. It does not automatically snap the picture into a cell, so first position it where you want it. The other property choices can leave the picture moving without resizing, or keep it independent of cell changes.
- Verify the result with a small grid change. Increase or decrease the relevant row height or column width slightly. An in-cell image should remain associated with its cell. A floating picture set to Move and size with cells should move or resize with the area beneath it. Undo the test with Ctrl+Z on Windows if you do not want to keep the dimension change. Save the workbook after confirming that the image behaves as intended.
Excel for Mac has similar picture and object controls, but the ribbon labels and the availability of Place in Cell can differ by release. Look for the Pictures options on the Insert tab or use the picture’s context menu. In Excel for the web, picture insertion and editing options can also differ from the desktop app; if a needed placement or properties control is missing, open the workbook in the desktop version of Microsoft 365.
Common Mistakes
- Using cell alignment buttons on a picture. The horizontal and vertical alignment controls on the Home tab format text and values inside cells. They do not center a floating picture. To associate a picture with a cell, use Place in Cell; to position a floating one, move the object itself.
- Assuming a picture is in a cell because it covers one. A floating picture can sit directly on top of a cell while remaining a separate object. Click it: if picture-specific handles and the Picture Format tab appear, it is an object. Use the context menu’s Place in Cell command if you want it to become cell content.
- Resizing only the picture and not the grid. A floating picture may look aligned at first but overlap neighboring rows or columns after a layout change. For a stable table, either use an in-cell picture or set the floating object’s properties to Move and size with cells.
- Expecting a picture to fit every cell shape perfectly. A wide image in a tall, narrow cell may not look as intended. Changing a cell’s proportions can improve the display, but may also affect other data in that row or column. Consider making a dedicated image column or using a source image with a more suitable composition.
- Sorting a table that contains floating pictures. Separate objects can remain behind or become misaligned when data is sorted, particularly if their properties are not set appropriately. In-cell pictures are generally the more dependable choice when each image must travel with a record during sorting or filtering.
Tips
- Use one picture column for a list. A consistent image column makes product catalogs, staff directories, and inventory sheets easier to read. Set a standard row height and column width before inserting many images.
- Keep the original image proportions in mind. Do not stretch a picture just to fill a box if that distorts faces, products, or logos. Adjust the cell shape or use a version of the image composed for that space instead.
- Use descriptive neighboring data. An image can be difficult to identify or interpret on its own. Keep a name, ID, or short description in an adjacent cell, especially when the workbook may be sorted or shared.
- Test with one image first. Insert a single picture, check its appearance, and try a row or column resize before adding dozens. This reveals whether in-cell or floating placement suits your worksheet and prevents repetitive corrections.
- Keep a backup when changing a large sheet. Save a copy before converting or repositioning many pictures. If an image is moved into a cell, it may no longer have the same object-level formatting and selection behavior as before.
Troubleshooting
Place in Cell is missing. Confirm that you selected a picture rather than a shape, chart, or other object. Check for Office updates, then restart Excel. If the command is still unavailable, use the floating method: position the picture over the target cell and set its properties to Move and size with cells. Menu availability can differ on Mac and in the web app.
The image sits over the wrong cell. For an in-cell image, select the intended destination cell before inserting. For a picture you are converting, move it so that the intended cell is clearly beneath it, then right-click and choose Place in Cell. If it has already gone into the wrong cell, use Ctrl+Z immediately or cut and reinsert it in the correct location.
The floating image moves but does not resize. Open Format Picture > Size & Properties > Properties and check that Move and size with cells is selected. A setting that only moves the object will not resize it when the row or column changes. Also check whether the image actually overlaps the cell area you are resizing.
The image looks cropped, too small, or distorted. Enlarge the destination cell and check the result again. If the composition still does not work, use a source image with a different crop. Avoid dragging only one side of a floating picture if that changes its proportions; resize from a corner or use the size controls in the Format Picture pane. In-cell images and floating pictures have different editing controls, so first confirm which type you selected.
The picture disappears behind cells or other content. A floating picture may be obscured by another object or moved out of view. Select it using the Selection Pane if ordinary clicking cannot reach it; in current Windows Excel, look under Home > Find & Select > Selection Pane. In-cell pictures are selected through their cells instead of as independent objects.
Frequently Asked Questions
Can I center an image inside an Excel cell?
For an in-cell picture, the image is associated with the cell and follows its dimensions; Excel does not provide ordinary text-style alignment buttons for positioning it within the cell. For a smaller floating picture, position it visually over the cell. Holding Alt while dragging on Windows can help align its edges to the grid, but does not create an automatic centered placement.
How do I make a picture move when I resize a row?
Use Place in Cell, or select a floating picture and choose Format Picture > Size & Properties > Properties > Move and size with cells. The second option keeps a floating object tied to the worksheet grid; it does not turn the picture into cell content.
Will an in-cell image move when I sort a table?
In-cell pictures are designed to behave as cell content, which makes them a better fit for image columns in sortable lists. Check the result after sorting a small test range, and make sure the image column is included in the table or sort range. Floating pictures can be harder to keep with their associated records.
Can I put a picture in a cell without changing the row height?
Yes, but the image may appear small or may not display as you want in the available space. Try the existing cell dimensions first. If the picture needs to be larger, increase the row height or column width, keeping in mind that changing a row or column affects the rest of the worksheet.
Does this work in Excel for Mac or Excel for the web?
Picture insertion and placement options are available differently across releases and platforms. Check the Insert tab and the picture’s right-click menu for Place in Cell. If you cannot find the command or object properties on your version, use current Microsoft 365 desktop Excel on Windows or use a floating picture with the controls your version provides.
Related
- Find Duplicate Names in Excel: Methods That Work Well
- Find and Replace Tab Names in Excel: What Actually Works
- Excel Fill Down Shortcut: Use Ctrl+D to Copy a Column
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Average Data in Excel Across Different SheetsTo average the same cell across several worksheets, enter a formula such as =AVERAGE(Jan:Mar!B2) when the sheets are…
- Excel Table Creation: How to Set Up and Use TablesTo create an Excel table in Microsoft 365 for Windows, select a cell in a contiguous data range,…
- Excel Power Query Best Practices for Reliable DataFor reliable Excel Power Query results, start with a stable source, make each transformation clear and repeatable, assign…
- Excel: Hide a Column When a Cell Contains TextExcel has no built-in formula or conditional-formatting rule that automatically hides a column when a cell contains particular…
- Excel: Highlight Cells With Dates Before TodayTo highlight dates before today in Excel for Microsoft 365 on Windows, select the date cells, then choose…
- Unblock a Sender in Outlook: App and Desktop StepsTo unblock a sender in Outlook, remove their email address or domain from Outlook’s blocked-senders list; in new…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.