Sometimes you may want to insert an image into Google Sheets. Show
There are a few different methods to put images inside your spreadsheet. In this tutorial, I will show you how to add images into your cells in Google Sheets. Table of Contents
Inserting an Image with Image in CellThe easiest way to insert an image into a cell in Google Sheets is by using the insert option in the top menu. Heres how to do it 1. The first step is to select the cell where you want the image to appear and then select Insert and Image in the top menu 2. From here you will have two options: Image in cell or Image over cells. Select the one you want. We will choose Image in cell in this example 3. A pop-up box will appear with six options depending on where you want to insert your image from. In this example, I am uploading an image from my computer so I choose Upload 4. Select the blue Browse button to upload a picture from your computer. After you select the button, choose the image from your computer and upload it. 5. The image you have chosen will now be inserted into the cell that you chose in step 1. With the insert image option, you have a few different options for where you take your image from. In the example, I have shown uploading an image from the computer, but there are other options I will cover each of the options below. Insert Image by UploadThis is the option that I showed in the example. By selecting Upload, you can choose any image on your computer to insert into your spreadsheet. Insert Image from CameraIf your computer or device has a camera attached to it, you can take a live picture and insert it into your sheet by choosing the camera option. Insert Image by URLAnother option is to paste an image URL into your sheet by selecting the BY URL option. There will be a text box where you can paste your link. Insert Image from PhotosIf you have images on Google Photos that you want to place inside your spreadsheet you can choose the Photos option and selecting your images there. Insert Image from Google DriveYou can also put images from Google Drive into your spreadsheet by selecting the Google Drive option. From here you will be shown all the images that you have inside your drive and you can select them. Insert Image from Google Image SearchThe last option is to do a google images search to find a picture to place in your spreadsheet. With this option there will be a search bar and you can type in your words to perform the search and choose your photo. IMAGE FunctionAnother great way to place images into your spreadsheet is by using the IMAGE function. The IMAGE function inserts images into a cell. The syntax of this function is:
Here is an example of how this function can be used in your spreadsheet: You can see that the image is inside quotation marks and the image has been resized to fit inside the cell. Remember that by default the IMAGE functioni will be set to mode 1 which resizes the image while maintaining aspect ratio. This is just a basic example where we dont change the size of the image at all. All of the other parameters outside of the first one are optional, but lets take a look at some examples where we using the other parameters to change the image size. Mode 1 ExampleBy default the IMAGE function is set to mode 1, so you dont really need to put this as a parameter in your function. Here is an example of using this function using a cell reference containing the URL: Mode 2 ExampleMode 2 will stretch/compress an image to fit inside a cell without maintaining its aspect ratio. See how in the example below the image is stretched inside the cell: Mode 3 ExampleMode 3 keeps the image at its original size. You can see this is much larger than the previous images because this is the actual size of the original image. Mode 4 ExampleWith mode 4 you can specify exactly how large you want the image by giving the height and width in pixels. Troubleshooting =IMAGE Function Not WorkingThere are a few different reasons that your IMAGE function might not be working properly in your spreadsheet. We will cover a few common reasons here.
Closing ThoughtsAs you can now see, there are many different ways to get images inside your cells in Google Sheets. The IMAGE function is much more dynamic and you have control over the sizing of images that you place inside your sheet. But in some cases using the Insert image option is a good choice too. More Google Sheets Tutorials: |