Add an image to a spreadsheet

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.

• 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])

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  Replace image.
4. Choose an image.
5. Click Replace or Select.

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  More  Alt text.

• 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  More  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.

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.