Excel Image Function

Posted on:  10/04/2022
Excel Image Function

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. 

Excel IMAGE function

Excel IMAGE function

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?

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

Excel - IF Function using AND and OR

Excel - IF Function using AND and OR

Microsoft Word to Adobe Acrobat with Bookmarks

Microsoft Word to Adobe Acrobat with Bookmarks

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

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

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

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

Microsoft Teams - Create and Customize Avatars

Microsoft Teams - Create and Customize Avatars

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

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

OneDrive sync icons explained

OneDrive sync icons explained

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

Categories