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 AI Checkers Work: Behind the Detection Process

How AI Checkers Work: Behind the Detection Process

As AI writing tools become more advanced, many people want a reliable way to identify machine-written text. This is where an AI checker comes into the picture.

How to Fix Microsoft Edge Cant Read and Write to Data Directory

How to Fix Microsoft Edge Cant Read and Write to Data Directory

Frustrated by Microsoft Edge "Can't Read and Write to Data Directory" error? Get step-by-step fixes, from quick resets to advanced troubleshooting, to restore your browser fast. Works on latest versions!

How to Fix Microsoft Edge Windows Update Catalog Error

How to Fix Microsoft Edge Windows Update Catalog Error

Tired of the frustrating Microsoft Edge "Windows Update Catalog" Error blocking your updates? Discover proven, step-by-step fixes that work on the latest Windows versions. Get back online in minutes!

How to Fix Microsoft Edge OBS Studio Black Screen

How to Fix Microsoft Edge OBS Studio Black Screen

Struggling with Microsoft Edge black screen in OBS Studio? Discover step-by-step fixes for hardware acceleration issues, capture settings, and more. Get your stream crystal clear today!

How to Link Your Microsoft Edge Account to Your Phone

How to Link Your Microsoft Edge Account to Your Phone

Master how to link your Microsoft Edge account to your phone for seamless syncing of tabs, passwords, and bookmarks. Step-by-step guide for Android and iOS with troubleshooting tips.

How to Fix Microsoft Edge System Sounds Missing Fix

How to Fix Microsoft Edge System Sounds Missing Fix

Struggling with Microsoft Edge "System Sounds" missing? Our ultimate guide provides step-by-step fixes to restore notifications, alerts, and browser sounds quickly and easily. Works flawlessly on the latest versions.

How to Fix Microsoft Edge DNS Probe Finished No Internet

How to Fix Microsoft Edge DNS Probe Finished No Internet

Struggling with Microsoft Edge "DNS Probe Finished No Internet" error? Discover step-by-step fixes to restore your browsing instantly. Flush DNS, change servers, and more – no tech skills needed!

Troubleshooting Microsoft Edge Profile is Already in Use

Troubleshooting Microsoft Edge Profile is Already in Use

Tired of the frustrating Microsoft Edge "Profile is Already in Use" error blocking your browsing? Follow our proven, step-by-step troubleshooting fixes to resolve it quickly and regain smooth performance. Works on latest versions!

Troubleshooting Microsoft Edge Stream Deck App Not Opening

Troubleshooting Microsoft Edge Stream Deck App Not Opening

Facing Microsoft Edge "Stream Deck" app not opening? Discover proven troubleshooting steps, quick fixes, and expert tips to resolve crashes, freezes, and launch issues fast. Get back to streaming seamlessly.

How to Fix Microsoft Edge Error 0x8004210b During Update

How to Fix Microsoft Edge Error 0x8004210b During Update

Tired of Microsoft Edge Error 0x8004210b blocking your updates? Follow our expert, step-by-step guide with quick fixes to resolve it fast. No tech skills needed – get Edge running smoothly again!