There are multiple methods with the help of which one can insert an image in a Cell. In this article, let’s discuss Layman’s method as well as the Image function method to insert an image in the Google Sheets. Along with this, we will also discuss Google Sheet tips on how to replace, resize and move an inserted image. Read on to find more.

Table of Contents

How to Add an Image to a Google Spreadsheet? (Layman’s Method)

Follow the steps as listed below to add an image to the Google Sheets:

  • Step 1: Open the Google Spreadsheet where you would like to insert an image.
  • Step 2: Move to the cell where you would like to insert an image.
  • Step 3: Now move to the menubar and click on the “Insert” tab.

insert-image-cell-google-sheets

  • Step 4: Place your image in the cell or on top of the cells by clicking the provided important. Cells having an image cannot also have text in them, and the reverse is likewise true.
  • Step 5: Choose the image from your device.

insert-image-cell-google-sheets

  • Step 6: Click on “Open” and “Select“. The image will be inserted into the device.

insert-image-cell-google-sheets

Using Function to Add an Image – Syntax

We can also add an image to the required cell in Google Sheets by using the Image function. The syntax for adding the Image function is explained below:

IMAGE(url, [mode], [height], [width])

There are two optional arguments: URL and Mode.

  • URL: The URL specifies the URL of the picture to be entered in the cell. In this case, there are four numbers that can be used:
  • Mode: This method reduces the size of the image such that it will fit in the cell while keeping its aspect ratio.
    • Mode [1] Size to Fit: 1 maintains the aspect ratio while resizing the image to fit inside the cell. If you leave the mode argument blank, it defaults to 1.
    • Mode [2] Stretch to Fit: 2 ignores aspect ratio and extends or compresses the image to fit inside the cell.
    • Mode [3] Original Size: 3 keeps the image at its original dimensions, which may result in cropping.
    • Mode [4] Custom Size: Custom size can be specified in version 4.
  • Height – If the mode parameter is set to 4, you can use this argument to indicate the image’s height in pixels.
  • Width – If the mode parameter is 4, this argument can be used to indicate the image’s width in pixels.

How to Add an Image using Image Function?

Follow the steps listed below to add the images using the image function.

  • Step 1: Open the Google Spreadsheet where you would like to insert an image.
  • Step 2: Then move to the cell where you would like to insert an image. Make sure you are having the URL of the image which needs to be pasted.
  • Step 3: Now enter the formula =”IMAGE(url, [mode], [height], [width])“. In our case the formula is =IMAGE(“https://www.google.com/logos/doodles/2016/first-day-of-school-2016-5187470943584256-hp2x.jpg”,1″).
  • Step 4: Press the “Enter” button. You will see the results.
  • Step 5: Now to change the Mod of the image, use different types of modes as mentioned above in the syntax.

insert-image-cell-google-sheets

How to Move an Image on Google Sheets?

The steps to move an image on Google Sheets are explained below:

  • Use cut and paste to move an image from one cell to another.
  • Click and drag an image that is over the cells to move it.
  • To move an image from within a cell to outside of the cells, right-click the image and select Put Image over cells.
  • To move an image from above the cells to inside a cell, do the following:
    • Click in the cell where you want the image to go.
    • Click the image, then More → and finally Place the image in the selected cell.

How to Add Alternative Text and Description to an Image?

Follow the steps as listed below to add the Alternative text and description to an Image in the Google Sheets:

  • Step 1: Open the Google Spreadsheet where you would like to insert the Alt text and Description for an image.
  • Step 2: Now Right-click on the Image. Then select Alt text from the drop-down menu.
  • Step 3: Then add the Alternative text.

insert-image-cell-google-sheets

You can also right-click the image and select the More option to add an alternative text to the image.

Leave a Reply

Your email address will not be published. Required fields are marked *