To put a picture inside an Excel cell in Microsoft 365 for Windows, select the cell and choose Insert > Pictures > Place in Cell, then select the image source and file. If you already copied a picture, paste it onto the worksheet, select the picture, and choose Picture Format > Place in Cell. An image placed in a cell behaves differently from one that merely floats over the grid, so use the in-cell option when you want it to stay with the row or column as your sheet changes.
What You’ll Need
- A workbook you can edit in a current version of Excel for Microsoft 365. The Place in Cell commands may be missing in older Excel versions or in installations that have not received the feature update.
- An image file on your computer, an image source available in Excel, or a picture already copied to your clipboard. Common formats such as PNG and JPEG are suitable for typical worksheet images.
- A destination cell and, if you are preparing a catalog or tracker, a plan for the row height and column width you want the image to fit.
Keep a copy of the original image if you may need it at a different size or for another purpose. For a shared workbook, also consider whether other people will have access to the image source or whether the picture should be stored directly in the workbook.
Step-by-Step
- Choose the destination cell. Open the workbook and click the cell where the image should belong. If you are creating a product list, for example, make a dedicated column such as “Photo” and use one image per row. A single cell is the anchor for the image; the image may appear larger than the cell until you adjust the row and column dimensions.
- Insert a new image directly in the cell. On the Windows ribbon, select Insert > Pictures > Place in Cell. Choose This Device to browse to a local file, or choose another available source, such as stock or online pictures. Select the image and confirm the insertion. Excel places the picture as cell content rather than as a separate object sitting above the grid. Some ribbon layouts show the source choices slightly differently, but look for the Place in Cell option rather than the regular picture insertion command.
- Paste an image you have already copied. Copy the image from a source that allows copying, return to Excel, and press Ctrl+V to paste it. In many cases, the pasted picture initially appears as a floating object over the worksheet. Click the picture once to select it, then open the Picture Format tab and choose Place in Cell. If your version offers a specific “Paste Picture in Cell” command when you right-click the destination cell, you can use that instead. Check the result rather than assuming that an ordinary paste created cell content.
- Confirm that it is really in the cell. Click an empty part of the worksheet, then select the picture or its cell. A floating picture can be selected independently and dragged around the grid. An in-cell picture is associated with its cell and is handled as cell content. The exact selection outline can differ between Excel updates, so use the Picture Format command or the cell’s behavior when rows and columns change as additional checks.
- Set a useful column width and row height. Drag a column boundary to widen the image column and a row boundary to increase the row height. For a specific size, use Home > Format > Column Width or Home > Format > Row Height and enter a value. Make the cell large enough for the image to be recognizable. If your worksheet uses standard-sized rows, consider adjusting the entire image column and the relevant rows consistently.
- Adjust the image’s fit if needed. An in-cell picture is constrained by its cell, and Excel scales it to fit while retaining its proportions. If it looks too small, enlarge the cell by changing the row height or column width. Avoid stretching the row or column far beyond what the rest of the table needs; a separate, consistently sized photo column usually makes a cleaner list. If an image appears cropped or unusually positioned, select it and check the picture options available in your Excel build.
- Repeat for other rows. Select the next destination cell and insert or paste the next picture. Keep each picture in the same column if you want a readable catalog. Before inserting a large batch, test two or three images and confirm that they remain aligned with the correct records when you adjust the layout.
- Save and check the workbook. Save with Ctrl+S. If the file will be opened in Excel for the web, on a Mac, or by someone using an older desktop version, reopen or share a copy in that environment and verify that the images display and the commands behave as expected. Features can vary by version and update channel.
Mac and web note: In Excel for Mac, the Place in Cell feature may be available from Insert > Pictures or the picture-formatting controls, depending on the update installed. Use Command+V instead of Ctrl+V to paste from the clipboard. Excel for the web has image insertion options, but the available sources and controls can differ from the Windows desktop app; if Place in Cell is not shown, open the workbook in an updated desktop version of Microsoft 365 and use the steps above.
Common Mistakes
- Using regular picture insertion and stopping there. Choosing the ordinary picture option, or pressing Ctrl+V without converting the result, can leave a floating object on top of the worksheet. It may look as though it is in the cell, but it can cover neighboring cells and move independently. Use Place in Cell and verify the result.
- Expecting the image to fill a tiny cell. A very small row height or narrow column can make a picture difficult to see. Increase the cell dimensions; do not assume Excel will enlarge the row automatically to suit every image.
- Resizing by dragging the image when it is floating. This changes the size of the object, not necessarily the dimensions of the destination cell. For an in-cell image, adjust the row height and column width instead.
- Putting several pictures in one cell. A cell is not a free-form picture canvas. Use one image per cell, or insert multiple pictures as separate objects if the layout specifically requires a collage.
- Assuming images will behave identically in every Excel version. A recipient using an older version or a different spreadsheet app may not see the same in-cell behavior or editing controls. Confirm compatibility before building a workbook that depends on this feature.
- Inserting oversized or needlessly high-resolution files. Large image files can increase workbook size and make it slower to save or share. Use a suitably sized copy for the worksheet, while keeping the original separately if full resolution matters.
Tips
- Make a dedicated image column. A consistent Photo column helps readers scan a product list, staff directory, or inventory sheet without images obscuring important data.
- Standardize the layout before adding many pictures. Set the photo column width and typical row height first. This reduces later adjustments and makes the finished sheet more uniform.
- Use descriptive labels beside images. Include a name, product ID, or other identifying value in a neighboring cell. A picture alone may be hard to identify when a workbook is sorted, filtered, or printed.
- Test sorting and filtering. In-cell pictures are designed to stay with their cells, but verify that your data range includes the image column and that a sort keeps each photo with its corresponding record. Select the complete table, not just one column, before sorting.
- Keep the file easy to share. Save in a standard Excel workbook format such as .xlsx when possible. If a workbook is unusually large, check the image sizes and remove unused pictures before sending it.
- Consider accessibility. Where Excel provides picture description or alt-text controls, add a short description for an image that conveys useful information. Do not rely on color or the picture alone to communicate a value that should also appear as text.
Troubleshooting
Place in Cell is missing: Confirm that you are using an updated Excel version that supports in-cell pictures and that you are looking under Insert > Pictures or the selected picture’s formatting controls. If the workbook is open in an older desktop version or another spreadsheet program, the command may not be available. Update Microsoft 365 if permitted, or use a supported desktop version.
The picture floats over the worksheet: Select the picture itself, not just the cell underneath it. When the Picture Format tab appears, choose Place in Cell. If the image is difficult to select, click a visible edge or use Excel’s Selection Pane if available in your build. A picture that simply sits within the cell’s borders is not necessarily cell content.
The image looks too small: Increase the destination column width and row height. Excel fits an in-cell image within the cell, so a small cell limits the display size. Check that you changed the correct row and column and that the sheet is not zoomed out enough to make the image appear smaller than it is.
The image does not paste: Check that the source application actually copied an image, then try copying again. As a dependable alternative, save the picture as a file and insert it using Insert > Pictures > Place in Cell > This Device. On a Mac, use Command+V for clipboard pasting; in a browser, clipboard permissions or the source site may restrict copying.
The picture is beside the wrong record after sorting: Select and sort the entire table, including the image column, rather than sorting a single data column by itself. If the picture was a floating object rather than cell content, convert it with Place in Cell and check the table again. Save a copy before making major layout changes so you can restore the original if needed.
The file is slow or too large: Reduce the dimensions or file size of images before inserting them, and remove pictures that are no longer needed. If you are working with many high-resolution images, split the catalog into smaller workbooks or keep full-size originals in a separate folder and use smaller worksheet copies.
Frequently Asked Questions
Can I paste a picture directly into an Excel cell?
Yes, if your Excel version offers a Paste Picture in Cell command for the copied image. Otherwise, paste it onto the sheet, select the floating picture, and choose Picture Format > Place in Cell. Confirm that it is cell content before relying on it to move with a record.
What is the difference between a picture in a cell and a picture over cells?
A picture over cells is a separate worksheet object that can cover cells and be moved independently. A picture in a cell is associated with that cell, making it more suitable for tables where images should stay with their data.
Will an in-cell picture move when I resize a row or column?
It remains associated with its cell, and its display adjusts to the available cell space. If the cell becomes smaller, the image may also appear smaller. Increase the row height or column width to give it more room.
Can I put more than one image in a cell?
The in-cell picture feature is intended for a single picture in a cell. For a collage, use separate cells or arrange separate floating picture objects, bearing in mind that floating objects require more careful positioning.
Can I use this in Excel for Mac or Excel for the web?
Availability depends on the version and update installed. Look for Place in Cell in the Insert or picture-formatting controls. If you do not see it, use an updated Microsoft 365 desktop app that supports the feature; on Mac, Command+V is the paste shortcut.
Will the image print with the worksheet?
In-cell pictures are part of the worksheet content and can print with the sheet. Use Print Preview to check the scaling, page breaks, and row heights, since a picture may be clipped or reduced if the table does not fit the printed page.
Related
- How to Insert an Image in Google Sheets: In a Cell
- How to Insert an Image in an Excel Sheet: Full Guide
- How to Insert an Image in a Single Cell in Excel: A Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: Insert a Page Break After Every Row ManuallyYes. For a few breaks, select the row immediately below the place you want to split, then choose…
- Conditional Formatting in Excel for the Web: A GuideYes. In Excel for the web, select the cells you want to format, then choose Home > Conditional…
- Compress Photos in PowerPoint to Reduce File SizeTo compress photos in PowerPoint for Microsoft 365 on Windows, select a picture, go to Picture Format >…
- How to Hang Indent in Word for Citations and ListsTo create a hanging indent in Word, select the paragraph or paragraphs, open the Paragraph settings, and choose…
- Outlook Calendar Sharing: How to Share DetailsTo share Outlook calendar details, open Calendar, choose Share Calendar or Share, add the person, and select a…
- Excel: How to Get Rid of Page Break Lines on a SheetTo hide page break lines in Excel for Microsoft 365 on Windows, open File > Options > Advanced,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.