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

How to Remove Duplicates Running Left to Right in Excel Using Power Query

Removing duplicates in Excel is a common task, but it can be challenging when the duplicates are running horizontally (left to right) instead of vertically. In this blog post, we'll explore an advanced Excel technique using Power Query to efficiently remove duplicates across rows. This method is particularly useful when dealing with complex data structures where traditional duplicate removal methods fall short.

Become an Expert at Using the TOCOL Function in Excel to Merge Columns

The TOCOL function in Excel is a powerful tool for combining data from multiple columns into a single column.

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.

4 Great NEW Microsoft Teams Features: November & December 2024

Microsoft has been extremely busy with new Teams features in November and December 2024. Here is a quick overview of What's New - Name Pronunciation, New Chat and Channels Experience, Improved People Search, and the Refreshed View for Teams and Channels.

Teams: Improved People Search - November 2024

Microsoft Teams has rolled out an enhanced people search feature, providing users with more efficient ways to find and filter content related to specific individuals. This update, released in November 2024, offers a streamlined approach to searching for messages, files, and conversations associated with team members. Let's explore how to make the most of this new functionality.

Copilot in OneDrive: Revolutionizing Document Interaction

Copilot in OneDrive is here, and it promises to revolutionize how we interact with documents. With features like summarizing documents, creating FAQs, and asking questions about document content, Copilot offers a powerful toolset for enhancing productivity and efficiency.

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 Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite 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.