oldstore‎ > ‎General tips‎ > ‎

Google spreadsheet: Inserting images inside of a cell

posted Nov 19, 2010, 2:51 AM by Johan Krom   [ updated Feb 17, 2011, 12:47 PM ]

When inserting a publicly accessible image inside of a cell in your spreadsheet, you have the following four options:

  • =image("URL") or =image("URL", 1): Inserting this formula into a cell will scale the image to fit inside of the selected cell. If the cell is bigger than image you're inserting, the remainder of the cell will be white.
  • =image("URL", 2): Inserting this formula will stretch the image to fit inside of the selected cell. The aspect ratio (height vs. width) of the image won't be preserved.
  • =image("URL", 3): This formula will insert the image into the cell at its original size. If the image is bigger than the cell, some of the image may be cut off.
  • =image("URL", 4, height, width): Inserting this formula allows you to customize the size of the image by specifying the height and width of the image in pixels. The height and width parameters are required for this option.
Original article