To insert an image in Excel for Microsoft 365 on Windows, select a cell, then choose Insert > Pictures > Place in Cell > This Device and select the file. To add a movable picture above the worksheet instead, choose Insert > Pictures > Place over Cells > This Device. The key choice is whether the picture should behave like cell content or like an object laid over the grid.
Choose between a picture in a cell and a floating picture
Excel supports two useful picture arrangements. A picture placed in a cell becomes that cell’s content. It can move and resize with the cell, and it is easier to keep associated with a row when you sort or filter a list. This is useful for product photos, staff portraits, maps, or small visual markers in a structured table.
A picture placed over cells is a separate object positioned on top of the worksheet. It can cover one cell or several, and you can drag it freely. This arrangement suits a logo, a diagram, a screenshot, or a decorative image in a report. It is not technically contained by the cell underneath it, even if it appears to fit neatly inside the cell boundaries.
In older Excel versions, pictures are generally floating objects. If your Insert > Pictures menu does not show a Place in Cell option, your Excel version or update channel may not include that feature. You can still insert a floating picture and adjust its properties so it moves or resizes with worksheet cells.
Insert an image from your computer
For a picture stored on your PC, use the file picker rather than dragging the file onto the worksheet. The menu labels can change slightly as Microsoft updates Office, but the usual Microsoft 365 steps are:
- Select the worksheet cell where you want the image to appear. For a floating picture, select a nearby cell to help position the image when it is inserted.
- Open the Insert tab, select Pictures, and choose Place in Cell or Place over Cells.
- Choose This Device, browse to the image, select it, and choose Insert.
- Check the result at the current zoom level. If it is too large or small, adjust the row height, column width, or picture size as appropriate.
Common formats such as JPG and PNG are suitable for ordinary photographs and graphics. A JPG is often convenient for a photograph; a PNG is commonly useful for a logo or graphic that needs a transparent background. The exact formats available can depend on the Office build and operating system. If a file will not insert, try opening it in an image editor and saving a fresh copy as PNG or JPG.
Excel may also show other picture sources, such as stock or online images, depending on the version and account. Those choices are not necessary when you already have a local file. For a work or school workbook, also check that you are allowed to use and share the image before adding it.
Adjust size, position, and appearance
For a floating picture, select it and drag a corner sizing handle to change its size while keeping its proportions. Dragging a side handle can stretch or compress it. To reposition it, drag the picture itself; avoid dragging a sizing handle by mistake. The Picture Format tab appears when a picture is selected and provides additional sizing, cropping, and style controls.
For a picture in a cell, the cell dimensions determine how much of the image is shown. Increase the column width or row height if the picture looks cramped. You can change those dimensions from the Home tab using the Cell Size controls, or drag the boundary between column letters or row numbers. Be aware that changing a row’s height or a column’s width affects other cells in that row or column too.
Use Crop on the Picture Format tab when you want to show only part of a floating image. Cropping changes the visible portion, not the original source file. For a product catalog, for example, you might crop a large source photo to focus on the item, then keep the product name and price in adjacent cells. If the picture looks distorted, undo the change and resize from a corner rather than stretching one side.
Floating pictures have placement properties that control how they respond to grid changes. Select the picture, open the Format Picture pane, then expand Size & Properties and Properties. The options include Move and size with cells, Move but don’t size with cells, and Don’t move or size with cells. Choose the first when the image should track both the position and dimensions of its row or column; choose the second when it should move with a row but retain its size.
Keep pictures aligned with rows and records
Images are most useful in a data list when each image stays with the correct record. A picture in a cell is often the simplest choice for a table that will be sorted or filtered. Keep each image in the same row as its related text and other fields, and avoid placing one large floating picture across several records if those records may be rearranged.
When using floating pictures, set their properties deliberately and test the worksheet. Insert a few pictures, sort the relevant rows, and confirm that each image still corresponds to the correct record. Picture behavior can also be affected by merged cells, hidden rows or columns, and how the object overlaps the grid. A small test is safer than assuming that an image’s visual location guarantees its relationship to the underlying data.
For a cleaner catalog, use consistent row heights and column widths, and keep pictures at a similar scale. Consider adding a text description in a separate column. That makes the information easier to search and can help readers who cannot see the image.
Insert pictures in Excel for the web or on Mac
Excel for the web offers picture insertion through the Insert tab, but available sources and picture controls may differ from the Windows desktop app. If you cannot find Place in Cell, check whether your web version provides it or use the available picture insertion option, then treat the result as a floating object. Some formatting or placement controls may be more limited in a browser.
On Excel for Mac, use the Insert tab and its Pictures options to choose a picture source. The wording and arrangement of commands can differ from Windows, and the available options depend on the Mac app version. If an instruction refers to This Device or a specific placement choice that is not visible, check the equivalent Pictures menu in your build. The Mac undo shortcut is Command+Z; on Windows it is Ctrl+Z.
When a workbook is shared between desktop Excel and Excel for the web or Mac, open it in the version your collaborators use before relying on a specialized picture feature. A floating picture is a broadly familiar option, while newer in-cell picture behavior may not be handled identically in every older app version.
Common picture problems and fixes
- The picture is too large: Resize a floating image using a corner handle, or reduce the row height and column width available to an in-cell image. Check the worksheet zoom before assuming the actual size is wrong.
- The image is hidden behind something: Floating pictures can overlap cells and other objects. Select the picture and use the Picture Format arrangement controls to bring it forward, or move it to an unobstructed area.
- The image does not stay with its row: For a floating picture, check Format Picture > Size & Properties > Properties. Choose the appropriate move-and-size option, or replace it with a picture in a cell if that feature is available.
- The file will not insert: Confirm that the file opens normally, then save a copy in a common format such as PNG or JPG. Also check that the file is available locally and not merely represented by an unavailable cloud placeholder.
- The image looks blurry: Use a source image with enough pixels for the displayed size. Enlarging a small thumbnail does not restore detail, and a screenshot or compressed image may already have lost quality.
- The picture covers worksheet values: Move or resize a floating picture, or place it in a cell. For a report, consider moving images to a dedicated column rather than laying them over important data.
If a change produces an unexpected result, use Ctrl+Z on Windows or Command+Z on Mac immediately. Undo works for many recent picture edits, but it is not a substitute for saving a copy before making extensive changes to an important workbook.
When to use the IMAGE function or another approach
For a workbook that needs images fetched from web addresses, Excel’s IMAGE function can display an image from a URL in a cell in supported versions, including Microsoft 365. It is useful when a list already stores image URLs, but it depends on an accessible image address and may not work with links that require authentication or redirect through a page instead of pointing to an image. It is not the same as inserting a local picture file, and it is not the best choice if the workbook must work in an older Excel version.
If you need a simple visual mark rather than a photograph, a symbol, text label, or conditional formatting rule may be easier to maintain. If you need a large diagram or a page designed for presentation, PowerPoint or a dedicated graphics tool may give you more control than placing many floating pictures on a worksheet. Choose the method based on whether the image is data, decoration, or part of a designed page.
Frequently Asked Questions
How do I insert a picture into an Excel cell?
Select the cell, then choose Insert > Pictures > Place in Cell > This Device and select the image. If Place in Cell is not available in your Excel build, insert the picture as a floating object and use its placement properties instead.
How do I insert a picture in Excel without covering cells?
Choose Place in Cell when that option is available. Otherwise, insert a floating image and resize or move it into a clear area. A floating object always sits above the worksheet grid, so it can cover cell contents if positioned over them.
Can I sort or filter a table that contains pictures?
Yes, but use pictures placed in cells when possible and keep each picture in the same table row as its record. With floating pictures, check the object properties and test a sort on a copy of the data to confirm that pictures stay associated with the right rows.
Why can’t I see Place in Cell in Excel?
The option may be missing because your Excel version or update channel does not include the feature, or because the app’s interface differs. Update Microsoft 365 if appropriate, or insert a floating picture and configure its movement and sizing behavior.
Can I insert a picture from a website?
Depending on your Excel version, the Pictures menu may offer an online source, or you can use the IMAGE function with a publicly accessible image URL in supported Excel versions. A normal webpage link is not necessarily a direct image link, and a URL requiring sign-in may not display for other workbook users.
Related
- Share an Excel Document on Google Docs: Step by Step
- Excel Color Based on Value with Conditional Formatting
- Excel Custom Number Format: How to Create and Apply It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Array Formula SUM: Examples and FixesTo add values in Google Sheets, use =SUM(B2:B) when the numbers are in column B from row 2…
- Google Sheets Filter Shortcut: Keys and Quick TipsIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac,…
- Indent Down in an Excel Cell: Steps and FixesTo indent text in an Excel cell, select the cell and choose Home > Increase Indent. This moves…
- Excel Not Responding: How Long Should You Wait?There is no fixed time after which Excel is safe to close: wait at least a few minutes,…
- How to Add Double Spacing in WordTo double-space text in Microsoft Word, select the text—or press Ctrl+A on Windows or Command+A on Mac to…
- How to Find Version History in Excel and Restore a CopyTo find version history in Excel for Microsoft 365 on Windows, open the workbook saved in OneDrive or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.