How to use Image function in Google Sheet

The Image function in Google Sheets is used to insert images online, meaning you can immediately use existing image links - URLs without having to download images and then upload them like we usually do. How to use the Image function in the Google Sheets office application is quite simple. You can completely adjust the display size of the image through the index parameters entered by the user in the formula that the Image function adds. Below Download.vn will guide you in detail how to insert images using the Image function with URL.

   

How to use the Image function in Google Sheets

Image function formula: =IMAGE(URL; [mode]; [height]; [width])

In there:

  • URL: is the image path.
  • Mode: is the size adjustment mode for images with values ​​1, 2, 3, 4.
  • Height: height size.
  • Width: horizontal size.

The Mode parameter in the Image function has the following meaning:

  • =image(“URL to image”,1) – image resizes itself to fit the cell.
  • =image(“URL to image”,2) – image expands to fill the box.
  • =image(“URL to image”,3) – image retains its original size.
  • =image(“URL to image”,4) – image with custom size.

Example illustrating inserting images by URL with the Image function

Open the Google Sheets spreadsheet in your browser and log in to your Google account.

Accordingly, with images with URL: https://s.dowload.vn/data/image/2020/06/11/LOGO-MO.png we do the following:

=image("https://s.dowload.vn/data/image/2020/06/11/LOGO-MO.png";1)

How to use Image function in Google Sheet

The image resizes itself to fit the cell

=image("https://s.dowload.vn/data/image/2020/06/11/LOGO-MO.png";2)

How to use Image function in Google Sheet

The image expands to fill the box

=image("https://s.dowload.vn/data/image/2020/06/11/LOGO-MO.png";3)

How to use Image function in Google Sheet

The photo retains its original size

=image("https://s.dowload.vn/data/image/2020/06/11/LOGO-MO.png";4;400;700) - The image is fixed to a specific size of width 400 , length 700

How to use Image function in Google Sheet

Photo with custom size

Leave a Comment

How to Add Font to Canva

How to Add Font to Canva

Learn exactly how to add font to Canva with this step-by-step guide. Upload custom fonts through Brand Kit to use them across all your designs in minutes.

How to Use Skype

How to Use Skype

How to Use Skype for free video calls, messaging, and screen sharing. Follow this complete guide to install the app, set up your account, and start communicating in minutes.

How to Clear Google History

How to Clear Google History

Learn how to clear Google history quickly to protect your privacy. This step-by-step guide shows you how to delete search activity from your Google account on any device.

How to Delete History on Chromebook

How to Delete History on Chromebook

Learn exactly how to delete history on Chromebook to protect your privacy. Follow these precise steps to clear browsing data, cookies, and cached files on your device.

How to Find a Server on Discord

How to Find a Server on Discord

Learn how to find a server on Discord with this clear walkthrough of the built-in Discovery tool and other reliable methods. Join active communities fast.

How to Change Search Engine in Chrome

How to Change Search Engine in Chrome

How to Change Search Engine in Chrome takes just a few clicks in Settings. Switch your default provider to Google, Bing, DuckDuckGo or another option and improve search results instantly.

How to Cast Netflix to Chromecast

How to Cast Netflix to Chromecast

Learn exactly how to cast Netflix to Chromecast from your phone or computer. Follow these steps to stream movies and shows to your TV in minutes.

How to Set Google as Your Homepage on Chrome

How to Set Google as Your Homepage on Chrome

Learn exactly how to set Google as your homepage on Chrome in under a minute. Follow the precise steps in Chrome Settings to make google.com load when you click the home button.

How to Add Pictures to Canva

How to Add Pictures to Canva

Learn how to add pictures to Canva in just a few clicks. This guide shows the fastest ways to upload your own photos or use Canva's library for any design project.

How to Create a QR Code in Canva

How to Create a QR Code in Canva

How to create a QR code in Canva is simple with the built-in generator. Follow these exact steps to add a working, customizable QR code to any design in under two minutes.