How to insert image into Google Sheets cell

To add an image to Google Sheets, navigate to Menu -> Insert -> Image -> Upload your Image. However, note that the image will not be added to a specific cell.

To insert an image into a cell, use the formula/syntax: IMAGE(url, [mode], [height], [width]). The parameters mode, height, and width are optional.

url: Provide the URL of the image, which must be accessible via the HTTP protocol. For example:

Example:

mode: This is an optional field used to resize the image's aspect ratio; the default value is set to 1.

1: This mode will resize the image to fit inside the cell while maintaining the aspect ratio.

2: This mode will stretch or compress the image to fit inside the cell, ignoring the aspect ratio.

3: This mode will leave the image at its original size, which may result in cropping.

4: This mode allows you to set a custom size for the image (by specifying custom width and height).

Note: This is an optional field; the mode must be set to 4 if custom width and height are used.

height: You can specify the height of the image in pixels.

Note: Height is an optional field; if used, the mode must be set to 4.

width: You can specify the width of the image in pixels.

Note: Width is an optional field; if used, the mode must be set to 4.