To insert an image in Excel for Microsoft 365 on Windows, select the worksheet, choose Insert > Pictures > This Device, select an image file, and click Insert. Excel places the picture on top of the cells; you can then move, resize, or crop it. Have the image file ready and save the workbook after you finish.
What You’ll Need
- An Excel workbook that you can edit. The steps below are for Excel for Microsoft 365 on Windows.
- An image saved on your computer, such as a PNG or JPEG. Use an image you have permission to use, particularly if the workbook will be shared or published.
- Enough worksheet space to position the image. If the picture needs to stay aligned with particular data, decide which cells it should sit over before inserting it.
You can also use images from Excel’s built-in stock library if that option is available in your version. If you are using Excel for the web, keep the image accessible from your device or an available cloud location. The exact picture choices can differ slightly by platform and update.
Step-by-Step
- Open the workbook and choose a worksheet. Select the sheet where the image belongs. If it is meant to illustrate a table or a particular record, scroll to that area first. You do not need to select a cell to insert a picture, but selecting the nearby cell can help you keep your place. If you are working with important data, save the workbook before making layout changes.
- Open the picture insertion menu. On Windows, select the Insert tab on the ribbon, then choose Pictures. Select This Device to browse for a file stored on your computer. Depending on your Excel build, the Pictures menu may also show options such as Stock Images or Online Pictures. Choose the source you intend to use; the remaining steps apply to a local image.
- Choose the image file. In the file picker, browse to the folder containing the picture. Select the file and check its name before continuing, especially if the folder contains several similarly named images. Click Insert. Excel adds the image to the sheet, usually as a floating object above the cells rather than as content inside a cell.
- Move the image to the right place. Click the picture once so that its selection handles appear. Point to the picture itself, not a handle, then drag it to the desired area. For more precise placement, use the keyboard arrow keys to nudge a selected picture; in some configurations, holding Alt while dragging can help align the edges with cell boundaries. If the image covers a value or heading, move it rather than deleting or editing the underlying cell.
- Resize it without distorting it. Select the picture and drag a corner handle inward or outward. Corner handles preserve the image’s proportions in typical Excel layouts, while dragging a side handle can stretch it. If the picture looks squashed, use a corner handle or undo the last change with Ctrl+Z on Windows. On a Mac, use Command+Z. You can also open the Picture Format tab and enter dimensions in the Size controls when you need a specific height or width.
- Crop the image if needed. Cropping removes unwanted edges without changing the original file. Select the picture, choose Picture Format > Crop, and drag the black crop handles to frame the part you want to show. Click Crop again or click outside the picture to finish. Cropping is useful for removing empty margins or focusing on one part of a photo; it does not improve a low-resolution image.
- Choose whether it should move with cells. By default, a picture floats over the worksheet. It may remain in place when rows or columns change, depending on its placement settings. To make it move or resize along with cells, right-click the picture and choose Format Picture. In the pane, open Size & Properties, then Properties, and select the appropriate option, such as Move and size with cells. If you want the image to stay independent of cell changes, choose the option to move but not size with cells, or the option not to move or size with cells.
- Consider placing it inside a cell. Some Microsoft 365 versions offer a Place in Cell option in the Insert > Pictures menu. If you see it, use it when the image should behave more like cell content and stay associated with a row or column as you sort or resize the table. The option is not displayed in every Excel version or on every platform. If it is unavailable, insert the image normally and adjust its properties to suit your sheet.
- Check the result and save. Click a blank cell to see the worksheet without selection handles. Check that the image does not hide important labels or numbers, and verify its position after changing the relevant row or column size. Save with Ctrl+S on Windows or Command+S on a Mac. If you share the workbook, reopen it or check the shared copy to confirm the picture is still visible.
On a Mac: The ribbon names are similar, but the picture source command may appear as Insert > Pictures > Picture from File. Select the file and insert it, then resize and position it using the picture handles and contextual formatting controls. On Excel for the web, use the Insert tab and its picture option; the available sources and placement controls can vary. If a named option is missing, use the closest available local-device picture command.
Common Mistakes
- Dragging a side handle and stretching the picture. This changes its proportions and can make people or objects look unnaturally wide or narrow. Resize from a corner instead, then crop if you need to adjust the framing.
- Assuming the image is inside the selected cell. A normal inserted picture usually sits over cells. Selecting a cell before insertion does not necessarily anchor the image to that cell. Set the picture’s cell properties or use Place in Cell if your version offers it.
- Placing the image over important data. A floating image can conceal values without deleting them. Move it to an empty area, make room by adjusting the layout, or resize it. Check the cells underneath before sharing the sheet.
- Using an image that is too small or too large. Enlarging a small image can make it blurry, while a very large image can make the file slower to open or share. Start with a reasonably sized source image and crop or resize it in Excel as needed.
- Expecting cropping to edit the original file. Excel changes how the picture appears in the worksheet; it does not replace the original image in its folder. Keep the source file if you may need to make a different crop later.
- Forgetting to save or check a shared copy. A picture may appear correctly on your computer but not in a copy that was exported, copied, or shared incorrectly. Save the workbook in an Excel format such as .xlsx and verify the file you plan to send.
Tips
- Prepare a clear image before inserting it. Crop unnecessary borders in an image editor if they make the subject hard to position, and use a file with enough resolution for its final display size. A transparent PNG can work well for a logo that needs to sit over a colored worksheet background.
- Keep pictures consistent in a report. Use similar sizes and align edges with the relevant cells. The ribbon’s alignment and size controls can help when several pictures need to look uniform. Select one picture at a time unless you deliberately want to format multiple selected objects together.
- Make space in the worksheet before adding a large image. Decide whether the image should sit beside the data, above it, or on a separate sheet. Widening a column or increasing row height can help, but remember that those changes affect the other cells in the same row or column.
- Use meaningful alternative text when accessibility matters. Right-click the picture and choose View Alt Text or the available alt-text command. Describe the information the image conveys, not just its appearance. For a decorative image that adds no useful information, mark it decorative if that choice is available.
- Think about file size when adding many pictures. A workbook containing numerous large photos can become slow to save, open, or email. Use appropriately sized images rather than inserting full-resolution originals when they will only be displayed as small thumbnails.
- Keep a clean source copy. If you crop, compress, or reposition an image in Excel, retain the original file separately. That makes it easier to use a different crop, replace the picture, or create a version for another document later.
Troubleshooting
The Pictures command or file option is missing. Confirm that you are on the Insert tab and that the workbook is not in a restricted editing state. If you are using Excel for the web or a managed work account, some sources may be unavailable. Try This Device or the platform’s local-file option, and make sure you have permission to edit the workbook. If the ribbon is simplified, expand it or look for the Pictures command within the Insert controls.
The image will not move or resize. Click the image rather than the cell behind it and check for selection handles. If the worksheet is protected, editing objects may be restricted; ask the workbook owner to allow object editing or unprotect the sheet if you are authorized. If you cannot select the picture because another object overlaps it, use the Selection Pane if available, or temporarily move the obstructing object.
The picture disappears, shifts, or changes size after editing rows. Open Format Picture > Size & Properties > Properties and review whether the picture should move or resize with cells. Choose a setting that matches the worksheet’s purpose. For a picture that should stay with a record, cell-based placement or move-and-size behavior is usually more suitable than a completely fixed position. Test by changing a nearby row height, then undo the test if necessary.
The image looks blurry or distorted. If it is distorted, resize it from a corner handle rather than a side. If it is blurry, use a larger or sharper original; increasing the size of a low-resolution image cannot restore detail. If only a small portion is needed, crop around the subject instead of enlarging the whole image excessively.
The image is hidden behind cells or another picture. Pictures are objects layered over the worksheet. Select the picture and use the picture-format ordering controls, such as Bring Forward or Send Backward, to change its position in the layer stack. If you cannot find it, use the Selection Pane where available to identify and select objects by name.
The workbook becomes unusually large or slow. Replace oversized images with appropriately sized versions, remove pictures that are no longer needed, and save the workbook. If your Excel version provides picture compression, select an image and look for Picture Format > Compress Pictures. Options can differ by version, so check the dialog before applying compression; lower resolution may reduce image quality.
Frequently Asked Questions
Can I insert a picture into a specific Excel cell?
Yes, if your Microsoft 365 version provides Place in Cell, choose that option when inserting the picture. Otherwise, Excel inserts it as an object over the grid. You can align it with a cell and set its properties, but that is not identical to placing it inside the cell.
How do I insert an image from the internet?
Use Insert > Pictures and select Online Pictures if your Excel version offers it. You may also download an image you are allowed to use and insert it with This Device. Available online sources can depend on your Excel build and account.
Will the picture move when I sort or filter a table?
A floating picture may not stay with the correct record when rows are sorted or filtered. Use Place in Cell where available for images associated with table records. Otherwise, review the picture’s properties and test the sort on a copy of the data before relying on the layout.
Can I put more than one image in a worksheet?
Yes. Repeat the insertion steps for each image, then arrange them so they do not cover important cells. If the sheet contains many pictures, consider consistent dimensions and placement, and watch the workbook’s file size.
How do I delete an image without deleting cell data?
Click the picture until its selection handles appear, then press Delete. Check that the picture itself is selected before pressing the key; if a cell is selected instead, Delete may clear cell contents rather than remove the image.
Can I add a picture in Excel for the web or on a Mac?
Yes. Excel for the web and Excel for Mac support inserting pictures, although the menu labels, sources, and placement options may differ from Windows. On a Mac, look for Insert > Pictures > Picture from File; in the web app, use the picture option on the Insert tab.
Related
- Insert a Checkbox in Word: Shortcut and Options
- Insert a Blank Checkbox in Word: Printable or Clickable
- Google Sheets INDEX MATCH Formula: How to Use It Right
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Make a Monthly Budget in Google Sheets Step by StepTo make a monthly budget in Google Sheets, create separate income and expense tables, enter planned and actual…
- Conditional Formatting Excel Dates Overdue: How to Set It UpTo highlight overdue dates in Excel, select the cells to format and create a formula-based conditional formatting rule.…
- Excel Format Painter Shortcut: Keyboard and Ribbon OptionsIn Excel for Microsoft 365 on Windows, use the ribbon key sequence Alt, H, F, P to activate…
- How to Add a Watermark in Word Online (and What Works)Word for the web can display a watermark that is already in a document, but it generally cannot…
- How to Create a Style Template in Word and Reuse ItTo create a reusable style template in Word, format the document’s styles, then save the file as a…
- Embed a Google Drive Video in PowerPoint: What WorksYou can put a Google Drive video in a PowerPoint presentation, but PowerPoint does not natively play a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.