How to Insert an Image in Microsoft Excel: Step-by-Step

How-to basics · Updated November 20, 2026

To insert an image in Microsoft Excel for Microsoft 365 on Windows, select the worksheet, open Insert > Pictures, choose an image source, and select the picture to add. Excel usually places it over the cells, where you can resize and move it; if your version offers Place in Cell, you can instead make the picture part of a cell. Have the image file ready if you are adding a picture from your computer.

What You’ll Need

  • An Excel workbook that you can edit. If the workbook is read-only or protected, you may need permission to make changes.
  • An image file on your computer, such as a PNG, JPG, JPEG, GIF, BMP, or TIFF, if you are inserting a local picture. Excel’s supported formats can vary slightly by platform.
  • For an image from an online source, an internet connection and access to the relevant image or service. Use images you have permission to use.
  • A rough idea of where the picture should go and how large it should appear. This helps you choose the right cell or area before inserting it.

Step-by-Step

  1. Open the workbook and choose a worksheet. Open the Excel file, then click the sheet tab where the picture belongs. If you want the image near a particular table or label, click the nearby cell first. You do not have to select a cell for Excel to insert a picture, but choosing one makes the placement easier to manage.
  2. Choose how the picture should sit on the sheet. In Microsoft 365 for Windows, open the Insert tab and select Pictures. Depending on your Excel build, you may see options such as Place in Cell and Place over Cells. Choose Place in Cell if the picture should be contained within a single cell and move or resize with that cell. Choose Place over Cells if it should float above the grid, for example as a logo or a decorative illustration. If those choices are not shown, use Pictures > This Device; the image will normally be inserted as a floating object.
  3. Select the image source. To use a file stored on your computer, choose This Device or From File, depending on the menu shown. Browse to the folder, click the image, and choose Insert. To use an image provided through Excel, choose Stock Images and select an available illustration, icon, or photograph. If Online Pictures is available, you can search or browse there; the exact options depend on your version and connected services.
  4. Check the picture’s location. A picture placed over cells appears on top of the worksheet grid. Drag it to the desired area. A picture placed in a cell appears within the selected cell; if you selected the wrong cell, undo the insertion with Ctrl+Z on Windows and insert it again after selecting the correct one. Take care not to drag a floating picture over data you need to see.
  5. Resize the image without distorting it. Click a floating image to show its selection handles. Drag a corner handle inward or outward to change both height and width proportionally. Dragging a side handle changes only one dimension and can stretch the image. For a precise size, select the picture, open the Picture Format tab, and enter values in the Height and Width boxes in the Size group. The ribbon may show slightly different controls in a narrow window.
  6. Crop the picture if needed. Select the picture and choose Picture Format > Crop. Drag the black crop handles to hide unwanted edges, then click Crop again or click away to apply the crop. Cropping hides parts of the image; it does not make the picture fill a cell automatically. If you need the whole image visible, resize it rather than cropping it.
  7. Set how a floating picture behaves with cells. Right-click the picture and choose Format Picture. In the formatting pane, open Size & Properties, then expand Properties. Select Move and size with cells if the image should follow changes to the row or column dimensions; select Move but don’t size with cells if it should move with the cells but keep its dimensions; select Don’t move or size with cells if it should stay fixed on the sheet. The labels or pane layout can differ between Excel builds. This setting applies to floating pictures, not pictures placed in cells.
  8. Save and check the result. Press Ctrl+S on Windows. If the workbook will be opened in another version of Excel or shared with someone else, check that the image appears in the saved file and that it is still positioned where you expect. Pictures inserted as floating objects can overlap cells, so review the worksheet at its normal zoom level.

On Mac: Excel for Mac also uses the Insert tab and a Pictures command, but menu labels and image-source options can differ. Choose the option to insert a picture from a file, select the image, and use the corner handles to resize. The Windows shortcut Ctrl+Z is Command+Z on Mac; saving is Command+S. In Excel for the web: use Insert > Picture and choose an available source, such as a picture from your device. The browser version may not show all desktop placement, cropping, or formatting controls. If you cannot find a setting, open the workbook in the desktop app.

Common Mistakes

  • Assuming the image is inside a cell. A picture that appears to cover a cell is often a floating object layered over the grid. It may not sort, filter, or move with the cell contents. Choose Place in Cell when available, or check the picture’s properties if it is floating.
  • Dragging a side handle and stretching the picture. This can make a logo or face look unnaturally wide or tall. Resize from a corner, or enter both dimensions in Picture Format while maintaining the proportions.
  • Making the image too large for the sheet. Large pictures can hide values, make navigation awkward, and increase workbook size. Resize the image to the area it needs to occupy and avoid inserting a full-resolution photo when a smaller copy will do.
  • Moving or deleting the wrong object. If several images overlap, click the picture’s visible edge or use Excel’s selection tools to identify it before making changes. Pressing Delete while the picture is selected removes the picture, not the cell contents; check what is selected first.
  • Expecting an inserted picture to update when its source file changes. A normal inserted picture is generally stored in the workbook as an image, not linked so that changes to the original file automatically appear. Replace the picture in Excel if you edit the source file later.
  • Forgetting to check how the image behaves after resizing rows. A floating image may stay put, move, or change size based on its properties. Set the behavior deliberately if the worksheet layout will change.

Tips

  • Use cell placement for records. If each row represents a product, employee, or item, placing each thumbnail in its corresponding cell can make the relationship clearer. Keep the row height and column width consistent so the images are easy to scan.
  • Use floating placement for decoration or layout. A company logo in a report header or a diagram beside instructions may work better as a floating picture. Leave enough room around it so it does not obscure labels, values, or filters.
  • Prepare the image before inserting it. Crop unnecessary background and reduce an oversized image using a trusted image editor if file size matters. Excel can crop pictures, but pre-editing can make it easier to keep a consistent appearance across many images.
  • Align pictures consistently. Use worksheet gridlines as visual guides, and make repeated pictures the same height and width. For several floating images, select one at a time and enter matching dimensions in Picture Format.
  • Consider accessibility. Add useful alternative text when the picture conveys information. Right-click the image and look for View Alt Text or Edit Alt Text, depending on the version. Describe the image’s purpose briefly; decorative images may not need a detailed description.
  • Keep a clean source folder. Give image files recognizable names before inserting them. It is easier to choose the right file when names such as product-blue.png identify the content better than names such as image-final-2.png.

Troubleshooting

The Pictures command is unavailable or greyed out: Check whether the workbook is in a restricted editing state, such as read-only or protected view. Select Enable Editing if the file is trusted, or ask the owner for permission. A protected sheet may also restrict changes. If the file is open in a browser, try opening it in the desktop Excel app.

I cannot find the image file: Confirm the folder and file name, and check whether the file type is supported by your version of Excel. If it is stored in a cloud folder, make sure it is available on your device or accessible through the file picker. Try opening the image separately to confirm that the file itself is not damaged.

The picture covers cells or will not stay aligned: It is probably floating over the grid. Move it by dragging, then open Format Picture > Size & Properties > Properties and choose the cell behavior you need. If your Excel version offers Place in Cell, consider inserting it that way instead. Avoid dragging when the sheet is protected or when you are likely to select a cell underneath the image.

The picture looks stretched, blurry, or cropped: Undo the last change if possible, then resize from a corner handle. Use a larger, clearer original if the image becomes blurry when enlarged. If edges are missing, select Picture Format > Crop and adjust the crop handles; to show the whole picture, reset the crop or insert the original again.

The workbook becomes slow or unusually large: The images may be high-resolution or there may be many of them. Resize copies before inserting, remove unused pictures, and save the workbook again. If the workbook is shared, check whether every picture is necessary and whether recipients can open the file format you are using.

The image disappears after sorting or changing row heights: Check whether it is a floating picture and review its Properties setting. For images that belong to individual records, use Place in Cell if available. A picture that only looks aligned with a row may not actually be attached to that row.

Frequently Asked Questions

How do I insert an image into a specific cell in Excel?
Click the target cell, then use Insert > Pictures > Place in Cell if that option is available in your Microsoft 365 build. Choose the image source and insert the picture. If you do not see Place in Cell, insert the image normally and position it over the cell; it will be a floating object rather than cell content.

Can I insert a picture into Excel from my computer?
Yes. In Excel for Windows, choose Insert > Pictures > This Device or the equivalent file option, browse to the image, and select Insert. On Mac and the web, use the picture insertion command and select a local file if that option is available.

How do I keep an image attached to a cell when I sort?
Use Place in Cell when available, especially for pictures that represent data in individual rows. A floating image can be configured to move with cells, but it may not behave like the cell’s contents during sorting. Test the layout on a copy of the sheet before sorting a large table.

Can I insert more than one picture at a time?
In the file picker, you may be able to select multiple image files by holding Ctrl while clicking each file on Windows, then choose Insert. On Mac, use Command while selecting files. Whether all selected images insert together can depend on the picker and Excel version; if not, insert them one at a time and arrange them afterward.

How do I delete an image without deleting cell data?
Click the image itself until its handles appear, then press Delete. If a cell becomes selected instead, click the image’s border and try again. For a picture in a cell, select the picture or cell and use the available picture-removal command carefully, checking that you do not clear other cell contents.

Does inserting a picture change the original image file?
No. Inserting a picture does not normally edit the source file on your computer. Cropping or resizing in Excel changes how the picture appears in the workbook. Keep the original image if you may need to use it elsewhere at its original size.

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.