Place Images in Cells or Over a Google Sheet Without Losing Record Labels

Quick answer

Choose Insert → Image and select Image in cell or Image over cells. Use an empty destination for an in-cell image: it cannot share its cell with text. An over-cell image is a separate movable object, not a replacement for a record’s ID or description. Google’s desktop image guide documents these modes.

Prepare a harmless image register

Use desktop Google Sheets with edit access to a disposable native spreadsheet. This exercise describes the ordinary image controls, not a mobile interface or a paid add-on. The rolling help was checked on 21 October 2026; no account was opened and no application interaction, screenshot or saved-state test was performed for this article.

Choose one non-sensitive photograph or drawing that you own and are comfortable storing in your Google spreadsheet. Use PNG or JPG under 50 MB; the help also allows GIF but excludes SVG. No sample photograph is supplied. Do not use a confidential label, another person’s photo, or an image copied from a website without permission just to complete this exercise.

Name the practice tab Image register. Enter A1:C4, leaving all three Photo cells empty:

Item ID	Quantity	Photo
BOX-A	2
BOX-B	5
BOX-C	3

Put Quantity control in E1 and =SUM(B2:B4) in E2. Expect 10, independently calculated as 2 + 5 + 3. Keep each ID as text in column A; a photograph is supplementary evidence, not the only way to identify a row.

Insert into the empty photo cell

Select C2, use Insert → Image → Image in cell, and choose the owned image. Inspect the result yourself. C2 is the image destination; A2 must still say BOX-A and B2 must still contain 2. Never choose A2 as the destination merely because it sits beside the item: it already holds the essential identifier.

Right-click the in-cell image and choose Alt text. Enter a short description of what the image actually shows, such as “Front of the empty blue storage box,” only if that matches your image. Do not claim that an image is verified or accessible merely because the dialog accepted text; inspect the saved description, and perform a separate assistive-technology check if that matters to your readers.

Convert placement without overwriting a label

Right-click the image and choose Put image over cells. Drag the resulting object into a blank area, away from A1:C4 and E1:E2. Resize it with its blue markers if needed. These are the documented object controls; exact size and appearance are for you to inspect, not measured results from this guide.

For the reverse conversion, first confirm C6 is empty and select it. Select the over-cell image and use More → Put image in selected cell. Verify the image arrived at C6, not at a cell containing a record or control formula.

The temporary destination is intentionally outside the register. Move the in-cell image from C6 back to the empty C2 using cut and paste. Check that C6 no longer holds that image and C2 does. To inspect alternative text on an over-cell image, its documented route is More → Alt text rather than the in-cell right-click route.

Reconcile the records after the experiment

Compare A2:B4 with the original table, cell by cell. The expected pairs are BOX-A/2, BOX-B/5 and BOX-C/3. E2 should still contain the SUM formula and report 10. A correct total is not enough: swapping 2 and 5 would also total 10 while assigning the wrong quantity to two items.

Wait for Sheets to finish saving, reopen the practice spreadsheet yourself, and check the image’s destination, its description and all three ID/quantity pairs. These are proposed reader checks, not reported execution evidence. Sorting, filtering, downloading to XLSX and opening in another application are additional workflows; this page does not certify image association or fidelity in those cases.

Troubleshooting boundaries

• A label disappears: stop. Return to your untouched practice data rather than relying on the picture to reconstruct the ID. Keep image destinations separate from text.
• The picture covers a value: move the over-cell object to a blank area. A quantity hidden behind an object has not become an image caption.
• The image will not insert: check ownership, supported format and the documented file-size limit before retrying; do not loosen sharing permissions or make a private file public as a workaround.
• You are using IMAGE instead: that is a URL-based cell formula with different restrictions. See the IMAGE reference; it is not the same procedure as uploading an owned local image through Insert.

For general tab organization, see create and reuse spreadsheets. Keep a text-based register even when photographs make visual recognition easier.