The basic way to add an image to Excel

To add an image 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 pick a file from your computer) or Stock Images (to search for free images built into Excel). Choose This Device, navigate to your image file, select it, and click Insert. The image will appear in your spreadsheet, usually overlapping whatever was already there.

Once the image is in your spreadsheet, you can resize it by dragging the small squares at its corners or edges. Dragging a corner keeps the image's proportions correct; dragging an edge stretches it. To move the image, click and drag it to a new location. The image floats on top of your cells rather than sitting inside one, so it won't move automatically when you add or delete rows.

If you want to remove the image, click it once to select it (you'll see the resize handles appear), then press Delete. The image disappears but your spreadsheet data stays intact.

Key Takeaways

  • Images in Excel float on top of cells rather than living inside them, so they stay in place even if you insert or delete rows below them.
  • Use the Insert tab and Pictures to add images from your computer or choose from Excel's built-in stock images.
  • Resize by dragging corners (to keep proportions) or edges (to stretch), and move images by clicking and dragging them to a new spot.
  • Right-click an image to access options like cropping, adjusting brightness, or wrapping text around it if you need more control over how it sits on the page.

Positioning images so they don't cover your data

When you first insert an image, it usually lands in the middle of your spreadsheet and covers whatever cells are underneath. The fastest way to fix this is to drag it to an empty area — perhaps to the right of your data or below it. If your spreadsheet is packed with data and you have nowhere to move it, you can make the image smaller or place it on a different sheet altogether.

If you want an image to stay anchored to a specific cell (so it moves when you insert or delete rows), right-click the image and look for Move and Size or Properties. In the dialog that opens, you can set the image to move with cells or stay in a fixed position. This matters most when you're building a template that other people will use — if a logo should always stay at the top, anchor it; if it should float independently, leave it unanchored.

Cropping and resizing images to fit your layout

Excel includes a built-in crop tool so you don't have to edit images in a separate program. Click the image to select it, then look for the Crop button in the ribbon under Picture Format (this tab appears only when an image is selected). Click Crop and you'll see black handles around the image's edges. Drag these handles inward to remove parts of the image you don't need, then click elsewhere to explore the crop.

If you need to rotate an image, click it and look for the small circular arrow handle at the top. Drag it to spin the image. For precise rotation angles, right-click the image, choose Rotate or Format Picture, and enter an exact degree value.

Resizing and cropping are different: resizing stretches or shrinks the whole image, while cropping cuts away the edges. Use cropping when you want to remove unwanted parts (like whitespace around a logo), and use resizing to make the image fit your spreadsheet's layout.

Adjusting image brightness, contrast, and color

Excel can adjust how an image looks without opening another program. Select the image, then find the Picture Format tab in the ribbon. Click Corrections to adjust brightness and contrast, or Color to change the color tone (useful if you want to make a photo grayscale or add a tint). These changes happen when ready, and you can undo them by pressing Ctrl+Z if you change your mind.

If you want to make an image semi-transparent so text or cells show through it, right-click the image and choose Format Picture. Look for Transparency and drag the slider to the right. This is useful when you want a watermark-style background image that doesn't completely hide your data.

Inserting images from the web or stock libraries

Instead of uploading an image from your computer, you can search for free images directly in Excel. Go to Insert > Pictures > Stock Images, type a search term (like "chart" or "office"), and browse the results. Click an image to preview it, then click Insert to add it to your spreadsheet. These images are free to use and come from Microsoft's stock library.

If you want to insert an image from a website, you can copy the image URL and use Insert > Pictures > From Web (in newer versions of Excel). Paste the image's web address and Excel will read and insert it. This is faster than saving the image to your computer first, but the image will only display if your computer stays connected to the internet.

Making images part of your spreadsheet layout

Images work best in Excel when they serve a clear purpose: a company logo at the top of a report, a product photo next to inventory numbers, or a chart that you've saved as an image. If you're building a spreadsheet that other people will use, keep images straightforward and position them consistently. A logo in the same spot on every sheet looks professional; images scattered randomly look accidental.

If you're sharing your spreadsheet with others, remember that images increase file size. A spreadsheet with dozens of high-resolution photos will be slow to open and difficult to email. If file size matters, compress your images before inserting them. Right-click an image in Excel, choose Compress Pictures, and select a resolution that matches your needs (screen resolution is usually enough for spreadsheets).

Frequently Asked Questions

Why does my image disappear when I scroll or move cells?

Images in Excel float on top of cells rather than sitting inside them. If your image seems to vanish, it's usually still there but hidden behind other content or outside the visible area. Click Ctrl+A to select all objects, then click your image to find it. If it's truly gone, press Ctrl+Z to undo your last action.

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

Excel doesn't support images inside cells the way some other programs do. Images always float on top of the spreadsheet. If you want an image to move with a specific cell, right-click it and anchor it to that cell, but it will still sit on top rather than inside.

How do I make text wrap around an image?

Right-click the image and look for Wrap Text or Text Wrapping options. Choose Square or Tight to let text flow around the image's edges. This works best when your image is relatively small and positioned near text you want to wrap.

What image formats does Excel accept?

Excel accepts common image formats including JPG, PNG, GIF, BMP, and TIFF. If you have an image in a different format, you can usually open it in a free tool like Paint or an online converter and save it as PNG or JPG before inserting it into Excel.

Can I insert the same image multiple times without adding it over and over?

You have to insert each copy separately, but you can speed this up by copying an image you've already inserted. Click the image, press Ctrl+C, then press Ctrl+V as many times as you need. This is faster than going through the Insert menu each time.