Using the Google Sheets Image in Cell Option + 2 Easy Tips

Watch Video – Insert an Image in Google Sheets

When working with data and collaborating with other people in Google Sheets, you may sometimes need to insert an image in a cell in Google Sheets.

These could be company logos or product images, etc.

You will be quite surprised to know that Google Sheets makes it really easy to add images in a cell quite easily.

In this tutorial, I will show you a couple of methods you can use to insert images in Google Sheets.

Insert an Image Using the Google Sheets Image in Cell option

Alongside the formula, Google Sheets insert image in cell is the simplest option.

This option is available in the Insert option on the menu.

Below are the steps to insert a spreadsheet image in a cell:

  1. Select the cell in which you want to insert the image in a cell in Google Sheets
  2. Click the Insert option in the menuClick the Insert tab
  3. Hover the cursor over the Image option
  4. Click on the ‘Image in cell’ optionClick on the option - Image in Cell
  5. In the Insert Image dialog box, select the option through which you want to insert the image. You can upload an image, take a snapshot and insert that, use a URL to insert the image, use your albums/Google Drive to insert the image or search and then insert it. In this example, I will use the URL to insert the imageSelect By URL option in Insert Image dialog box
  6. Enter the image URL from which you want to insert the image in the cellEnter the URL from which you want to insert the image
  7. Click on Select.Click on the Select button

The above steps would insert the specified image in the selected cell.

Note that the image inserted using this method is placed in the cell and it moves and sizes with the cell. Also, if you hide the cell or filter it, the image would stick to the cell and would also get hidden/filtered.

There is also an option to insert an image over the cells. This will place the image as an object over the cells and you would have to manually fit it within a cell by sizing and moving it. Also, when you place an image over the cells, it won’t move and size with the cell. This means that if you move the row/column or hide it, the image will not follow suit.

How to Add an Image to Google Sheets Using the IMAGE Formula

Yes, there is a formula that you can use to add an image to a cell in Google Sheets.

Through the IMAGE formula, you can easily start the process of adding a picture in their preferred cell.

Syntax of the IMAGE function:

IMAGE (url, [mode], [height], [width])
  • url: The link of the image should be included with an HTTPS or HTTP for it to work. It should also be surrounded by double quotes if you’re entering it as text only. You can even refer to a cell that has the URL of your image already.
  • [mode] The mode is 1 by default, but you can switch it up. It is entirely up to the user to decide the image size which comes in four sizes.
    • Size 1 simply just changes the size of the image to fit in easily inside the cell.
    • Size 2 compresses or stretches your picture so that it can easily fit in the cell.
    • Size 3 will crop the image so that it fits in the cell without changing the size of the image.
    • Size 4 allows the user to choose the size (height/width) of the image.
  • [height]: The height option simply indicates how long the picture should be to stay inside the cell and also be completely visible. If you want to use height, make sure your mode is 4.
  • [width]: To use the width parameter, once again, your mode should be 4; otherwise, your whole image formula will result in an error. The width option lets the user define how wide the picture should be to stay completely visible in the cell.

Now that you know the syntax of the image function, let’s see some examples of how you can use it to insert an image in a cell in Google Sheets.

In this entire tutorial, I will be using the following URL of the logo of Google to show you how to use the IMAGE function in Google Sheets:

https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png

This image URL has been taken from the homepage of Google (source: https://www.google.com/)

Now let’s have a look at some examples.

To insert an image in a cell using the above URL, I can use the below formula in Google Sheets:

=IMAGE("https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png")

The above formula gives the result as shown below:

IMAGE function to insert an image in a cell from a URL

Since I have not provided any of the optional arguments, it will insert the image and fit the image into the cell.

Now let’s go through all the modes you can use in the IMAGE function and how it will impact the result.

When Mode is 1 – Image Resizes to Fit the Cell Size

The result you get when the mode is specified as 1 would be the same you get when you don’t specify any mode value.

In this mode, the image is resized to fit the cell. And if you change the size of the cell, the image would also resize.

IMAGE function - when mod value is 1

When Mode is 2 – Image Stretches to Fit the cell

When you specify the mode as 2, the image would stretch (in height as well as width) to fit the cell (as shown below).

In this case, the aspect ratio is not maintained and you may end up getting an image that completely fits the cell.

IMAGE function - when mod value is 2

When Mode is 3 – Image Displayed at Original Size

When you specify the mode as 2, the image would be displayed in its original size.

In case the cell height/width are not large enough to accommodate the image, the image would be cropped. And in case the size of the cell is larger than the image size, you will have empty white spaces in the cell (around the image).

IMAGE function - when mod value is 3

When Mode is 4 – Displays the image with the specified Height/Width

When you specify the mode as 4, you also need to specify the height and width of the image in the cell (in pixels). For example, the below formula will insert the Google logo in a cell and make the size as 50 as height and 50 as width.

=IMAGE("https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png",4,50,50)

IMAGE function - when mod value is 4

Benefits of using the IMAGE function

There are a couple of benefits of using the IMAGE function over inserting the image using the ‘Image in Cell’ functionality:

  1. The IMAGE function allows a lot more flexibility as compared with the ‘Image in cell’ option. You can choose from four different modes that allow you to choose whether you want the image to fit perfectly or stretch and fill the cell or remain at a specific height and width.
  2. IMAGE function can take a cell reference as the input (where the cell reference has the URL to the image). This makes it dynamic – which means that if you change the URL in the reference cell, the image would automatically update. Also, if you have 10 image URLs in a column, you can easily use the IMAGE function to get the images quickly for all the 10 image links.

How to Insert Picture in Google Sheets With Dynamic Image Lookup Functionality

Since the IMAGE function can easily update when you change the URL of the image, you can use this to create an image lookup (picture lookup) functionality in Google Sheets.

Something as shown below:

Image Lookup Picture Lookup in Google Sheets

In the above example, as soon as I select a company name, the logo of that company automatically updates in the adjacent cell. This is made possible using the IMAGE function (along with the VLOOKUP function).

Below are the steps I have used to create this picture lookup in Google Sheets:

  1. Have the company names and the image links in a sheet in Google Sheets. This could be on the same sheet where you want the picture lookup or could be on a different sheet. In this example, I have these names and logos in a sheet named – ‘Image Links’Name of companies and link to the images in a tablular format
  2. Create a drop-down list in the sheet where you want the picture lookup to work. For this drop-down, use the company names so that these same names appear in the drop-down.Drop down that shows the company names
  3. In the adjacent cell, use the following formula to fetch the URL for the company logo. This fetched URL is used in the IMAGE function to insert the image of that fetched URL. Since this is connected to the drop-down value, when you change the value, the logo also changes: =IMAGE(VLOOKUP(A1,‘Image Links’!$A$2:$B$6,2,0)) IMAGE Lookup formula to fetch the image

This could be useful when you’re creating a dashboard and you want an image to appear based on the selection from the drop-down.

Insert an Image into Google Sheets Cell – FAQ

Can I Insert Image in Spreadsheet Cell?

You can use any of the methods we mentioned to do this.

  • Through the insert menu
  • With the IMAGE formula
  • With dynamic lookup and the IMAGE formula

How Do I Lock an Image in Google Sheets?

You have to use the same method as locking a cell for any other reason. Right-click the cell and use the Protect range option.

How Do I Make an Image a Link in Google Sheets?

  1. Click on the image in the cell, the Image option box should pop up
  2. Click Change link and paste in the URL you want to direct to

How Do I View an Image in a Cell?

To view a full-size image from a cell, you can right-click then select Put image over cells. When you’re done, use the undo shortcut (Ctrl+z) to return it back to the way it was.

Can You Paste Images Into Google Sheets?

Yes but not just by using Ctrl+V. You have to Insert the image instead.

The Bottom Line

Whether you choose to use the Google Sheets image in cell method or the other two we mentioned, you should now easily be able to place images into your spreadsheet with ease. If you found this tutorial helpful,

You may also like the following Google Sheets tutorials:

Sumit

Sumit

Google Sheets and Microsoft Excel Expert.

4 thoughts on “Using the Google Sheets Image in Cell Option + 2 Easy Tips”

  1. Nice. THanks for the info.
    Is there any way to insert the image, and have it automatically display the image, from a google form? Right now the google results sheet page only displays the image link, but not the image itself.

    Reply
  2. I use the Appscript to trigger and its will convert the google sheet to PDF and email to the user straightaway. But the problem is at thecell with contain =image() ,the image turn up only half at PDF from the original at google sheet.

    I believe it cause the image huge in size. How to compress ? or any other ideas?

    Reply

Leave a Comment

Best Online Google Sheets Courses

Become a Google Sheets expert today!
View Course