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

Enable FIPS Mode on SLES 15 and Verify the Boot State

Enable FIPS Mode on SLES 15 and Verify the Boot State

Follow SUSE’s SP7 procedure to enable FIPS mode, reboot safely, verify the active policy, and check whether your compliance requirement calls for validated modules.

Set Up a LUKS-Encrypted Data Volume on SLES

Set Up a LUKS-Encrypted Data Volume on SLES

Compare YaST and cryptsetup for a new encrypted SLES data volume, choose LUKS1 or LUKS2, and verify unlock and mount behavior safely.

Build a Custom AppArmor Profile on SUSE Linux

Build a Custom AppArmor Profile on SUSE Linux

Create, refine, and verify a least-privilege AppArmor profile on SLES 15 SP7, with a clear note on SLES 16’s SELinux default.

Build a Local SUSE Update Server with RMT on SLES 15

Build a Local SUSE Update Server with RMT on SLES 15

Set up RMT on SLES 15, mirror entitled repositories, and verify HTTPS registration and package access from a test client.

Join SLES 15 to Active Directory with SSSD in YaST

Join SLES 15 to Active Directory with SSSD in YaST

Connect SLES 15 to AD with YaST’s SSSD-based logon management, then verify directory lookup, domain login, and Kerberos tickets.

Enable SLES Live Patching and Verify a Kernel Fix

Enable SLES Live Patching and Verify a Kernel Fix

Set up the right Live Patching path for SLES 16.0 or 15 SP7, apply eligible kernel fixes, and confirm what is active without confusing it with a reboot-required kernel update.

Install and Sign Custom Kernel Modules on SLES 15 Secure Boot

Install and Sign Custom Kernel Modules on SLES 15 Secure Boot

Load a custom SLES 15 kernel module without disabling Secure Boot. Match the running kernel, sign the .ko file, enroll a MOK key, and verify loading.

Keep Services Available During a SLES 15 SP5 to SP6 Upgrade

Keep Services Available During a SLES 15 SP5 to SP6 Upgrade

SLES 15 SP5 can migrate online to SP6, but each node must reboot. Use a tested rolling upgrade or blue-green cutover to keep workloads reachable.

Apply the SLES 15 STIG Safely with OpenSCAP

Apply the SLES 15 STIG Safely with OpenSCAP

Use SUSE’s supported STIG profile to scan SLES 15, test remediation, review remaining findings, and retain assessment evidence.

Restore Cockpit Access to SUSE Linux Enterprise Server

Restore Cockpit Access to SUSE Linux Enterprise Server

Trace a failed Cockpit connection through DNS, port 9090, the systemd socket, firewalld, TLS, and login settings using current SUSE guidance.