sodcalculator

10 Tech How-To

How to Insert Pictures in Excel: Step-by-Step

Guide 10-55602 · Updated · Step by step

Inserting pictures into Excel lets you add logos, product photos, diagrams, or screenshots directly into your spreadsheet, making reports and dashboards more visual. You can place images as floating objects or embed them within cells, and Excel gives you tools to resize, crop, and position them precisely. Here’s everything you need to know to insert and manage images in Excel (versions 2016, 2019, 2021, and Microsoft 365).

What You’ll Need

  • A computer with Microsoft Excel installed (desktop version recommended; steps differ slightly in Excel for the web).
  • The image file you want to insert (common formats: PNG, JPG, GIF, BMP, SVG).
  • If you plan to insert a screenshot, you need the application or window you want to capture open.

Step-by-Step

  1. Open your Excel workbook and navigate to the worksheet where you want the image. Click on the cell near where you want the image to appear (the image will float above the grid, not be locked to a cell unless you use the “Place in Cell” feature).
  2. Go to the Insert tab on the ribbon. It’s between “Home” and “Page Layout” in most versions.
  3. Click the “Pictures” button (in the Illustrations group). A dropdown menu appears with options like “This Device,” “Stock Images,” and “Online Pictures.” Choose the source that matches where your image is stored.
  4. Select your image file in the file picker dialog. You can select multiple images by holding Ctrl while clicking. Then click “Insert.” The image(s) will appear on the worksheet, usually centered near the selected cell.
  5. Move and resize the image as needed. Click the image to select it. Drag the corner handles to resize proportionally (hold Shift to maintain aspect ratio). Drag the image by its center to reposition it on the sheet.
  6. To embed the image inside a cell (so it moves and filters with data), use the “Place in Cell” feature: select the cell, go to Insert > Pictures > Place in Cell > This Device, and choose your image. This is available in Microsoft 365 (Excel for Windows and Mac) and Excel for the web. The image will be contained within the cell and adjust if the cell is resized.
  7. To insert a screenshot (of a window or part of your screen), go to Insert > Screenshot. Choose a window from the available list, or select “Screen Clipping” to drag and select a region of your screen. The captured image will be inserted immediately.
  8. Format the image using the Picture Format tab that appears when the image is selected. You can apply borders, shadows, artistic effects, or crop the image using the “Crop” button.
  9. To insert multiple images at once, select all files in the file picker (Ctrl+click) and click Insert. Excel will place them all on the sheet, often overlapping; you can arrange them later.
  10. To insert an image into a header or footer (e.g., a logo that appears on every printed page), go to Insert > Header & Footer, then click in the header section and use the “Picture” button in the Header & Footer Elements group. This is useful for branding printed reports.
  11. To insert an image as a background (watermark style), go to Page Layout > Background and select an image. Note that this only displays on screen, not when printed.

Common Mistakes

  • Images not moving with cells: By default, images are “floating” and don’t move when you sort or filter data. If you need them to stay with a row, use “Place in Cell” or set the image’s properties to “Move and size with cells.” To do this, right-click the image, choose “Format Picture,” go to the “Properties” tab, and select “Move and size with cells.”
  • Distorted images: Resizing by dragging the side handles (instead of corners) stretches the image. Always use corner handles and hold Shift to keep proportions.
  • Huge file size: Inserting many high-resolution photos can make the Excel file very large. Compress images before inserting or use Excel’s “Compress Pictures” feature (select image > Picture Format > Compress Pictures).
  • Images covering data: Floating images can obscure cells. Use the “Selection Pane” (Home > Find & Select > Selection Pane) to reorder or hide images, or move them to unused areas.
  • Using “Online Pictures” with no internet: This option requires an internet connection. If offline, use “This Device” instead.

Tips

  • Use “Place in Cell” for data-bound images: If you’re creating a product list or employee directory, embedding images in cells keeps them aligned with rows and allows sorting/filtering without losing the image.
  • Align images with the grid: Hold the Alt key while dragging an image to snap its edges to cell borders. This helps create a tidy layout.
  • Group multiple images: Select multiple images (Ctrl+click), then right-click and choose “Group” to move or resize them as one unit.
  • Use the Selection Pane: If you have many images, the Selection Pane (Home > Find & Select > Selection Pane) lets you rename, hide, or reorder them, making management much easier.
  • Link to an external image: Instead of embedding, you can insert a linked picture (Insert > Pictures > This Device, then click the drop-down arrow next to Insert and choose “Link to File”). This keeps the Excel file smaller, but the image will break if the source file is moved.
  • Add alt text: Right-click the image > Edit Alt Text to describe it. This improves accessibility and helps screen readers.

Troubleshooting

  • Image appears as a red X or broken icon: This usually means the image file is corrupt or the link is broken. Delete the image and re-insert it from the original file.
  • Image is too large and pushes content: Resize the image immediately after inserting. If it’s covering other data, move it to a blank area first, then resize.
  • “Place in Cell” option is grayed out: This feature requires a Microsoft 365 subscription and an updated version of Excel. If you have an older version, use the classic floating image method instead.
  • Cannot select an image because it’s behind a shape or chart: Use the Selection Pane (Home > Find & Select > Selection Pane) to bring the image to the front (click the eye icon to hide others, or use the up arrow).
  • Image is not printing: Check that the image is not set to “Print object” off. Right-click the image > Format Picture > Properties and ensure “Print object” is checked. Also, if you used a background image, it won’t print by design.
  • Excel crashes when inserting a large image: Reduce the image resolution using an external tool or take a smaller screenshot. Then re-insert.

Frequently Asked Questions

Can I insert multiple images at once in Excel?
Yes. In the file picker, hold Ctrl and click all the images you want, then click Insert. They will all appear on the sheet, and you can move them individually.

How do I make an image stay inside a specific cell?
Use the “Place in Cell” feature (Insert > Pictures > Place in Cell > This Device) in Microsoft 365. If you don’t have that, you can set the image properties to “Move and size with cells” (right-click > Format Picture > Properties) so it moves when the cell moves, but it won’t be clipped to the cell boundaries.

Why can’t I insert a picture from the web?
The “Online Pictures” option requires an internet connection and may be blocked by your network or organization. Try downloading the image to your computer first, then use “This Device.”

How do I remove a background from an image in Excel?
Select the image, go to Picture Format > Remove Background. Use the tools to mark areas to keep or remove, then click “Keep Changes.” This works best on images with solid backgrounds.

Can I insert a PDF or other document as an image?
No, Excel only accepts image file formats (PNG, JPG, GIF, BMP, SVG, etc.). To insert a PDF, you can convert it to an image or insert it as an object (Insert > Object > Create from File), but that embeds the PDF as an icon, not as a picture.

How do I insert a picture into a comment or note?
Right-click the cell, choose “New Comment” (or “New Note”), then in the comment box, right-click the border and select “Format Comment.” Go to the “Colors and Lines” tab, click the drop-down next to “Color,” choose “Fill Effects,” then the “Picture” tab, and select your image.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →