IMAGE Function in Google Sheets

Display an image within a cell using the IMAGE function.

IMAGE Function

The IMAGE function in Google Sheets is used to display an image within a cell.

Syntax

IMAGE(url, [mode], [height], [width])
  • url: The URL of the image you want to display. This is a required parameter.
  • mode: (Optional) The mode to use for the image: 1 (default), 2, 3, or 4.
  • height: (Optional) The height of the image in pixels (only applicable if mode is 4).
  • width: (Optional) The width of the image in pixels (only applicable if mode is 4).

Example

  1. Insert an Image

Display an image from a URL:

=IMAGE("https://example.com/image.jpg")

This will display the image in the cell.

Notes

  • Mode 1 resizes the image to fit inside the cell, maintaining the aspect ratio.
  • HYPERLINK: Create a clickable link to an image or webpage.