Excel IMAGE function
The IMAGE function in Excel is designed to insert pictures into cells from a URL. The following file formats are supported: BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP.
The function takes a total of 5 arguments, of which only the first one is required.
Where:
Source (required) - the URL path to the image file that uses the "https" protocol. Can be supplied in the form of a text string enclosed in double quotes or as a reference to the cell containing the URL.
Alt_text (optional) - the alternative text describing the picture.
Sizing (optional) - defines the image dimensions. Can be one of these values:
- 0 (default) - fit the picture in the cell maintaining its aspect ratio.
- 1 - fill the cell with the image ignoring its aspect ratio.
- 2 - keep the original image size, even if it goes beyond the cell boundary.
- 3 - set the image's height and width.
Height (optional) - the image height in pixels.
Width (optional) - the image width in pixels.