In Excel for Microsoft 365 on Windows, select a cell and choose Insert > Pictures > Place in Cell > This Device, then select your image and choose Insert. Excel places the picture in the cell rather than floating above the worksheet, so it can move and resize with the cell. You will need an image file and a workbook you can edit.
What You’ll Need
- Excel for Microsoft 365, preferably updated, with the Place in Cell command available.
- A picture file saved on your computer, such as a JPG, PNG, BMP, or GIF.
- A worksheet and a target cell. Consider making the column wider and row taller before inserting if you already know the space the picture needs.
The instructions below are for Excel for Microsoft 365 on Windows. The Place in Cell feature is also available in supported versions of Excel for the web and Mac, although the menu labels or placement can differ slightly. If your Excel does not show the feature, check for updates or use the floating-picture workaround described in Troubleshooting.
Step-by-Step
- Choose the destination cell. Open the worksheet and click the cell where the picture should belong. For example, if column A contains product names and column B will contain product photos, select the appropriate cell in column B. A picture occupies that cell’s contents, so do not select a cell that already contains text or a value you need to keep. If the destination is part of a table, select the cell in the table row where the image should appear.
- Make room for the picture if needed. Adjust the column width and row height before inserting, or resize them later. To change a column width, drag the boundary between its letter headings; to change a row height, drag the boundary between its numbered headings. You can also use Home > Format to set a specific row height or column width. The dimensions you choose determine how large the in-cell picture can appear on the sheet.
- Open the in-cell picture command. On the ribbon, select Insert > Pictures > Place in Cell > This Device. In some Excel builds, the Pictures button may appear as an icon or have a slightly different layout, but choose the option that explicitly says Place in Cell. Do not choose an option that only inserts a picture over cells if you want the image to behave as cell content.
- Select the image file. In the file picker, browse to the folder containing your picture, click the file, and choose Insert. If you cannot find the file, check the folder, file type filter, and spelling of its name. Excel inserts the image into the selected cell. The picture may look small if the row or column is narrow; that does not necessarily mean the file was inserted incorrectly.
- Check the result and adjust the cell dimensions. Click another cell and then select the image’s cell again. Increase the row height or column width if you want the picture displayed larger. The picture stays associated with its cell as the cell size changes. Avoid enlarging the image so much that it becomes difficult to compare with nearby rows or pushes useful worksheet information out of view.
- Insert more pictures, if required. Repeat the same process for each destination cell. If you have several images, insert them one at a time into the intended cells so each picture is associated with the right record. Keep a consistent row height and column width for a catalog or inventory list. That makes the pictures easier to scan and gives the worksheet a more orderly appearance.
- Confirm that the picture is in the cell. Select the image and look for the in-cell selection behavior, or right-click it and check whether Place in Cell is available as a conversion option. You can also test by changing the row height or sorting a small test range: an in-cell picture should follow its cell. A picture that remains independently positioned over the grid is a floating picture, not an in-cell image.
- Save the workbook. Press Ctrl+S on Windows. On a Mac, use Command+S. Save as an Excel workbook, such as .xlsx, if you want to retain the worksheet and its image behavior. If you share the file with people using older Excel versions or another spreadsheet program, ask them to verify that the pictures display correctly in their software.
To convert an existing floating picture: Select the picture, right-click it, and choose Place in Cell if that command appears. Excel moves the image into a cell, usually the cell beneath the picture’s upper-left area. Check that it landed in the correct row and column. If it did not, undo with Ctrl+Z on Windows or Command+Z on Mac, select the intended cell, and insert the image directly using the steps above.
On a Mac or in Excel for the web, look under Insert > Pictures for the in-cell option. The exact wording and available sources can vary by platform and update. If the menu only offers a picture that sits over the sheet, it is not the same operation; use the right-click conversion option if available, or follow the workaround in Troubleshooting.
Common Mistakes
- Choosing the wrong insertion option. Excel can place pictures over the worksheet or inside a cell. A floating image may cover several cells and can drift when you change the layout. Choose Place in Cell when the image should belong to one cell and follow it during sorting or filtering.
- Inserting into a cell that already has data. An in-cell picture is the cell’s content; it does not sit alongside existing text in that same cell. Put the picture in a separate column, or move the existing value to another cell before inserting. If the existing value matters, copy it somewhere safe first.
- Expecting the picture to set the row or column size automatically. The cell’s dimensions control the visible space. A tiny image usually calls for a taller row, a wider column, or both. Enlarging only the picture is not the same as giving the cell more room.
- Using an inconsistent range when sorting. If you sort only the picture column instead of the complete list, photos can become separated from their product names or IDs. Select the whole data range, including its headers, and sort the records together.
- Assuming every Excel version supports in-cell images. Older desktop releases and some third-party spreadsheet apps may not offer the feature or may display images differently. Check compatibility before relying on the workbook as a shared catalog or form.
Tips
- Use a dedicated image column. Keeping pictures in their own column preserves room for names, codes, prices, and notes. It also makes it easier to filter or sort the other fields without confusing image content with text.
- Standardize the display size. Set a consistent column width and row height for the image column. If the source pictures have different proportions, the amount of empty space around each one may vary, but the aligned cells still make the list easier to read.
- Use clear, reasonably sized source files. Very large photos can make a workbook slower to save, open, or share. Crop unnecessary background or reduce image dimensions in an image editor before insertion, while keeping enough detail for the picture’s purpose.
- Keep a source copy of important images. Store originals in a known folder or shared location. A workbook is convenient for viewing, but keeping the original files separately makes replacement and reuse easier if a picture is deleted or needs an update.
- Add alternative text where appropriate. Select the picture and use the available alt-text command, often through the right-click menu, to describe useful information for readers using screen readers. A short description such as “Blue insulated bottle, front view” is more helpful than a generic label like “image.”
- Test sorting and filtering on a copy first. In-cell images are designed to behave with their cells, but it is sensible to test a small sample before rearranging a large or important list. Keep each record’s identifying fields within the same sorted range.
Troubleshooting
“Place in Cell” is missing. Confirm that you are using a supported, updated version of Excel and that you opened the Pictures menu rather than a different image tool. On Windows, use File > Account > Update Options > Update Now if your organization allows updates. On Mac, use Help > Check for Updates when Microsoft AutoUpdate is installed. If the feature still is not available, your account, release channel, or app version may not have it yet.
The picture is too small or appears cut off. First increase the destination row height and column width. Then check whether the picture is actually in the cell or is a floating image positioned over it. A picture’s visible size is constrained by the cell area; widening the column or increasing the row height gives it more space. If the source image itself is too small or low-resolution, enlarging the cell cannot restore missing detail.
The picture landed in the wrong cell. If you have just inserted or converted it, undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Select the intended destination cell and insert it again. When converting a floating image, Excel uses its position on the grid to determine the cell, so moving the image’s upper-left area over the correct cell before conversion can help.
The picture does not move with a row or sort. It may still be floating, or the sort may have included only part of the data. Try right-clicking the image and choosing Place in Cell. For sorting, select the complete table or data range so each row’s picture stays with its other fields. If you are working in a filtered list, verify the results on a copy before making extensive changes.
The recipient cannot see the image. Save the workbook as .xlsx, then reopen it or share a copy to confirm it is present. The recipient may be using an older version or a program that handles in-cell pictures differently. Ask them to open the file in a current version of Excel for Microsoft 365 or Excel for the web. If broad compatibility is essential, consider sharing a PDF for viewing as well as the editable workbook.
Workaround when in-cell insertion is unavailable: Insert a regular picture using Insert > Pictures, then resize and position it over the target cell. Right-click the picture, choose Format Picture, open Size & Properties, and under Properties choose Move and size with cells, if that option appears in your version. This makes the floating picture follow cell changes more closely, but it is still not cell content and may behave differently when sorting. Use it only when Place in Cell is unavailable.
Frequently Asked Questions
Can I put both text and a picture in the same Excel cell?
An in-cell picture uses the cell’s content, so it does not share that cell with ordinary text. Put the text in a neighboring cell, such as a description column beside the image column.
Will an image in a cell move when I sort the worksheet?
Yes, an in-cell image is associated with its cell and is intended to move with that cell. Sort the complete data range, not just one column, so the picture remains with the correct record.
Can I insert a picture into multiple cells at once?
The simplest reliable method is to insert each picture into its destination cell individually. You can select and insert multiple files in some picture workflows, but Excel may place them as floating objects rather than assigning each one to a specific cell. Check the result and convert each image if needed.
Does inserting a picture change the cell’s value?
Yes. The picture becomes the content of the selected cell, replacing any existing cell value. Move or copy existing text first if you need to preserve it.
Can I insert images in Excel for the web?
Supported versions of Excel for the web include in-cell picture options under Insert > Pictures, though the exact choices can vary. If you do not see Place in Cell, try opening the workbook in an updated desktop version that supports the feature.
Can I use a picture from a website?
You can save an image you are permitted to use and then select that file through the picture picker. Check usage rights and your organization’s rules before using online images, especially in a workbook that will be shared or published.
Related
- Import Excel into a SharePoint List: Step-by-Step
- How to Highlight a Row in Excel with a Keyboard Shortcut
- How to Import an Excel Document Into Microsoft Word
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Power Query: Keep Only Selected ColumnsTo keep only certain columns in Excel Power Query, open the query, select the columns you want, then…
- Excel Text to Columns: Can It Split Capital Letters?No: Excel’s Text to Columns command cannot automatically split a cell wherever a capital letter appears. It splits…
- How to Delete a Hard Page Break in Microsoft WordTo delete a hard page break in Word, show formatting marks, find the line labeled Page Break, then…
- Change Email List View in Outlook: A Step-by-Step GuideTo change your email list view in Outlook, open the view or layout controls and choose how messages…
- How to Open Excel in a Browser and Edit Your FilesTo open Excel in a browser, go to microsoft365.com, sign in with a Microsoft account, and select Excel.…
- Excel Power Query Shortcuts: Refresh, Edit, and MoreIn Excel for Microsoft 365 on Windows, press Ctrl+Alt+F5 to refresh all workbook data connections, including Power Query…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.