The basic way to add a picture to your spreadsheet

To add a picture to an Excel spreadsheet, go to the Insert tab at the top of the window, then click Pictures. A dialog box opens showing your computer's files. Find the image file you want — it can be a photo, screenshot, chart, or any image saved on your device — select it, and click Insert. The picture appears in your spreadsheet, usually larger than you need it.

The picture lands on top of your cells rather than inside them, which means it floats over your data. You can move it by clicking and dragging, and you can resize it by grabbing the small squares at its corners and edges. Dragging a corner square keeps the image proportions correct; dragging an edge square stretches it out of shape.

Once the picture is placed, you can delete it by clicking it once to select it, then pressing the Delete key. If you want to undo the insertion, press Ctrl+Z (or Cmd+Z on a Mac) when ready after inserting.

Key Takeaways

  • Pictures in Excel float on top of cells rather than fitting inside them, so they cover whatever data sits underneath.
  • Use the Insert tab and Pictures button to browse your computer for image files, then position the picture by dragging it where you need it.
  • Resize by dragging the corner handles to keep proportions correct, or edge handles if you need to stretch the image deliberately.
  • Right-click a picture to access options like cropping, adjusting brightness, or wrapping text around it.

Moving and resizing pictures so they fit your layout

After you insert a picture, it usually lands in the upper left area of your spreadsheet and takes up more space than you want. Click the picture once to select it — you will see small squares appear around its edges and corners. These squares are handles you use to resize.

To move the picture, click anywhere on the image itself (not on a handle) and drag it to a new location. The picture will slide across your spreadsheet and you can position it over any cells you choose. To resize while keeping the image proportions correct, grab one of the corner handles and drag it inward to make the picture smaller or outward to make it larger. If you grab an edge handle instead of a corner, you can stretch the image taller, wider, or narrower — this distorts the picture but is sometimes what you need.

If you want the picture to stay in one place even when you scroll or add rows, right-click the picture and look for an option called Move and Size or Properties. This opens a panel where you can lock the picture's position to specific cells.

Cropping and adjusting picture appearance

Once a picture is in your spreadsheet, you may want to remove parts of it or change how it looks. Right-click the picture to see a menu of options. Look for Crop — this lets you cut away the edges of the image without deleting it. Click Crop and handles appear around the picture; drag these inward to remove the parts you do not want to see, then click outside the picture or press Enter to finish.

The same right-click menu usually shows options to adjust brightness, contrast, or color. These changes affect only how the picture appears in your spreadsheet — they do not change the original image file on your computer. If you make a change you do not like, right-click again and look for Reset Picture to undo all adjustments at once.

You can also rotate a picture by right-clicking and selecting Rotate, or by using the rotation handle — a small circle that appears above the picture when it is selected. Drag this circle to spin the image to any angle you want.

Arranging multiple pictures and controlling what they cover

If you add more than one picture to your spreadsheet, they can overlap or cover important data. When pictures overlap, the one you inserted most recently sits on top. To change the order, right-click a picture and look for options like Bring Forward or Send Backward. These move the picture up or down in the stack so you can see the one you want on top.

You can also control how pictures interact with text and cells. Right-click a picture and look for Wrap Text or Text Wrapping. This option has several choices: In Line with Text makes the picture behave like a character in a cell, so it moves when you add or delete rows; Square lets text wrap around the picture's rectangular boundary; Tight wraps text closer to the picture's actual shape. Most of the time, Square is the easiest to work with.

If you want a picture to stay attached to a specific cell so it moves when you insert or delete rows, use In Line with Text. This is useful when the picture is part of your data — for example, a photo next to a product name in an inventory list.

Inserting pictures from online sources

You do not have to use only pictures saved on your computer. Excel can also insert pictures directly from the internet. Go to the Insert tab and click Pictures, but this time look for an option called Online Pictures or From Web (the exact wording depends on your version of Excel). A search box appears where you can type what you are looking for — "mountain landscape" or "company logo" — and Excel shows you results you can insert directly.

When you insert a picture from the web, Excel downloads a copy and stores it in your spreadsheet file. The original image on the internet does not change, and you can use the picture even if you later lose your internet connection. Be aware that some images online are protected by copyright, so only use pictures you have permission to use or that are marked as free to use.

Saving your spreadsheet with pictures included

When you save an Excel file that contains pictures, the images are saved inside the file itself. This means the file size grows — a spreadsheet with several large photos can become quite large. If you email the file or share it with others, they will see all the pictures you added, in the same positions and sizes.

If you want to reduce file size, you can compress the pictures. Right-click a picture and look for Compress Pictures. A dialog appears with options to reduce the image quality and resolution. Lower quality means smaller file size but less detail in the picture. For most spreadsheet uses, the default compression settings work fine.

If you delete a picture from your spreadsheet, the file size does not shrink automatically. To truly reduce the file size after removing pictures, save the file with a new name — this forces Excel to write only the data and images that are actually there.

Troubleshooting common picture problems

Sometimes a picture does not appear where you expect it. If you insert a picture and cannot see it, it may have landed outside the visible area of your spreadsheet. Press Ctrl+Home (or Cmd+Home on a Mac) to jump to the top-left corner, then look for the picture there. If it is still not visible, the picture may be behind other content. Right-click in the area where you think it is and select Bring Forward to move it on top.

If a picture looks blurry or pixelated after you resize it, you may have stretched it too large. Pictures have a maximum size where they still look sharp — if you make them much bigger than their original size, they lose detail. The solution is to use a higher-resolution version of the image if you have one, or to accept the lower quality if the picture is just decorative.

If you cannot find the Pictures button on the Insert tab, your version of Excel may be older or configured differently. Look for a button labeled Image or Insert Image instead. The process works the same way.

Frequently Asked Questions

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

Yes, but it requires an extra step. Insert the picture normally, then right-click it and choose Wrap Text or Text Wrapping, and select In Line with Text. The picture becomes part of the cell and moves with it when you add or delete rows. The cell height adjusts automatically to fit the picture.

What image file types does Excel accept?

Excel accepts most common image formats: JPG, PNG, GIF, BMP, and TIFF. If you have an image in a different format, you can usually convert it using free online tools or image editing software. The most common formats — JPG and PNG — work without any problems.

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

Right-click the picture and look for Format Picture or Picture Format. In the panel that opens, find the transparency or opacity slider and adjust it. Moving the slider toward transparent makes the picture fade so you can see what is underneath. This is useful for watermarks or background images.

Can I link a picture to a cell so it updates automatically?

Excel does not have a built-in way to link a picture to a cell value. However, you can use a workaround: insert the picture, then use a formula in a nearby cell to reference data, and position the picture next to that cell. If the data changes, the picture stays in place but the cell value updates.

What happens to pictures if I share the spreadsheet with someone else?

Pictures are saved inside the Excel file, so when you share the file, the other person sees all the pictures in the same positions and sizes. They can move, resize, or delete the pictures just as you can. If you want to prevent them from changing the pictures, you can protect the sheet, though this requires a password.