how to insert picture in excel

Inserting pictures in Excel is straightforward using built-in tools, and recent updates like the IMAGE function make it even easier for cell-specific placement. This guide covers the main methods for Excel versions up to 2026, including tips for fitting images precisely.

Basic Insertion

Start by clicking Insert > Pictures on the ribbon to add images from your device, stock sources, or online.
Select your file (hold Ctrl for multiples), then click Insert —the picture appears over the sheet near your cursor.

Drag to position; right-click for Size and Properties to resize without distortion.

Picture in Cell

Excel images typically "float," but lock them to cells for sorting/filtering.
Right-click the image > Format Picture > Properties > Move and size with cells.

Resize to fit (merge cells if needed via Home > Merge & Center); now it behaves like cell content.

Pro Tip : For bulk insertion, use Ablebits Tools (add-in) under Utilities > Insert Picture to auto-fit rows/columns.

IMAGE Function (Microsoft 365)

Upload images to a public HTTPS URL (JPG, PNG, etc.), then enter =IMAGE("https://example.com/image.jpg") in a cell.
Customize with arguments: =IMAGE(source, "alt text", 1, 200, 300) (1=Fit to cell; set height/width).

Images sort/filter dynamically—ideal for inventories or dashboards.

Method| Best For| Pros| Cons
---|---|---|---
Insert > Pictures 1| General use| Easy, multiple files| Floats by default
IMAGE Function 9| Dynamic sheets| Sorts with data, online sources| Requires M365, public URLs
Format Properties 1| Locked fit| Stays with cells| Manual resize

Headers/Footers

Go to Insert > Header & Footer, click a section, then Picture to embed.

The &[Picture] code appears; exit to view—great for reports as of Feb 2026 standards.

Advanced Tricks

• Bulk from folder : Copy-paste or VBA for automation (e.g., loop via cell links).

• Notes/Comments : Right-click cell > New Note > Insert image (Excel 365).

• Troubleshoot : If images won't embed, check file format or update Excel—2025 patches fixed WEBP support.

TL;DR : Use Insert > Pictures for basics or =IMAGE() for cells; lock via properties.

Information gathered from public forums or data available on the internet and portrayed here.