Want to add images directly into Excel cells? The IMAGE function makes it simple. This guide shows you how to insert, customize, and manage pictures in your spreadsheets using formulas – whether they’re from the web or your local files.

Insert Your First Image Using the IMAGE Function

The IMAGE function brings pictures into your Excel cells through a straightforward formula. Here’s what you need to know before you start:

Basic syntax:

=IMAGE(source)

Supported formats:

• PNG (recommended for quality and transparency)
• JPG/JPEG (ideal for photographs)
• GIF (supports animation, but use with caution)
• SVG (vector graphics)

Add Images from Web URLs

Let’s start with adding images from the internet:

1. Open your spreadsheet and select the cell where you want the image
2. Type the formula beginning with =IMAGE(

1. Add your URL in quotes
2. Close the parenthesis and press Enter

Example:

Formula	Description
=IMAGE(“https://example.com/photo.jpg“)	Basic image insertion
=IMAGE(“https://example.com/logo.png“, 2)	Image with fit mode

Tips for web images:

• Always use complete URLs including ‘https://’
• Test the URL in a browser first to ensure it works
• Check if the image requires authentication
• Verify the image loads correctly in Excel

Insert Local File Images

Working with images stored on your computer? Here’s how:

1. Locate your image file and its full path
2. Format the file path correctly in your formula
3. Use backward slashes in the file path
4. Enclose the path in quotes

Example:

Formula	Description
=IMAGE(“C:\Images\photo.jpg”)	Local file basic
=IMAGE(“\server\shared\logo.png”)	Network drive

Customize Image Display in Cells

Control how your images appear with these parameters:

Parameter	Value	Result

[fit]

1

Fit to cell

[fit]

2

Stretch to fill

[fit]

3

Original size

[fit]

4

Maintain ratio

Example usage:

=IMAGE(“source”, 2, TRUE, “Alt text”)

Format Images with Alternative Text

Make your spreadsheets accessible:

1. Add descriptive alt text as the fourth parameter
2. Keep descriptions clear and concise
3. Include relevant details about the image
4. Avoid redundant phrases like “image of” or “picture of”

Example:

Formula	Alt Text Example
=IMAGE(“logo.png”,1,TRUE,”Company logo in blue”)	Good
=IMAGE(“photo.jpg”,1,TRUE,”Team photo from 2025 conference”)	Better

Working with IMAGE Function Results

Once you’ve added images, here’s how to manage them:

1. /Move Images
   • Select the cell
   • Use standard Excel /paste
   • Formulas transfer automatically
2. Sort and Filter
   • Images move with their row
   • Formulas stay intact
   • References update automatically
3. Excel Tables
   • Convert range to table
   • Images become part of dataset
   • Maintain dynamic references

Create Dynamic Image References

Make your images responsive to data changes:

1. Use cell references:

=IMAGE(A1)

Next Steps

Start small. Try adding a single image first. Then experiment with different formatting options. Build your way up to more complex applications.

Ready to take your Excel data management beyond images? Try Coefficient to connect your spreadsheets directly to your business systems for real-time data syncing.