To center a picture in an Excel cell, use Insert > Pictures > Place in Cell in Microsoft 365, or convert an existing floating picture with Picture Format > Place in Cell. If you need a picture to remain a separate object, resize and position it over the cell instead. The first method is usually easier to keep aligned as the worksheet changes.
What You’ll Need
- Excel for Microsoft 365 on Windows for the steps below. The Place in Cell feature is also available in supported versions of Excel for Mac and Excel for the web, though the ribbon layout can vary.
- The image file you want to use, such as a PNG or JPG, saved somewhere you can browse to.
- A worksheet with the target cell identified. For a tidy result, decide how wide the column and how tall the row should be before adding the image.
Step-by-Step
- Choose the cell and set its size. Click the cell that should contain the picture. If you want a larger thumbnail, widen its column by dragging the boundary between column letters, and increase the row height by dragging the boundary between row numbers. You can also use Home > Format to set a specific column width or row height. Making this decision first prevents you from having to redo the image layout later. Remember that changing a whole column or row affects every cell in it.
- Insert a picture as cell content. With the target cell selected, open Insert > Pictures > Place in Cell, then choose This Device to browse for a local file. Select the image and click Insert. Excel puts the image in the selected cell rather than laying it over the worksheet as a separate object. In current Microsoft 365 builds, you may also see choices for stock images or online sources in the Pictures menu.
- Check how the picture fits. Excel scales an in-cell picture to display within its cell. If the row is short or the column is narrow, the picture will look small; enlarge the cell if you want a larger display. Keep an eye on the image proportions: a narrow cell cannot show a wide photo at the same apparent size as a square cell. The in-cell approach is useful when you want the picture associated with that specific record and to move with the cell when you sort or rearrange data.
- Convert an existing floating image if needed. If the picture is already on the sheet, click it once to select it. Open the Picture Format tab and choose Place in Cell. In some builds, you can right-click the picture and choose Place in Cell from its context menu. Excel moves the image into a cell; check which cell becomes its home, especially if the picture was positioned across several rows or columns. If the command is not shown, update Excel or use the floating-picture method below.
- Use a floating picture only when you need independent placement. A floating image sits above the grid, so it is not the same as an image stored in a cell. Select Insert > Pictures and insert the file without choosing Place in Cell. Resize the row and column first. Then drag the picture over the target cell. On Windows, hold Alt while moving or resizing to help snap the picture’s edges to cell boundaries. This helps line up its frame, but it does not automatically center a smaller picture inside a larger cell.
- Make the floating picture’s frame match the cell if you want a centered-looking result. A practical way to avoid uneven margins is to make the picture frame cover the cell from edge to edge, then use cropping to control what appears inside it. Select the picture, go to Picture Format > Crop, and adjust the crop handles so the subject sits in the middle of the frame. Drag the frame edges to the cell boundaries while holding Alt on Windows. If you want the whole original image visible and do not want cropping, keep its proportions and accept that the margins around it may not be identical.
- Confirm the picture behaves the way you expect. For a cell picture, change the row height slightly and check that the image remains associated with that cell. For a floating image, right-click it and open Size and Properties, then check the options under Properties. Choose Move and size with cells if the picture should track changes to the cell area, or another property if you need it to remain independent. The precise pane layout can vary by Excel build.
- Review the worksheet at normal size. Zoom back to a useful viewing level and check the picture against neighboring cells. Confirm that it is not covering a value, that the subject is visible, and that the row and column are not unnecessarily large. Save the workbook after the layout looks right.
Common Mistakes
Confusing an image over a cell with an image in a cell: A floating image can look as if it belongs to a cell while actually sitting above the grid. It may cover text, fail to sort with its record, or drift when rows change. Use Place in Cell when the image should behave like cell content. Keep a floating picture when you need to layer it or position it freely.
Trying to center with the cell’s alignment buttons: The horizontal and vertical alignment controls on the Home tab format text and other cell values. They do not reliably reposition a floating picture object. For a picture that must stay with its record, use Place in Cell. For a floating object, position its frame directly or use cropping to make the visible subject look centered.
Dragging a corner without considering the cell size: Resizing by eye can leave uneven gaps, or make the image overlap nearby cells. Set the row and column dimensions first. When resizing a floating picture, use a corner handle to preserve the image’s proportions; dragging a side handle can stretch and distort the subject.
Stretching a photo to fill a cell: A wide image forced into a tall, narrow area can look squashed. Decide whether the priority is showing the whole image or filling the cell. To show everything, preserve the proportions and allow unused space. To fill a cell, crop some of the image and place the important subject near the center.
Forgetting that sorting and filtering affect objects differently: A floating image may not travel with the intended row unless its properties are set appropriately. In-cell images are generally simpler for lists and catalogs. If you keep floating objects, inspect their movement properties and test a sort on a copy of the sheet first.
Tips
- For product lists, staff directories, or photo inventories, keep one image per row and use Place in Cell. Give the image column a consistent width and the rows a consistent height so the sheet looks orderly.
- Crop images to a consistent shape before inserting them when the subject needs to look uniform, such as a set of profile photos. Keep an untouched copy of each original if the crop removes important detail.
- Use descriptive file names and, where your workflow supports it, add useful alternative text to floating pictures. This makes a workbook easier to maintain and more accessible to people who use assistive technology.
- For a floating picture that should move with a cell, use Move and size with cells in the picture’s Size and Properties pane. This is helpful when the row or column might be resized, but it may also resize the picture along with the cell.
- On Mac, the Picture Format tab and Place in Cell option may appear in a slightly different ribbon arrangement. For snapping while dragging, try holding Option; if the version does not snap as expected, zoom in and align the image frame carefully. Excel for the web may offer fewer detailed picture-formatting controls than the Windows desktop app.
Troubleshooting
The Place in Cell option is missing: Confirm that you selected a picture, not a cell or a chart, if you are trying to convert an existing image. For a new image, open the Pictures menu and look specifically for Place in Cell. The feature may not appear in an older Excel release or an installation that has not received current updates. Update Microsoft 365 and reopen the workbook, or use a floating picture as a workaround.
The picture is too small: Increase the cell’s row height or column width. An image cannot look large if its cell is tiny. Also check that you did not insert a thumbnail or low-resolution source file; enlarging a small source may make it look blurry.
The subject looks off-center even though the picture is in the cell: The subject itself may be off-center within the source photo. The image can be centered as a whole while a person or product appears shifted. Crop the source or adjust the crop on a floating picture so the subject, rather than just the image edges, sits in the visual center.
A floating picture moves when rows or columns change: Right-click the image, choose Size and Properties, and review the options under Properties. Select the behavior that matches your layout. If the picture should stay fixed on the sheet, do not use Move and size with cells; if it should remain attached to a record, consider converting it to an in-cell image instead.
The picture covers data or overlaps neighboring cells: Select it and move or resize it, or convert it to an in-cell image. If it is meant to cover only one cell, check that its frame does not extend beyond that cell. Increase the cell dimensions or crop the image rather than compressing the photo out of proportion.
The image looks different after printing: Check the print preview and the worksheet’s scaling settings. Row heights, column widths, and page scaling can change the apparent size of a picture on paper. If exact placement matters, print a test page and adjust the cell dimensions or the floating picture’s crop and frame.
Frequently Asked Questions
Can I center a picture in a cell using the Center button on the Home tab?
The Center button aligns cell contents such as text; it is not a dependable control for positioning a floating picture. Use Place in Cell for an image tied to a cell, or position the floating picture frame itself.
What is the difference between Place in Cell and a floating picture?
Place in Cell stores the image as content associated with a cell, which is useful for tables that are sorted or reorganized. A floating picture is an object positioned above the grid and can overlap cells. Its movement depends on its picture properties.
Can I put more than one picture in a cell?
A cell is designed to contain one in-cell image at a time. To show several pictures together, use separate cells or arrange floating pictures over the worksheet. Keep in mind that floating objects need extra checking when the sheet is sorted or resized.
Will the picture resize when I change the row height or column width?
An in-cell picture is displayed within its cell, so its visible size responds to the available space. A floating picture follows the behavior selected under its Properties settings. Choose Move and size with cells if you want the floating object to resize with the cell area.
Can I do this in Excel for Mac or Excel for the web?
Current supported versions may include Place in Cell, but the ribbon layout and available picture controls can differ. If you cannot find the command or need precise cropping and placement, use the updated Excel desktop app. On Mac, try Option rather than Alt for snapping while dragging.
Related
- How to Add Weekday Dates in Excel
- How to Add Superscript Numbers in Excel: Step-by-Step
- How to Add Serial Numbers in Excel Automatically
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Billion Number Format in Excel: Display Values in BillionsTo display numbers in billions without changing their stored values, select the cells, press Ctrl+1, choose Number >…
- Google Sheets Formulas vs Excel: Key DifferencesGoogle Sheets and Excel use many of the same formula conventions, so everyday calculations such as sums, averages,…
- How to Double Space a Header in Microsoft Word 365To double space a header in Word, open the header, select its text, then choose Home > Line…
- How to Change Slide Size in PowerPoint to A3To change a PowerPoint presentation to A3, open the Design tab, choose Slide Size > Custom Slide Size,…
- Change Text to Lowercase in Excel: Steps and Tips That WorkTo change text to lowercase in Excel, enter =LOWER(A2) in a blank helper cell when the text to…
- Compare Data in Two Excel Sheets: Methods and ChecksYes. In Excel for Microsoft 365 on Windows, you can compare two sheets by checking matching cells with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.