Add an image to a spreadsheet

You can add images under 50 MB in .png, .jpg, or .gif format. Follow the image usage guidelines.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the cell where you want to add an image.
  3. Click Insert and then Image
  4. Select to place your image in the cell or over the the cells. Cells with an image cannot also have text.
  5. Choose an image or take a snapshot.
  6. Click Open or Select.

Add an image from your desktop or the web

Copy an image from your desktop or the web and paste it directly into your document, presentation, or spreadsheet. It may take a moment for your image to appear.

Use a function to add an image

Use the IMAGE function. Your image will automatically resize to fit inside the cell. To choose how the image fits:
  • Size to fit: =IMAGE(“URL”), =IMAGE(“URL”, 1)
  • Stretch to fit: =IMAGE(“URL”, 2)
  • Original size: =IMAGE(“URL”, 3)
  • Custom size: =IMAGE(“URL”, 4, [height in pixels], [width in pixels])

Replace an image that's over the cells

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the image you want to replace.
  3. In the top-right corner of the image, click More Moreand then Replace image.
  4. Choose an image.
  5. Click Replace or Select.

Add an alternative title & description to an image

If your image is in a cell:
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Right click the image.
  3. Click Alt text.

If your image is above the cells:

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the image and then More Moreand then Alt text.

Move or resize an image

Move an image

  • To move an image from one cell to another, use cut and paste.
  • To move an image that's over the cells, click and drag it.
  • To move an image from inside a cell to over the cells, right click the image and click Put image over cells.
  • To move an image from over the cells to inside a cell:

    1. ​​Click the cell you want to place the image in.

    2. Click the image and then More Moreand then Put image in selected cell.

Tip: To move more than one item at the same time, press CTRL or Command and click the items you want to move.

Resize an image
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the image you want to change.
  3. Drag the blue markers to resize the image.

Tip: To resize more than one item by the same amount, press CTRL or Command and click the items you want to resize.

Was this helpful?
How can we improve it?