Adding a picture to Excel takes three clicks and works the same way in every version

To add a picture to an Excel spreadsheet, go to the Insert tab at the top of the screen, click Pictures, choose This Device, find your image file on your computer, and click Insert. The picture appears in the cell you had selected. You can then drag it to move it, resize it by pulling the corners, or delete it by pressing Delete.

This works the same way whether you use Excel on Windows, Mac, or the free web version at Office.com. The picture becomes part of the spreadsheet file, so it travels with your document when you email it or save it to a shared folder.

Key Takeaways

  • Pictures are inserted through the Insert tab and can be moved or resized after they land in the spreadsheet.
  • You can position a picture over cells, next to data, or anywhere on the sheet without affecting the underlying numbers.
  • Resizing by dragging the corner handles keeps the picture's proportions correct, while dragging the edges alone distorts it.
  • Pictures stay with the file when you save or share it, unlike links to images stored elsewhere.

Where the picture lands and how to move it

When you insert a picture, Excel places it in the upper left corner of whichever cell you had selected. If you had not selected a specific cell, it goes to cell A1. The picture sits on top of the spreadsheet like a sticky note — it does not replace any data underneath it.

To move the picture, click it once to select it (you will see small squares around the edges), then drag it to where you want it. You can place it over cells, between columns, or anywhere else on the sheet. The data in those cells remains unchanged and still calculates normally if they contain formulas.

Resizing without stretching or squashing the image

A picture comes in at whatever size it was originally. To make it larger or smaller, click the picture to select it, then grab one of the small squares at the corners and drag outward to enlarge or inward to shrink. Always use the corner handles — they keep the picture's width and height in the same proportion so it does not look stretched or squashed.

If you drag the squares on the sides or top and bottom instead of the corners, the picture will distort. If that happens, press Ctrl+Z (or Cmd+Z on Mac) to undo and try again with a corner handle.

Keeping pictures in place so they do not move when you edit

By default, if you insert rows or columns near a picture, the picture may shift position. To lock a picture in place so it stays exactly where you put it, right-click the picture and look for Move and Size or Format Picture. In the menu that opens, find the option that says something like Don't move or size with cells and select it.

This is useful when you have a logo or label that should stay in the same spot no matter what changes you make to the data below it. Once locked, the picture will not budge even if you insert or delete rows.

Using pictures with data: logos, product photos, and charts

Pictures work well in spreadsheets when you need to show what something looks like alongside numbers. A product inventory sheet might have a photo of each item in one column and the quantity in another. A budget spreadsheet might have your company logo at the top. A sales report might include before-and-after photos of a project.

If you are trying to add a chart or graph to show trends in your numbers, do not use a picture — use Excel's built-in chart tools instead. Charts update automatically when your data changes, but a picture of a chart does not. Pictures are best for actual photographs, logos, diagrams you created elsewhere, or images that will not change.

Removing a picture or replacing it with a different one

To delete a picture, click it once to select it and press the Delete key. The picture disappears and the spreadsheet underneath is unaffected.

To swap one picture for another without moving it, right-click the picture and choose Change Picture (this option appears in newer versions of Excel). Select the new image file and it replaces the old one in the same spot. If your version of Excel does not have this option, delete the old picture and insert the new one in its place.

Pictures in shared spreadsheets and when sending files

When you save an Excel file that contains pictures, the pictures are stored inside the file itself. This means the file size grows — a spreadsheet with several large photos will be noticeably bigger than one with just numbers. If you email the file or upload it to a shared folder, the pictures go along with it and appear the same way for everyone who opens it.

If someone else edits the spreadsheet and moves or resizes your pictures, those changes will be there when you open it again. There is no way to lock a picture so others cannot move it, but you can always undo their changes or move it back.

Frequently Asked Questions

Can I add a picture from the internet directly into Excel?

Yes. In the Insert tab, click Pictures and choose Online Pictures (or Stock Images in newer versions). You can search for images or paste a web address. The image downloads into your file, so it stays there even if the original website removes it.

Why is my picture blurry after I resize it?

The image was probably small to begin with. Enlarging a small picture makes it look fuzzy because Excel is stretching the same number of pixels across a bigger area. Start with a high-resolution image if you plan to make it large. If you already have a blurry picture, delete it and insert a larger version instead.

How do I make a picture transparent so I can see the cells behind it?

Right-click the picture and choose Format Picture. Look for a transparency or opacity slider and adjust it. At 0% the picture is solid; at 100% it is invisible. This is useful for watermarks or background images, though it can make the picture hard to read.

Can I crop a picture to show only part of it?

Yes. Click the picture to select it, then right-click and choose Crop. Drag the handles inward to remove the parts you do not want, then click outside the picture to finish. The cropped parts are hidden but not deleted, so you can uncrop it later if you change your mind.

What file types can I insert into Excel?

Excel accepts JPG, PNG, GIF, BMP, TIFF, and several other common image formats. If you have a picture in a format Excel does not recognize, open it in a free tool like Paint or an online converter and save it as JPG or PNG first.