Skip to main content
Web Applications

Return to Answer

improved formatting
Source Link
edit approved Dec 15, 2018 at 14:23
slybloty
edit approved Dec 15, 2018 at 14:23
slybloty
  • 854
  • 2
  • 11
  • 25

Unfortunately, @pnuts method does not insert an image into a cell in a Google Sheet. It places the image in a layer above the cells, where it's not connected to any particular cell. You can move it around, size it, and so on, but it won't move when you sort or insert cells. 

If you want the contents of a cell to be an image, you must use the IMAGE()IMAGE() function, which takes a URL as its main parameter, with optional parameters for resizing the image.

Sadly, the URL cannot point to an image on your Google Drive: it has to be a publicly available image with a plain-vanilla <http://…>http://… type URL. If
If there's an error in your URL parameter, you won't get an error message, and the function is tricky: an image URL that works fine with the HYPERLINK function may not work with IMAGEIMAGE. You may also find image orientation changes for no obvious reason.

Unfortunately, @pnuts method does not insert an image into a cell in a Google Sheet. It places the image in a layer above the cells, where it's not connected to any particular cell. You can move it around, size it, and so on, but it won't move when you sort or insert cells. If you want the contents of a cell to be an image, you must use the IMAGE() function, which takes a URL as its main parameter, with optional parameters for resizing the image.

Sadly, the URL cannot point to an image on your Google Drive: it has to be a publicly available image with a plain-vanilla <http://…> type URL. If there's an error in your URL parameter, you won't get an error message, and the function is tricky: an image URL that works fine with the HYPERLINK function may not work with IMAGE. You may also find image orientation changes for no obvious reason.

Unfortunately, @pnuts method does not insert an image into a cell in a Google Sheet. It places the image in a layer above the cells, where it's not connected to any particular cell. You can move it around, size it, and so on, but it won't move when you sort or insert cells. 

If you want the contents of a cell to be an image, you must use the IMAGE() function, which takes a URL as its main parameter, with optional parameters for resizing the image.

Sadly, the URL cannot point to an image on your Google Drive: it has to be a publicly available image with a plain-vanilla http://… type URL.
If there's an error in your URL parameter, you won't get an error message, and the function is tricky: an image URL that works fine with the HYPERLINK function may not work with IMAGE. You may also find image orientation changes for no obvious reason.

Source Link
David Knapp
David Knapp
  • 99
  • 1
  • 7

Unfortunately, @pnuts method does not insert an image into a cell in a Google Sheet. It places the image in a layer above the cells, where it's not connected to any particular cell. You can move it around, size it, and so on, but it won't move when you sort or insert cells. If you want the contents of a cell to be an image, you must use the IMAGE() function, which takes a URL as its main parameter, with optional parameters for resizing the image.

Sadly, the URL cannot point to an image on your Google Drive: it has to be a publicly available image with a plain-vanilla <http://…> type URL. If there's an error in your URL parameter, you won't get an error message, and the function is tricky: an image URL that works fine with the HYPERLINK function may not work with IMAGE. You may also find image orientation changes for no obvious reason.