At times, you might want to insert images in Google Sheets to display data, charts, or anything else. If so, you can follow this step-by-step guide to add images in Google Sheets. Whether you use a template or a blank sheet, you can follow the same guide to get the job done.
Google Sheets is one of the best spreadsheet editing apps you can use for free. Whether you need to create a spreadsheet for your office, school, business, or anything else, you can use Google Sheets to get it done. Like Excel, it is easy to insert alphabets, digits, characters, etc., in any cell in Google Sheets. However, if you want to insert images in a cell or over some cells, you might need to go through some other steps.
You cannot use the drag-and-drop technique to get an image on the spreadsheet cells. On the other hand, it is not that difficult since Google Sheets comes with in-built options so that you can insert any image from almost any source in the spreadsheet.
For your information, you will be getting two options –
- Insert image in cell
- Insert image over cells
If you want to insert an image inside a specific cell in your spreadsheet, you need to use the first option. However, if you have a chart, graph, or anything else that you want to display in large size, you need to opt for the second option. In this case, you can choose a custom image size, assign a script, use alt text, etc.
How to add an Image in Google Sheets
To insert an image in Google Sheets, follow these steps:
- Open the Google Sheets.
- Go to Insert > Image.
- Choose Insert image in cell or Insert image over cells.
- Choose an image and click the INSERT button.
First, you need to open the spreadsheet in Google Sheets. However, if you want to create a new file, you can create a blank document.
Next, you need to decide the place where you want to display the image. If you want to insert an image in a specific cell, you need to click on that cell before going forward. However, if you want to display the image over multiple cells, you can skip this step.
Click on the Insert option in the top menu bar and select the Image option. As mentioned earlier, you can find two options here – Insert image in cell and Insert image over cells.
Choose an option as per your requirements. Following that, you need to select a source from where you want to insert your image. For example, you can upload an image from your computer, click a picture using your webcam, insert an image from a website, select one from Google Photos, Google Drive, etc. Last but not least is Google Image Search.
Once you get the image, click on it and click the INSERT button.
The image will be visible immediately. If you selected the Insert image over cells option, you could change the position, size, etc.
How to insert multiple images in Google Sheets?
You cannot insert more than one image in one cell in Google Sheets. However, if you select the second option, Insert image over cells, you can add multiple pictures in your spreadsheet. On the other hand, if you select a different cell each time, it is possible to insert multiple pictures in Google Sheets.
Can you insert images into Google Sheets?
Yes, you can insert images into Google Sheets. For that, you need to follow the aforementioned steps. There are mainly two options to insert an image in any spreadsheet. You can add images in a cell or over multiple cells. You need to choose an option as per your image and requirements.
That’s all! Hope it helped.