How to Align a Picture in an Excel Cell: Step by Step

How-to basics · Updated November 20, 2026

To put a picture in an Excel cell, select the cell and choose Insert > Pictures > Place in Cell, then choose the image. To align an existing picture, right-click it and choose Place in Cell; if you need it to remain a separate, floating object, resize and position it over the cell instead. The in-cell method is usually the simplest because the picture moves and resizes with the cell.

These steps are for Excel for Microsoft 365 on Windows. The exact wording or location of Place in Cell can vary by update and platform. If the command is missing, see Troubleshooting below. Before starting, decide whether the image should behave like cell content or remain a movable object layered over the worksheet.

What You’ll Need

  • An Excel workbook and the picture file you want to use, such as a PNG or JPG.
  • A worksheet cell for the picture. If you plan to place several pictures, decide which row and column each should occupy.
  • Excel for Microsoft 365 with the Place in Cell feature available. If you do not have it, you can still position a floating picture over a cell.

Step-by-Step

  1. Choose the right kind of picture. Use an in-cell picture if it should stay associated with one cell when you sort, filter, or change the worksheet layout. Choose a floating picture if it needs to overlap several cells, sit beside a chart, or remain independently positioned. These are different picture behaviors, not just two ways to adjust alignment.
  2. Prepare the target cell. Click the cell where the image should appear. If you want the image to be easy to see, first adjust the column width or row height: drag the boundary between column letters or row numbers. For a consistent image grid, set the same column width and row height for every target cell. The picture display is constrained by the cell dimensions, so a very short row can make it look tiny.
  3. Insert a new picture into the cell. On Windows, select Insert > Pictures > Place in Cell, then choose This Device to browse for an image saved on your computer. Select the file and choose Insert. The picture is inserted as content in the selected cell rather than as an object floating above the grid. If your version offers other picture sources, choose the source that contains your image.
  4. Convert an existing floating picture if needed. Click the picture once to select it, then right-click and choose Place in Cell. In some Microsoft 365 builds, the command may also be available from the Picture Format tab. Check that the picture now belongs to the intended cell. If it lands in the wrong place, undo immediately with Ctrl+Z, select the correct cell, and try again.
  5. Check how the image fits. In-cell pictures use the space available in their cells. Increase the row height or column width if the image appears too small to identify. If the picture seems cropped or its subject is hard to see, try a cell with a different shape or edit the source image before inserting it. Do not rely on the Home tab’s horizontal Center button to center the picture; that command aligns cell contents such as text and does not work as a general picture-positioning control.
  6. Confirm that the picture moves with the cell. Change the row height or column width slightly and observe the picture. An in-cell picture should adjust with its cell. Undo the test if you do not want to keep the new dimensions. If you plan to sort or filter the data, make sure each image is in the same row as its corresponding record and that the table has clear headers.
  7. Align a floating picture over a cell when you need more control. Select the picture and drag it over the target cell. On Windows, hold Alt while dragging or resizing to help snap the picture edges to worksheet cell boundaries. To make it move and resize when cells change, right-click the picture, choose Format Picture, open Size & Properties, expand Properties, and select Move and size with cells. The picture remains a floating object, so snapping its edges to a cell is a visual alignment method, not the same as placing it in the cell.
  8. Save and review the sheet. Save the workbook, then check the image at normal zoom and after changing the worksheet layout if that matters. If the workbook will be shared, reopen it in the version and platform your recipients use. Picture features can look or behave differently across older Excel versions and other spreadsheet apps.

On recent Excel for Microsoft 365 builds for Mac, look for Place in Cell on the Insert tab or in the picture’s context menu; menu placement can differ from Windows. Excel for the web may offer the in-cell picture command too, but its available picture sources and editing controls can differ. If a platform lacks Place in Cell, use a floating picture and align it to the grid, or open the workbook in an updated Microsoft 365 desktop app.

Common Mistakes

  • Using Center from the Home tab and expecting the image to move. This centers text or other cell content; it is not a reliable way to position a floating picture. Use Place in Cell or position the floating object itself.
  • Inserting instead of placing in the cell. The normal picture insertion command may create a floating image, even when a cell was selected first. Choose Place in Cell specifically, or convert the existing image from its context menu.
  • Making the row or column too small. A picture can be present but difficult to see because its cell has little space. Adjust the dimensions before deciding it has disappeared or failed to insert.
  • Ignoring the image’s proportions. A wide image in a narrow cell, or a tall image in a shallow cell, may not display as expected. Change the cell shape or prepare a better-cropped source image rather than repeatedly stretching the floating picture out of proportion.
  • Expecting floating pictures to sort like cell values. A floating picture can cover a cell without being part of that cell. For images associated with records, use Place in Cell where available and verify the image stays with the correct row when sorting.
  • Using merged cells as the picture grid. Merged cells complicate selection, resizing, and sorting. For a predictable layout, use ordinary cells with deliberate row heights and column widths.

Tips

  • Set the dimensions for the whole image area first. Selecting several relevant row or column headers lets you apply a consistent size before adding pictures.
  • Keep one image per record row when building a product, staff, or inventory list. This makes the relationship between the image and the text easier to maintain.
  • Use short, clear column headings and leave enough width for nearby descriptions. A picture column that is too wide can make the rest of a worksheet difficult to read.
  • Use a copy of the source image if you need to crop or resize it outside Excel. Keeping the original file makes it easy to restore a better version later.
  • For floating objects, select Move and size with cells if the picture should follow row and column changes. If the object should keep its size while moving with the grid, inspect the other available Properties choices in Format Picture.
  • Zoom in while positioning a floating picture, then return to normal zoom to check the overall layout. At a very low zoom level, small gaps can be hard to spot.
  • Keep an original copy of the workbook before making a large batch of picture changes. This is especially useful when converting many floating pictures, since undoing a long sequence can be inconvenient.

Troubleshooting

Place in Cell is missing: Confirm that you are using a current Microsoft 365 version and that a normal worksheet cell or picture is selected. Check Excel for updates, then look again under Insert > Pictures or the picture’s right-click menu. Some versions or platform builds may not expose the same command. If it still is not available, use a floating picture and set its placement properties.

The picture covers the wrong cell: If it is floating, drag it to the correct position; holding Alt on Windows can help snap its edges to grid boundaries. If you converted it to an in-cell picture, undo the conversion, select the intended cell, and convert or insert it again. Confirm the active cell before choosing the command.

The picture is too small or difficult to see: Increase the row height or column width and check the result. If the subject still does not fit well, use an image with a more suitable aspect ratio or crop a copy of the source image. Avoid stretching a floating image unevenly, because that distorts faces, logos, and product shapes.

The image does not move or resize with the cell: It may still be a floating object. Convert it using Place in Cell if it should be cell content. Otherwise, open Format Picture > Size & Properties > Properties and select Move and size with cells. Test by changing the row or column size, then undo the test if necessary.

The image appears to separate from its record after sorting: Check whether it is an in-cell picture or a floating object positioned over the row. In-cell pictures are the more suitable choice for a picture that should sort with its record. For older files or mixed picture types, verify the association on a copy of the workbook before sorting the original data.

The image looks different on another computer: Confirm that the workbook was saved in a format that supports the feature and that the other user has a compatible Excel version. If the file is opened in a different spreadsheet application, picture behavior may not match Excel. Ask the recipient to open it in Microsoft Excel or provide a separate image copy when appearance is critical.

Frequently Asked Questions

Can I center a picture inside an Excel cell?
For a picture that should behave as cell content, use Place in Cell; it is not positioned with the regular text-alignment buttons. For a floating picture, center it visually by resizing and positioning it over the cell, using the grid boundaries as guides.

Does a picture placed in a cell resize when I change the row height?
An in-cell picture adjusts with the cell area. If it becomes too small to use, increase the row height or column width. A floating picture follows cell changes only when its Properties setting is configured to move and size with cells.

Can I sort a list that contains pictures?
Yes, but use in-cell pictures for images that belong to individual records and keep each picture in the same row as its record. Floating images can be visually over a row without being stored in that row, so check their behavior before sorting important data.

Can I put more than one picture in a cell?
A cell is intended to hold one in-cell picture at a time. To show several images, use separate cells or place additional pictures as floating objects, taking care that the layout remains clear.

Why does my picture look cropped or distorted?
The cell’s shape may not suit the picture’s proportions, or the floating picture may have been resized unevenly. Adjust row height and column width, use a better-shaped source image, or correct the floating object’s proportions before positioning it again.

Can I do this in Excel for the web or on a Mac?
Availability and menu placement depend on the Excel build. Check the Insert tab and the picture’s context menu for Place in Cell. If you cannot find it, use the floating-picture method or open the workbook in an updated Microsoft 365 desktop version.

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.