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

Removing Duplicates Using Power Query

We're going to take a look at removing duplicates using Power Query in Excel.

The 4 Percent Rule: Using Microsoft Excel to Plan for Retirement

Exploring the 4 percent rule through Microsoft Excel provides a hands-on approach to understanding how it might apply to your retirement planning.

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.

Maximizing Efficiency in Teams Meetings with Copilot: A Comprehensive Guide

Copilot in Teams is designed to enhance your meeting experience by offering real-time assistance and summaries, ensuring you're always in the loop, even if you join late.

NEW Teams - Two New Features - October 2023

Teams see new posts at bottom and pop-out conversations - two new features in Teams 2.0.

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.

March 16, 2023 - 12 Tips to help you master OneDrive

Microsoft OneDrive has tons of benefits. From 1 to 1:45 pm ET on March 16, we will look at versioning, syncing files, working with the sync icons, autosave feature, and co-authoring. OneDrive is integrated with the Microsoft apps. Teams Meetings recordings are stored in OneDrive. We will show how to share meeting recordings, change the expiration date, and view the transcript.

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.