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 - Turn on Multiple Filters in a PivotTable

Excel - Turn on Multiple Filters in a PivotTable

PivotTables - 3 Annoying Things FIXED!

PivotTables - 3 Annoying Things FIXED!

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

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

Word - Five Tips for Working with Heading Styles

Word - Five Tips for Working with Heading Styles

Teams Delete Chat

Teams Delete Chat

American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session

American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session

OneDrive - Teams and Outlook folders automatically created in OneDrive

OneDrive - Teams and Outlook folders automatically created in OneDrive

OneDrive - Share a Folder as Read Only | Set Expiration Date and Password

OneDrive - Share a Folder as Read Only | Set Expiration Date and Password

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 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 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