How to Insert an Image in an Excel Sheet: Full Guide

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the sheet, choose Insert > Pictures > This Device, pick an image, and select Insert. Drag the picture to position it and use a corner handle to resize it. If you want the image to belong inside a cell rather than float over the worksheet, use Insert > Pictures > Place in Cell when that option is available.

These methods work for product photos, logos, diagrams, signatures, and other visuals. Before inserting, decide whether the picture should move and resize with worksheet cells or stay as a separate object; that choice affects how it behaves when you sort, filter, or change row heights.

What You’ll Need

  • An Excel workbook that you can edit in Microsoft Excel. The steps below are for Microsoft 365 on Windows.
  • An image file saved somewhere you can access, such as a PNG or JPG. A clear image with a suitable aspect ratio will be easier to fit into your worksheet.
  • A rough idea of where the picture should go and how large it needs to be. If the image is for a table, decide whether it should sit in a cell or above the cells.

Keep in mind that adding a picture can increase the workbook file size, especially if the source image is large. If you received the workbook in read-only mode or protected view, you may need permission to edit it before you can insert anything.

Step-by-Step

  1. Open the workbook and choose a location. Go to the worksheet where you want the image. Click a cell near the upper-left corner of the intended position. A regular picture is a floating object layered over the grid, so selecting a cell gives Excel a useful starting point but does not place the picture inside that cell. If the image is meant to illustrate a particular row, select a cell in that row before inserting.

  2. Open the picture insertion command. On the Windows ribbon, select Insert > Pictures > This Device. In the file picker, browse to the image, select it, and click Insert. You can select more than one file in the picker if you want to add several pictures at once, but inserting them individually usually makes it easier to position and size each one accurately.

    Excel may also offer Stock Images or Online Pictures in the Pictures menu. Those choices are useful when you want to select an image from the available library or online sources instead of using a file already saved on your computer. The options shown can vary with your Excel version and account.

  3. Position the picture on the worksheet. Excel places a selected picture over the grid. Move the pointer onto the picture until it changes to a move pointer, then drag the picture to the desired spot. Avoid dragging a small square handle, because those handles resize the image rather than move it. For a picture aligned with a table, use the row and column borders as guides.

  4. Resize without distorting the image. Click the picture so that its sizing handles appear. Drag a corner handle inward to make it smaller or outward to make it larger; corner resizing preserves the image’s proportions. Dragging a middle handle on an edge can stretch or squash the picture. For precise dimensions, select the picture and use the Picture Format tab’s Size controls to enter a height or width.

  5. Crop the picture if it needs to fit a space. Select the image, then choose Picture Format > Crop. Drag the black crop handles to hide unwanted edges, and click outside the picture or press Enter to apply the crop. Cropping hides parts of the image rather than changing its original proportions. If you crop too much, choose Crop again and drag the edges back outward.

  6. Choose how a floating picture relates to cells. Right-click the picture and choose Format Picture. In the Format Picture pane, open Size & Properties, then Properties. Choose Move and size with cells if the picture should follow row or column changes and resize with them; choose Move but don’t size with cells if it should follow cell positions but retain its dimensions; or choose Don’t move or size with cells to keep it independent of grid changes. The exact pane layout can differ slightly by update.

  7. Use a picture in a cell when the image is data for a row. In Excel for Microsoft 365, select Insert > Pictures > Place in Cell > This Device, then choose the file and insert it. The image is contained in the selected cell rather than floating across several cells. It is often a better choice for product lists or staff directories because the picture stays associated with its row when the table is sorted. If you do not see Place in Cell, use the regular This Device option or check whether your Excel version has the feature.

  8. Check the result and save. Confirm the image is in the correct worksheet, is not covering labels or values, and is legible at the worksheet’s usual zoom. Save the workbook. If you are sharing it, consider reopening the saved file to check that the picture is still present and positioned as intended.

Mac and web differences: In Excel for Mac, use the Insert tab and the Picture command, then choose the option to insert a picture from a file; labels can vary between Mac releases. Excel for the web also has picture insertion through the Insert tab, but its menus and formatting controls may differ from the Windows desktop steps. If the cell-placement option is missing, insert a regular picture and set its behavior using the available picture-formatting controls.

Common Mistakes

  • Dragging an edge handle to resize. This can distort a logo or photo. Use a corner handle to preserve the original proportions.
  • Assuming a picture is inside the selected cell. A normal inserted picture floats over worksheet cells, even when you clicked a cell first. Use Place in Cell if you need the image stored in a cell.
  • Leaving the picture in the wrong row after sorting. Floating images may not follow the data as expected. Set the picture’s cell properties appropriately, or use a picture in a cell for row-based images.
  • Inserting a very large source image. A high-resolution photo can make the workbook slow to open or share. Resize or compress a copy of the image before inserting if the original is much larger than its display size.
  • Covering useful worksheet content. An image can obscure cells even though it does not replace their values. Move it into an empty area, adjust its size, or place it in a cell.
  • Confusing crop with resize. Resizing changes the displayed dimensions; cropping hides part of the picture. Use the one that matches the result you want.

Tips

  • Use the correct image format. PNG is often a good option for logos or graphics that need a transparent background, while JPG is commonly used for photographs. Check the result in Excel, especially if transparency or fine detail matters.
  • Align pictures neatly. Zoom in if necessary, then use the worksheet grid and cell borders to line up images. In Windows Excel, holding Alt while moving or resizing a floating object can help it snap to cell boundaries.
  • Keep a consistent size. For a catalog or directory, make images approximately the same displayed height and place them in a dedicated column. This makes the sheet easier to scan.
  • Use descriptive alternative text when appropriate. Right-click the picture and look for View Alt Text or the alternative-text option in the picture formatting controls. Add a short description that explains the image’s purpose, especially when the workbook will be shared.
  • Use a copy of the source image. If you need to crop or alter a picture for the worksheet, keeping the original file untouched makes it easier to make a different version later.
  • Consider worksheet layout before adding many images. Widen the image column or adjust row heights first. A consistent grid is easier to maintain than a worksheet full of pictures placed wherever there was room.

Troubleshooting

The picture does not appear after you select it. Confirm that you clicked Insert in the file picker, not just the file name. Check whether the picture was inserted on a different worksheet or is positioned beyond the visible area. Use the Name Box to return to the area where you selected a cell before inserting, then look around that location.

The image looks stretched or squashed. Undo the last resize with Ctrl+Z on Windows or Command+Z on Mac, then resize using a corner handle. If the picture was cropped, select it and use Picture Format > Crop to adjust the crop area. A source image with a different shape from its intended space may need cropping rather than stretching.

The image moves or resizes when rows or columns change. Right-click the floating image, open Format Picture, and check Size & Properties > Properties. Choose the option that matches how it should respond to cell changes. If it must stay tied to a record when sorting, consider using a picture in a cell where available.

The file picker cannot find the image or Excel will not insert it. Make sure the file is stored locally or in a location you can access, and confirm that it is an image format Excel recognizes. If the image is in a cloud folder, wait for it to download or save a copy to your computer first. Try opening the image in another app; if it will not open there either, the file may be damaged.

The workbook becomes slow or unusually large. Replace oversized images with smaller copies that are closer to their displayed dimensions. You can also use Excel’s picture compression options if available in your version: select a picture and look for Picture Format > Compress Pictures. Review the available choices before applying compression, since reducing resolution can affect image quality.

The picture is hidden behind another object. Select any visible part of it, if possible, and use the Picture Format tab’s arrange controls to bring it forward. If you cannot select it on the sheet, open the Selection Pane from the Home tab’s Find & Select menu and select the picture there; the exact menu availability can vary by version.

Frequently Asked Questions

How do I insert a picture into a specific Excel cell?
For a picture stored in the cell, use Insert > Pictures > Place in Cell > This Device in a Microsoft 365 version that includes the feature. A regular inserted picture only floats over the cell grid.

Can I insert more than one image at a time?
Yes. In the file picker, select multiple image files before clicking Insert. Excel will add them to the worksheet as pictures; check their positions and sizes individually afterward. The exact placement can depend on the version and the insertion method.

Will my picture move when I sort the worksheet?
It depends on whether it is a floating picture or a picture in a cell, and on the object’s properties. For images that belong to individual records, use Place in Cell when available. Otherwise, set the floating picture’s cell properties and test the sort on a copy of the sheet.

Can I use a picture as a worksheet background?
Excel has a separate sheet-background feature in desktop versions. It displays an image behind worksheet cells and is not the same as inserting a movable picture; it may also be intended for on-screen viewing rather than printing. For a logo or illustration that should print, insert it as a regular picture instead.

How do I delete an inserted image?
Click the image’s border so the picture itself is selected, then press Delete. If it is difficult to select because it overlaps other content, use the Selection Pane to choose its object entry and delete it.

Why does the image make my workbook larger?
Excel stores picture data in the workbook, so large or numerous images can increase file size. Use appropriately sized source files and, if needed, the Compress Pictures command. Keep an uncompressed original separately if image quality must be preserved.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.