How to Insert Images in a Google Sheets Cell

How to Insert Images in a Google Sheets Cell


How to insert images in a google sheets cell feature image

Inserting images into Google Sheet cells is handy for presenting charts, graphs, and other visual representations of information. To insert an image into Google Sheets cells, here’s what you should do.

Inserting an Image into a Google Sheets Cell

When you want to insert an image into a cell on Google Sheets, moving or resizing it is the option. Another option is to immediately insert an image that resizes to fit the cell size. The challenge is that resizing the image may reduce its quality most time. We will show you how to insert images into a Google Sheets cell and how to resize cells with the steps below:

Step 1: Launch the Google Sheets file to which you need to add the image.

How to insert images in a google sheets cell step 1


How to insert images in a google sheets cell step 1

Step 2: Choose the cell where you need to add the image.

How to insert images in a google sheets cell step 2


How to insert images in a google sheets cell step 2

Step 3: Click on Insert in the menu bar.

How to insert images in a google sheets cell step 3


How to insert images in a google sheets cell step 3

How to insert images in a google sheets cell step 4


How to insert images in a google sheets cell step 4

Step 5: Select Insert image in cell to launch a dialog box.

How to insert images in a google sheets cell step 5


How to insert images in a google sheets cell step 5

Step 6: Click on the preferred image source from the dialog box and select the image you need to add to the spreadsheet.

How to insert images in a google sheets cell step 6


How to insert images in a google sheets cell step 6

Step 7: Navigate to the specific image then click on Insert.

How to insert images in a google sheets cell step 7


How to insert images in a google sheets cell step 7

Step 8: If the cell size is too small to appropriately display the image, right-click the column label which has the image.

How to insert images in a google sheets cell step 8


How to insert images in a google sheets cell step 8

Step 9: Select Resize column from the list of options to launch a pop-up window where you can provide the size values.

How to insert images in a google sheets cell step 9


How to insert images in a google sheets cell step 9

Step 10: Input the size value you desire. Note that the higher the value you provide, the larger the size of the column. You can also opt to fit the column to the size of the data provided.

How to insert images in a google sheets cell step 10


How to insert images in a google sheets cell step 10

How to insert images in a google sheets cell step 11


How to insert images in a google sheets cell step 11

Step 12: Right-click the row number which has the image.

How to insert images in a google sheets cell step 12


How to insert images in a google sheets cell step 12

Step 13: Select Resize row from the list of options to launch a pop-up window where you can provide the size values.

How to insert images in a google sheets cell step 13


How to insert images in a google sheets cell step 13

Step 14: Input the size value you desire. You can also opt to fit the row to the size of the data provided.

How to insert images in a google sheets cell step 14


How to insert images in a google sheets cell step 14

How to insert images in a google sheets cell step 15


How to insert images in a google sheets cell step 15

An easier way to resize the Google Sheets’ cells is to move the mouse pointer to the edge of the column (left or right edge). Once it turns blue, click and drag until you achieve the size you need.

Also on Guiding Tech

Moving an Existing Image from One Cell to Another

What if you need to move an existing image from one cell to another? Not to worry, this operation is possible in Google Sheets, and here’s how to do so:

Step 1: Click on the cell with the image.

How to insert images in a google sheets cell step 16


How to insert images in a google sheets cell step 16

Step 2: Right-click on the cell and select Cut from the options.

How to insert images in a google sheets cell step 17


How to insert images in a google sheets cell step 17

Step 3: Place your cursor on the new cell and right-click.

How to insert images in a google sheets cell step 18


How to insert images in a google sheets cell step 18

Step 4: Select Paste from the options.

How to insert images in a google sheets cell step 19


How to insert images in a google sheets cell step 19

The image moves from its current location to the new cell in your Google Sheet.

Inserting an Image over Cells

The final operation we will discuss in this post is inserting images over cells in Google Sheets. In this case, the picture doesn’t get fixed inside the cells. Instead, it appears over the cells, just like the operation’s name implies. As such, it hides the content of the cells behind the image. This operation comes in handy when you need to add some design to your spreadsheet. Here’s how to insert an image over cells in Google Sheets:

Step 1: Click on Insert in the menu bar.

How to insert images in a google sheets cell step 3


How to insert images in a google sheets cell step 3

How to insert images in a google sheets cell step 4


How to insert images in a google sheets cell step 4

Step 3: Select Insert image over the cell to launch a dialog box.

How to insert images in a google sheets cell step 20


How to insert images in a google sheets cell step 20

Step 4: Click on the preferred image source from the dialog box and select the image you need to add to the spreadsheet.

How to insert images in a google sheets cell step 6


How to insert images in a google sheets cell step 6

Step 5: Navigate to the specific image then click on Insert.

How to insert images in a google sheets cell step 7


How to insert images in a google sheets cell step 7

You can always make adjustments to the image if you need to.

Managing Google Sheets Cells Using Conditional Formatting

Now you know how to insert images into cells in Google Sheets. If you would like to improve how the pictures in your Google Sheets cell look, you can use conditional formatting.

Last updated on 8 Jan, 2022

The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.

(function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(d.getElementById(id))return;js=d.createElement(s);js.id=id;js.src=”http://connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.5&appId=1652915528311925″;fjs.parentNode.insertBefore(js,fjs);}(document,’script’,’facebook-jssdk’));

Leave a Reply

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

three × 4 =