How to Center an Image in an Excel Cell and Keep It Aligned

How-to basics · Updated November 20, 2026

To center an image in an Excel cell, insert it as a picture in the cell if you want it to fill that cell, or keep it floating over the grid and position it with equal space around it. For a floating image, resize it, place it over the target cell, and set it to move and resize with cells so it stays aligned when the worksheet changes.

Excel does not have a single command that centers a floating picture inside a selected cell. The best method depends on whether you want the picture to occupy the whole cell or sit smaller with visible margins. The steps below are for Excel for Microsoft 365 on Windows.

What You’ll Need

  • An Excel workbook where you can edit the target worksheet.
  • The image file you want to use, saved somewhere accessible on your computer.
  • A decision about the result: a picture that fills a cell, or a smaller floating image centered within it.

Step-by-Step

  1. Choose the target cell and prepare the grid. Click the cell where the image should appear. If the picture needs room, adjust the column width or row height first: drag the boundary between column letters or row numbers, or use Home > Format to choose Column Width or Row Height. If the workbook already has carefully sized rows and columns, note their current dimensions before changing them. The cell’s shape affects how a picture fits, especially if the source image is wide or tall.
  2. Decide whether the image should fill the cell. To make the picture part of the cell rather than a separate object floating above the worksheet, use Excel’s in-cell picture option if it is available. Choose Insert > Pictures > Place in Cell > This Device, select the file, and insert it. The picture is stored in the cell and adjusts with the cell. Depending on the picture’s proportions and the cell’s shape, some of the image may be cropped or its display may be scaled. Increase the row height or column width if the result is too small or cuts off an important detail.
  3. Convert an existing picture if appropriate. If the image is already on the sheet as a floating object, right-click it and choose Place in Cell when that option appears. Excel moves it into the selected cell rather than leaving it layered over the worksheet. This is often the simplest route for a thumbnail or product image that should follow its cell when you sort or resize the table. If you need visible margins around a smaller picture, keep it floating and continue with the next steps instead.
  4. Insert a floating picture for a smaller, centered result. Click Insert > Pictures > This Device, choose the image, and click Insert. If your Pictures menu lists a Place over Cells option, select that for a floating picture. Otherwise, insert the picture normally and use it as an object above the grid. Drag it near the target cell. A floating picture can overlap cell borders, so being visually over a cell does not automatically make it part of that cell.
  5. Resize the floating picture without distorting it. Select the picture and drag a corner handle inward or outward. Avoid dragging a side handle unless you deliberately want to stretch the image. To enter precise dimensions, open the Picture Format tab and use the Size controls; if the proportions change unexpectedly, open the Format Picture pane and check that Lock aspect ratio is enabled in the Size section. Make the picture slightly smaller than the cell in both directions to leave room for margins.
  6. Position the picture in the middle of the cell. With gridlines visible, move the image until the open space above and below it looks equal, and the space on its left and right looks equal. Use the surrounding cell borders as guides rather than judging the image against the whole worksheet. For a more careful adjustment, zoom in and nudge the selected picture with the arrow keys; check the margins after each small move. Excel’s Align commands arrange selected objects relative to other objects or the sheet, not directly to a single cell, so they may not center one picture in one cell as expected.
  7. Make the picture follow the cell. Right-click the floating image and choose Format Picture. In the Format Picture pane, select Size & Properties, expand Properties, and choose Move and size with cells. This makes the picture move and change size as its underlying rows or columns are moved or resized. It does not, by itself, center the picture; first position it as desired, then set this property to preserve its relationship to the grid.
  8. Check the result after a grid change. Change the target row height or column width slightly, then undo the change if you do not want to keep it. Confirm that the picture remains over the intended cell and that it still has the margins you expect. If it moves or resizes incorrectly, reopen Format Picture > Size & Properties > Properties and verify the selected behavior. Save the workbook after you are satisfied.

For an exact-looking center, compare the gaps between the image and all four cell edges. They do not need to be numerically identical if the image has transparent padding, an irregular outline, or a subject that is visually off-center inside the file. In those cases, align the visible subject rather than the image’s rectangular boundary.

Common Mistakes

  • Assuming a picture over a cell belongs to that cell. A floating picture is an object layered above the worksheet. It can cover multiple cells, and sorting or filtering may not treat it like cell content. Choose Place in Cell when the image needs to be part of a table cell.
  • Resizing from a side handle. This can squash or stretch faces, logos, and product photos. Use a corner handle, or enter a dimension with Lock aspect ratio enabled.
  • Changing cell size after aligning the picture. A floating image may no longer look centered if it is set to move but not resize, or if the row and column are changed substantially. Choose Move and size with cells when it should scale along with the grid.
  • Expecting Align Center to center an image in a cell. The Align commands are intended for objects, and a worksheet cell is not a picture object. Use the cell edges as guides or use an in-cell picture for a full-cell image.
  • Ignoring the source image’s empty space. A file can contain a large white or transparent border around its subject. The picture rectangle may be centered even though the visible content looks off-center. Crop or edit the source image if that border is not wanted.

Tips

  • Set the row height and column width before inserting or positioning several pictures. Consistent cell dimensions make a table of thumbnails look orderly.
  • Use in-cell pictures for sortable lists, inventory tables, and records where each image should stay attached to its row. Use floating images for illustrations, callouts, or images that intentionally overlap cells.
  • Keep the original image proportions. If you need a square thumbnail from a wide photo, crop the photo rather than stretching it into a square.
  • Zoom in temporarily while positioning a small image, then return to your normal worksheet zoom to judge its appearance in context.
  • For repeated use, make a copy of a correctly sized and positioned floating picture, then replace its image rather than starting over. Check the new picture’s position and object properties because replacement behavior can vary by Excel build.
  • Keep important details away from the edges if you use an in-cell image. A narrow cell or a different aspect ratio can hide content that was visible in the original file.

Troubleshooting

The image will not stay inside the cell. It is probably a floating picture. Right-click it and look for Place in Cell. If you want it to remain a floating object, use Format Picture > Size & Properties > Properties > Move and size with cells, and reposition it after changing the grid.

Place in Cell is missing. The command may not be available in your Excel build, or the selected object may not be a supported picture. Update Microsoft 365 and check the Insert > Pictures menu or the picture’s right-click menu. If the command is still absent, insert the image as a floating picture and position it manually. Excel for the web and Mac can have different feature availability and menu layouts; use the desktop Windows steps if the option is not present.

The image looks stretched, cropped, or too small. For a floating picture, restore its aspect ratio and resize from a corner. For an in-cell picture, adjust the cell dimensions or use a source image with a closer aspect ratio. If a specific part of the image is missing, the cell’s shape may be cropping it; try a wider or taller cell, or prepare a cropped copy that shows the area you need.

The picture shifts when you sort, filter, or resize rows. Confirm that it is in the correct cell, or set a floating picture to Move and size with cells. Sorting can be awkward with pictures that overlap multiple rows or columns. For tabular data, in-cell images are generally easier to keep associated with the right record.

The picture seems centered, but the subject does not. Look for blank or transparent space within the image file. Crop that space in an image editor or use Picture Format > Crop to trim the visible picture. Recheck the margins after cropping because the picture’s boundary may change.

Frequently Asked Questions

Can Excel center a picture in a cell with one click?
Not for a floating picture. Excel’s object-alignment commands do not provide a direct center-in-this-cell command. An in-cell picture fills the cell area; for a smaller floating picture, position it by comparing its margins with the cell edges.

What is the difference between Place in Cell and Place over Cells?
Place in Cell makes the image cell content that follows the cell in the worksheet. Place over Cells leaves it as a separate object layered above the grid. The first is useful for table data; the second gives you more freedom to position and size an image.

Will the image stay centered if I change the cell size?
An in-cell image adjusts with its cell. A floating picture set to Move and size with cells follows changes to the underlying grid, but a major row or column resize can alter its margins. Check the alignment again after changing dimensions.

Can I center an image in a merged cell?
Yes, but merged cells can make selecting and sizing more awkward. Treat the full merged area as the target: use an in-cell picture if available, or align a floating picture to the outside edges of the merged area. Avoid sorting tables that rely on merged cells.

Do these steps work in Excel for Mac or Excel for the web?
The general idea is the same, but menu names and feature availability can differ by platform and update. On Mac, look for Picture Format and the picture’s formatting pane; Option may be used where Windows uses Alt for grid snapping. In Excel for the web, use Place in Cell if it appears in the Pictures menu, or open the workbook in desktop Excel for the fuller picture-formatting controls.

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.