NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping  →
SheetSteps
Google Sheets tutorials›Spreadsheet basics›Insert an image over cells
Google Sheets · Verified tutorial

Insert an image over cells in Google Sheets

Create a stable image-placement fixture. In B2, enter exactly =IMAGE(A2). In C2, enter exactly "Over cells". Do not edit the image URL.

Verified by JosephineAbout 60 seconds
Quick answer

Create a stable image-placement fixture. In B2, enter exactly =IMAGE(A2). In C2, enter exactly "Over cells". Do not edit the image URL.

Step-by-step

1

Select the targetCreate a stable image-placement fixture.

2

Complete the next actionIn B2, enter exactly =IMAGE(A2).

3

Apply the changeIn C2, enter exactly "Over cells".

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

B2 renders the supplied image and C2 records the intended over-cells placement.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select B2 and repeat the final action. B2 renders the supplied image and C2 records the intended over-cells placement.

Example spreadsheet data

This is the clean fixture used for the verified run.

Image URLPreviewPlacement
https://www.gstatic.com/images/branding/product/1x/sheets_2020q4_48dp.png

Video transcript

  1. Open the prepared Image placement spreadsheet.
  2. Select the target. Create a stable image-placement fixture.
  3. Complete the next action. In B2, enter exactly =IMAGE(A2).
  4. Apply the change. In C2, enter exactly "Over cells".
  5. B2 renders the supplied image and C2 records the intended over-cells placement.

Related tutorials