Adding An Image To A Google Sheet

We can add images to a Google Sheet using the Insert menu option. This will insert an image above the cells where it will float above the text and we can position it as needed. We can also insert an image into a cell from a web-site. An image inserted into the cell will be part of the cell.

To Insert, a floating image, click on Insert in the menu and select “Image”.

DraggedImage.a1802720e44a4a0e8c401b47a1141d76.png

 

DraggedImage.059119c3e3574a45ba9d00e0fdb3205b.png

We can upload an image from our device or select one of the other options to insert an image. Click on the search option so we can find an image on the Internet.

DraggedImage.6d85cd485fb0487f88dca04c4caeb5f1.png

Search for a Google logo.

DraggedImage.35ca1629134d49d7b1c879124a895cf9.png

Click on an image to place on the spreadsheet and click the select button.

DraggedImage.4a59cedad7ce4c92b3dd7da19cd99040.png

The image will be placed in the spreadsheet, and floating above the cells.

DraggedImage.84b9d34a4d0248958bb69dbed44e567a.png

We can resize the image using the image handles.

DraggedImage.80a0c4bf06d849b8b4ac3482e7270400.png

We can place the floating image anywhere on our sheet.

Another way to add images is to embed the image into one of the spreadsheet cells. When embedding images into a cell, the image must be on some web-site or stored on a server somewhere. The image is embedded using the link to this image on the Internet. Luckily there are plenty of ways we can upload an image onto the Internet.

DraggedImage.db9932f851a7488786b72ab0b0a06a93.png

Click once on a cell where the image will be embedded.

DraggedImage.66b3a474b79749818bf5fc91bfa3b0ed.png

Search on the Internet for an image. I’ll search for the Google logo.

DraggedImage.aedba683690648ed859ad744d24de187.png

Click once on the image to reveal the larger image.

DraggedImage.d848fcf88daf4bf7af83b7988e308656.png

We need the link to the image. Right-click on the image. In the contextual menu we have several options. Select the option to copy the image address.

DraggedImage.e81a20dc3273474baa4a06b8b981ecf8.png

Go back to the spreadsheet and paste the link into the cell we selected earlier.

DraggedImage.2e8e3036369543068c2f25a208127ca0.png

This alone will not embed the image. We need to add some additional instructions. Click once at the beginning of the link. It’s easier if we use the Formula bar because there is more space to accommodate longer links.

DraggedImage.19cc2b9c4e934ad4be7326c706968576.png

Type =IMAGE, followed by an open parenthesis and an opening quotation mark into the address bar ahead of the link. As we type this information, the text in the formula bar will begin to change colors. This change is letting us know that Google sheets is recognizing the link as a reference to something. The image link should be green.

DraggedImage.dd0fb4fbb9834e8e913d8177e93d64f4.png

Go to the end of the link, place a closing quote and a closing parenthesis.

DraggedImage.461e16b48ab9471aa3c6ea828f5faf60.png

Click on an empty cell and the image should appear in the cell.

DraggedImage.512f61b90b6b4941995d2b76e83777e8.png

The image is very small because the cell height is small at 21 pixels. Click and stretch the row to make the cell larger.

DraggedImage.078450fb1c7e49618160f5e9cc182e86.png

The logo will grow in size as we increase the height of the row. We can also increase the width of the column to increase its size if needed. If we don’t increase the size of the column, the image will float to the bottom of the cell as we make the row taller.

DraggedImage.439b6cbe7fba4294b630bb9fc50213da.png

Here are the images on our sheet. One is embedded in a cell and the other is floating above the cells.

Posted in Google Sheets.