How to☝️ Insert a Background Image in Google Sheets

To insert a background image in Google Sheets, select a blank cell, go to the Insert menu, click on Image, pick Insert image in cell or Insert image over cells, choose the source where the image can be found, pick the image, and hit Insert.

In this article, we will go over the methods on how to add a background image in Google Sheets, making your data more visually appealing with just a little effort.

Stick around for a more detailed guide below.

The Easiest and Quickest Way to Add a Background Image

Learn how to insert an image directly into the cell of your choice by following the steps listed below:

Difficulty: Beginner

Time Estimate: 7 seconds

  1. Select the cell where you need to paste an image.
  2. Navigate to the Insert menu.
  3. Pick the Image option.
  4. Choose Insert image in cell.

The Easiest and Quickest Way to Add a Background Image

  1. Select the source on your computer where the image is stored. Here we use Google Drive.
  2. Choose the image.
  3. Hit the Insert button.

The Way to Add a Background Image

Here is the result!

Background Image

If you want to insert an image over cells rather than in a particular cell, use the previous steps but select the Insert image over cells option in the Image menu instead:

Insert image over cells

As soon as the image has been inserted, you will be able to resize it as well as move it using the corner handles and dragging it along.

The Background Image in Google Sheets

Easy as ABC!

Note: This being said, there are a few things you need to keep in mind:

  • Firstly, make sure the image is high contrast. A low resolution image simply serves as a distraction rather than an enhancement of the document. 
  • Secondly, keep the size of the image in mind: too large and it will take up too much space; too small and it will get lost in the data. 
  • Finally, make sure the image is saved in a format that Google Sheets can understand, such as JPEG or PNG.

How to Use a Hyperlink to Add a Background Image

Use the following steps to insert images quickly using a hyperlink:

Difficulty: Beginner

Time Estimate: 7 seconds

  1. Select a blank cell.
  2. Go to the Formula bar and enter the formula =IMAGE(B1,2). Here B1 is the cell with the image’s URL, and 2 is the mode code. 

How to Use a Hyperlink to Add a Background Image

  1. Press the Enter key on your keyboard. 

Hyperlink to Add a Background Image

Easy-peasy! That’s all it takes.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning. Daniel loves to learn about new technologies and how they can be applied to solve complex problems. He is also a big fan of productivity hacks and enjoys finding ways to automate tasks to make organizations more efficient.