The basic steps to insert an image

To add a picture to an Excel spreadsheet, go to the Insert tab at the top of the ribbon, then click Pictures. You'll see two options: This Device (to upload a file from your computer) or Stock Images (to search Excel's built-in library). Choose the image you want, click it, and then click Insert. The image will appear in your spreadsheet, and you can drag it to reposition it or resize it by pulling the corners.

The image lands on top of your cells rather than inside them, which means it floats over your data. You can move it anywhere on the sheet, and it won't affect the cells underneath. If you want to keep the image in a specific place while you scroll or edit, you can right-click the image, select Format Picture, go to the Properties tab, and check Move and size with cells — this anchors it to a particular cell so it moves when that cell moves.

Key Takeaways

  • Pictures in Excel float on top of cells rather than inside them, so they won't overwrite your data when you add them.
  • Use the Insert tab and click Pictures to upload from your computer or choose from Excel's stock image library.
  • You can resize an image by dragging its corners and move it anywhere on the sheet by clicking and dragging.
  • Right-click an image and select Format Picture to anchor it to a specific cell so it moves with that cell when you edit.
  • Images increase file size, so use them sparingly if you share your spreadsheet by email or need to keep the file small.

Resizing and positioning images the right way

When you first insert an image, it usually appears at a default size that may be too large or too small for your needs. To resize it, click the image once to select it — you'll see small squares (called handles) at the corners and edges. Drag a corner handle to resize the image while keeping its proportions correct. If you drag an edge handle instead, you'll stretch or squash the image, which usually looks wrong.

To move the image, click anywhere in the middle of it and drag it to a new location. If you want to position it precisely — for example, to align it with a specific column or row — you can right-click the image, select Format Picture, go to the Properties tab, and enter exact measurements for where you want it to sit. This is useful when you're creating a professional report or invoice where alignment matters.

Anchoring images so they stay in place

By default, images are not anchored to cells, which means they stay in the same spot on the screen even if you insert or delete rows and columns. If you want an image to move along with a specific cell — for instance, a product photo that should always appear next to its description — you need to anchor it.

Right-click the image and select Format Picture. In the panel that opens, click the Properties tab. Under Move and size with cells, check the box. Now the image is anchored to the cell it's closest to, and it will move if you insert or delete rows above it. If you later want to unanchor it, uncheck that same box.

Reducing file size when you use images

Images make spreadsheet files larger, which can slow down saving and sharing. If you're emailing the file or storing it on a cloud service with limited space, you may want to compress the images. Right-click an image and select Compress Pictures. A dialog box will appear with options to reduce the resolution — choose a lower resolution if the image is just for on-screen viewing, or keep it higher if you plan to print the spreadsheet.

You can also crop an image to remove parts you don't need. Right-click the image, select Crop, and drag the edges inward to remove unwanted areas. This reduces both the visual size and the file size. If you have many images in one spreadsheet, compressing them can cut the file size by 50 percent or more.

Layering images and text

When you have multiple images or images overlapping with text, you may need to control which one appears on top. Right-click an image and look for Arrange options (the exact menu name varies by Excel version). You'll see choices like Bring to Front, Send to Back, and Bring Forward. Use these to layer images in the order you want.

You can also wrap text around an image so that text doesn't disappear behind it. Right-click the image, select Wrap Text, and choose an option like Square or Tight. This tells Excel to flow text around the image rather than letting the image cover it up. Note that text wrapping works best when the image is anchored to a cell.

Copying and pasting images between sheets

If you want to use the same image in multiple places — on different sheets in the same workbook or in a different spreadsheet — you can copy and paste it. Click the image to select it, press Ctrl+C (or Cmd+C on Mac), navigate to the sheet or file where you want it, and press Ctrl+V (or Cmd+V). The image will appear in the same position relative to the top-left corner of the sheet.

If you want to paste it in a different position, click where you want it to go first, then paste. You can also copy an image from another program — a web browser, Word document, or photo editor — and paste it directly into Excel using the same keyboard shortcuts. This is faster than saving the image to your computer and then inserting it through the Insert menu.

Frequently Asked Questions

Can I put a picture inside a cell instead of floating it on top?

No — Excel images always float on top of cells. However, you can anchor an image to a cell so it moves with that cell when you edit the sheet. Right-click the image, select Format Picture, go to Properties, and check Move and size with cells.

What image file types does Excel accept?

Excel accepts most common formats: JPG, PNG, GIF, BMP, TIFF, and SVG. If you have an image in a different format, you can convert it using free online tools or photo editing software before inserting it into Excel.

Why is my spreadsheet file suddenly much larger after I added images?

Images add significant file size. Right-click each image, select Compress Pictures, and choose a lower resolution. If you have many images, this can reduce your file size by half or more. You can also crop images to remove unnecessary parts.

Can I edit an image after I insert it into Excel?

Excel has basic editing tools — you can crop, compress, and adjust brightness and contrast by right-clicking the image. For major edits like removing backgrounds or adding text, use photo editing software first, then insert the finished image into Excel.

What happens to images if I share my spreadsheet with someone else?

Images stay in the spreadsheet when you share it, as long as you send the actual Excel file. If you convert the file to PDF or another format, the images go with it. If someone opens the file on a different computer, the images appear in the same positions, though the file may look slightly different depending on screen size and resolution.