Excel Image Function

Posted on: 10/04/2022

The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images.

IMAGE Function syntax

=IMAGE(source, [alt_text], [sizing], [height], [width])

IMAGE Function Arguments

[Required] source is the URL path of the image file, using an “https” protocol. (NOTE: Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP.)
[Optional] alt_text is the alternative text that describes the image (for accessibility).
[Optional] sizing specifies the image dimensions. There are several possible values:
- 0: Fit the image in the cell and maintain its aspect ratio.
- 1: Fill the cell with the image and ignore its aspect ratio.
- 2: Maintain the original image size, which may exceed the cell boundary.
- 3: Customize the image size by using the height and width
[Optional] height and width define the height and width of the image only when using sizing 3 option.

Latest Articles

Excel PivotTable - Table VS. Range as source - Which is better?

In Excel, a PivotTable can be based on a Range or on a Table. I encourage you to base your PivotTable on a Table. Initially, both a range and table will be correct.

Excel - IF Function using AND and OR

One of my favorite functions is the IF function. The IF function allows you to use true and false conditions. For example, if the value in cell B2 is over $5,000, give them a 2% discount.

Microsoft Word to Adobe Acrobat with Bookmarks

We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

EA Ignite Fall 2023 - San Antonio TX - Chris Menard - Two Sessions

Chris Menard will present two sessions at EA Ignite in November 2023. Menard's sessions are Microsoft's AI Tools: How Technology Works for You and Microsoft Teams 2.0: What's New and What it Means for You

Microsoft Teams - Create and Customize Avatars

Microsoft Teams is rolling out mesh (3D) Avatars. You can customize your avatar. Avatars are not static. When testing, my avatar reacted to audio and moved from time to time to provide some visual interest.

April 19-21, 2023 - EA Ignite Conference at Marriott Waterfront in Baltimore MD

I will present at the EA Ignite Conference in Baltimore, MD, on April 19 to 21, 2023. The annual spring conference is held at the Baltimore Marriott Waterfront hotel. My two sessions are Mastering Microsoft OneDrive and Analyzing Financial Data in MS Excel.

OneDrive sync icons explained

OneDrive is great for syncing your files. OneDrive has a great feature called Files on Demand. Your files on your computer could have three possible status icons with Files on Demand running.

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube