The simplest way to insert a photo

Open the spreadsheet where you want the photo to appear. Click the cell where you want the image to land, or click anywhere on the sheet if you don't need it tied to a specific cell. Then go to the Insert menu at the top of the screen.

In the Insert menu, look for a button labeled Pictures or Image — the exact wording depends on whether you're using Excel on Windows, Mac, or the web version. Click it, and your computer will open a file browser. Navigate to the photo on your device, select it, and click Open. The photo will appear on your spreadsheet.

The image lands as a floating object, meaning it sits on top of the cells rather than inside one. You can drag it anywhere, resize it by pulling the corners, or delete it by clicking it once and pressing Delete.

Key Takeaways

  • Photos in Excel are inserted through the Insert menu and appear as floating objects that sit on top of cells rather than inside them.
  • You can resize a photo by clicking it and dragging the corner handles, and move it by clicking and dragging the image itself.
  • Excel accepts common photo formats including JPG, PNG, GIF, and BMP files from your computer or OneDrive.
  • If you want a photo to stay with a specific row when you sort or filter data, anchor it to that cell using the right-click menu.

Resizing and positioning your photo

Once the photo is on your sheet, click it once to select it. You'll see small squares appear at the corners and edges — these are the resize handles. Drag a corner handle to make the photo larger or smaller while keeping its proportions. Drag an edge handle if you want to stretch it in only one direction, though this can distort the image.

To move the photo, click anywhere on the image itself (not on a handle) and drag it to a new location. If you want to position it precisely, right-click the photo and look for an option like Position and Size or Format Picture. This opens a dialog where you can enter exact measurements.

Anchoring a photo to a cell so it moves with your data

By default, a photo stays in the same spot on the sheet even if you add or delete rows above it. If you want the photo to move along with a specific row — for example, a product photo that should always stay next to that product's information — you need to anchor it.

Right-click the photo and look for Move and Size or Format Picture. In the dialog that opens, find the option that says something like Move and size with cells or Don't move or size with cells. Select the option to move with cells. Now if you insert a row above the photo, the photo moves down with it.

Inserting photos from OneDrive or the web

If you're using Excel online or Excel on a newer version of Windows, you can insert photos directly from OneDrive without downloading them first. Click Insert, then Pictures, and you'll see an option for OneDrive or Browse web. Select the photo from your cloud storage and it will be inserted the same way as a photo from your computer.

Some versions of Excel also let you insert a photo by pasting a web address directly. This is less common and may not work in all versions, so the file browser method is more reliable if you're unsure.

Removing backgrounds and adjusting photo appearance

Excel includes basic photo editing tools. Click the photo to select it, then look for a Picture Format or Format tab that appears at the top of the screen. From here you can adjust brightness, contrast, and saturation. Some versions also include a Remove Background button that automatically cuts away the background of a photo — useful if you want just the subject without the surroundings.

These tools are limited compared to dedicated photo editors, but they're enough for quick adjustments. If you need serious editing, it's faster to edit the photo in another program first, then insert the finished version into Excel.

Copying and pasting photos directly into Excel

You don't always need to use the Insert menu. If you have a photo open in another program — a web browser, photo viewer, or image editor — you can copy it and paste it directly into Excel. Right-click the photo in the other program, select Copy, then click your Excel sheet and press Ctrl+V (Windows) or Command+V (Mac). The photo will appear on your sheet.

This method is faster if you're working with multiple photos, but the photo still becomes a floating object that you'll need to position and resize the same way as an inserted image.

What file types Excel accepts

Excel works with the most common photo formats: JPG, PNG, GIF, BMP, and TIFF. If you have a photo in a less common format and Excel won't accept it, open the photo in any image viewer or editor, save it as a JPG or PNG, and then insert that version instead. This takes less than a minute and solves the problem.

There's no practical limit to how many photos you can add to a single sheet, but keep in mind that large photos or many photos at once will make your file bigger and slower to open. If you're storing the file on a shared drive or sending it by email, this matters more.

Frequently Asked Questions

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

Excel doesn't support photos truly inside cells the way some other programs do. Photos are always floating objects. However, you can make a cell very tall and position a photo directly over it so it appears to be inside. For a cleaner look, anchor the photo to that cell so they move together.

Why does my photo look blurry after I insert it?

This usually happens when you stretch a small photo to a large size. Excel enlarges the pixels, which makes the image look fuzzy. Start with a higher-resolution photo if possible, or resize it smaller rather than larger. If the photo is already low quality, editing it in a dedicated photo program before inserting it won't help.

How do I make sure a photo prints when I print the spreadsheet?

Photos print by default as long as they're on the sheet. Before printing, go to File > Print Preview to see how the photo will look on the page. If it's cut off, you may need to resize it or adjust the print area. Make sure your printer settings include images — some printers have an option to skip images to save ink.

Can I lock a photo so it doesn't get moved or deleted by accident?

Excel doesn't have a direct lock feature for individual photos, but you can protect the entire sheet. Go to Review > Protect Sheet and set a password. This prevents anyone from moving, resizing, or deleting objects on that sheet without the password. Be aware that this also locks cells, so you may need to unlock specific cells first if you want people to edit data.

What's the best way to organize photos if I have dozens of them?

If you're building a catalog or inventory sheet with many photos, put one photo per row and anchor each to its row. This way, if you sort the data, the photos move with the correct items. Keep photos roughly the same size so the sheet looks organized. Consider using a separate sheet just for photos if your main sheet is already crowded with data.