The fastest way to add an image to Excel

Open the spreadsheet where you want the image. Click the Insert tab at the top of the ribbon. Click Pictures (or Pictures > This Device in Excel 365), then navigate to the image file on your computer and click Open. The image appears in your spreadsheet, usually overlaid on top of the cells rather than inside them.

If you want the image to sit inside a specific cell instead of floating over the spreadsheet, right-click the image after inserting it, select Format Picture, go to the Properties tab, and check Move and size with cells. This anchors the image to that cell so it moves or resizes if you adjust the row height or column width.

You can also insert images directly from your web browser or OneDrive. In the Insert tab, click Pictures > Online Pictures (or Stock Images for free photos), search for what you need, and click Insert. The image downloads and appears in your spreadsheet the same way.

Key Takeaways

  • Images in Excel float over cells by default, but you can anchor them to move with a specific cell using the Properties panel.
  • The Insert tab holds all image options: local files, OneDrive, Bing Image Search, and stock photos.
  • Resize images by dragging the corner handles, and rotate them by dragging the circular arrow that appears when selected.
  • Right-click an image to crop it, remove the background, or explore effects like shadows and reflections without leaving Excel.

Resizing and positioning images where you need them

Once an image is in your spreadsheet, click it to select it. Small squares appear at the corners and edges — these are resize handles. Drag a corner handle to resize the image while keeping its proportions correct. Drag an edge handle to stretch it in one direction only.

To move the image, click and drag it to a new location. If you anchored it to a cell (using Move and size with cells), it will move with that cell when you insert or delete rows and columns. If it is floating freely, it stays in the same visual position on the screen even if you scroll or add rows.

For precise positioning, right-click the image and select Format Picture. Go to the Properties tab and you will see options to lock the image in place or set exact measurements for its position and size in inches or centimeters.

Cropping and editing images without leaving Excel

You do not need to open a separate photo editor to adjust an image. Right-click the image and select Crop. A frame appears around the image with handles you can drag inward to remove unwanted parts. Click outside the image when you are done, and the cropped version stays in your spreadsheet.

Excel also includes a Remove Background tool for images with a clear subject and background. Right-click the image, select Format Picture, go to the Picture tab, and click Remove Background. Excel marks what it thinks is the background in purple. Drag the handles to adjust what gets removed, then click Keep Changes.

For effects like shadows, glows, or reflections, right-click the image, select Format Picture, and go to the Effects tab. You can also adjust brightness, contrast, and color saturation in the Picture tab without needing external software.

Organizing multiple images in a spreadsheet

If you are adding several images to the same sheet, group them so they move together. Hold Shift and click each image you want to group, then right-click and select Group. Now when you move one, all of them move as a unit. You can still ungroup them later by right-clicking and selecting Ungroup.

To layer images on top of each other, right-click an image and look for Arrange options. You can send an image backward or bring it forward in the stack. This is useful when images overlap and you need one to appear in front of the other.

If your spreadsheet has many images, consider putting them on a separate sheet within the same workbook. This keeps your data sheet clean and makes the file easier to navigate. You can link to that sheet from your main data using formulas or hyperlinks.

Inserting images from the web or your phone

Excel 365 lets you search for images without leaving the program. Click Insert > Pictures > Online Pictures, type what you are looking for, and browse results from Bing Image Search. Click an image and select Insert. The image downloads and appears in your spreadsheet.

If you have Excel on your phone or tablet, you can take a photo with your device camera and insert it directly. Open the spreadsheet in Excel mobile, tap Insert > Camera, take the photo, and it appears in your sheet. This is faster than taking a photo, saving it to your device, and uploading it later.

For images stored in OneDrive or SharePoint, click Insert > Pictures > This Device and navigate to your cloud storage. Excel treats cloud images the same way as local files, but they sync across your devices if you edit the spreadsheet on multiple computers.

Saving spreadsheets with images and avoiding file size problems

Images make spreadsheet files larger. If you are sharing the file via email or uploading it to a shared drive with storage limits, compress your images before inserting them. Use an online image compressor or photo editor to reduce file size, then insert the smaller version into Excel.

Excel also has a built-in compression tool. Right-click an image, select Format Picture, go to the Picture tab, and click Compress Pictures. Choose your target resolution — screen resolution (96 ppi) is fine for viewing on a monitor, while print resolution (220 ppi) is better if someone will print the spreadsheet. Excel removes unnecessary data from the image file.

If you insert the same image multiple times, Excel stores it only once in the file, so using the same logo or photo in ten cells does not make the file ten times larger. However, different images or different versions of the same image each add to the file size.

Linking images to cells and using them in formulas

You cannot directly reference an image in a formula the way you reference a cell value, but you can anchor an image to a cell so it moves with that cell's data. Select the image, right-click, choose Format Picture, go to Properties, and check Move and size with cells. Now if you insert a row above that cell, the image moves down with it.

Some users create image galleries by anchoring one image per cell in a column, then using formulas in adjacent cells to pull in descriptions or prices. When you sort the data, the images move with their corresponding rows because they are anchored to those cells.

For more complex layouts, consider using Excel tables with images. Insert a table, anchor images to specific cells within it, and the images will move with the table if you filter or sort the data.

Frequently Asked Questions

Why is my image blurry after I insert it?

The image is likely stretched beyond its original size. Right-click it, select Format Picture, go to Properties, and check the original dimensions. Resize it closer to those dimensions, or start over with a higher-resolution image. Stretching a small image makes it blurry; stretching a large image keeps it sharp.

Can I make an image transparent so I can see cells behind it?

Right-click the image, select Format Picture, go to the Picture tab, and adjust the Transparency slider. Moving it to the right makes the image see-through. This is useful for watermarks or background images that should not hide your data.

How do I delete an image from my spreadsheet?

Click the image to select it and press Delete. If the image is grouped with others, you may need to ungroup it first by right-clicking and selecting Ungroup, then click and delete the individual image.

What image file types does Excel accept?

Excel accepts JPG, PNG, GIF, BMP, TIFF, and SVG files. PNG and SVG are best if you need transparency or crisp graphics. JPG is best for photographs. If you have an image in a different format, convert it using an online tool or photo software before inserting it.

Can I insert a screenshot directly into Excel?

Yes. Click Insert > Screenshots and Excel shows you open windows you can capture, or click Screen Clipping to select a specific area of your screen. The screenshot appears in your spreadsheet as an image you can crop and resize like any other.