To insert an image in Google Sheets, open the sheet in a web browser, select Insert > Image, then choose Image in cell or Image over cells. The first option keeps the picture inside a spreadsheet cell; the second places it as a movable object above the grid. Have the image file, a usable image link, or access to its Google Drive location ready before you begin.
What You’ll Need
- A Google account with permission to edit the spreadsheet. View-only access will not let you add an image.
- A browser with the Google Sheets file open. The instructions below are for Sheets on the web, not Microsoft Excel.
- An image you can access: for example, a JPG or PNG on your computer, in Google Drive, or at a web address. For a web address, use a direct image link where possible, not just the page that displays the image.
- A little room in the sheet. If the picture will sit inside a cell, plan which cell should hold it and whether its row or column needs to be enlarged.
Step-by-Step
- Open the spreadsheet and choose where the image belongs. Go to Google Sheets in your browser and open the correct file. If you want the image contained within one cell, click that cell first; it is fine to select a blank cell in a new area of the sheet. If you want the image to float above the grid, select the area where you want it to appear. The selection helps you position the image, but you can move an over-cells image afterward.
- Open the image insertion menu. Select Insert > Image from the menu bar. Sheets presents two placement choices: Image in cell and Image over cells. These options are not interchangeable, so decide based on how you intend to use the picture. An in-cell image is associated with a cell; an over-cells image is an object layered across the sheet.
- Choose the placement that fits your sheet. Click Image in cell if the image is part of a record, such as a product thumbnail beside its name, or if it should travel with a particular cell. Choose Image over cells for a logo, diagram, or larger visual that should sit over the grid and can be dragged or resized independently. If you are unsure, an in-cell image is usually easier to keep aligned with table data.
- Select where to get the picture. In the image picker, choose an available source such as uploading from your computer or selecting an image from Drive. The picker may also offer other sources, depending on your account and device. For an upload, locate and select the file, then confirm the selection. For Drive, choose the correct file and use the insert or select control in the picker. Wait for the image to finish loading before clicking elsewhere.
- Check the result and its placement. An image in a cell appears within the selected cell, while an image over cells appears on top of the sheet grid. If you chose the wrong placement, you can undo the insertion with Ctrl+Z on Windows or Command+Z on Mac, then repeat the insertion with the other option. Confirm that the picture is in the intended row or area before continuing.
- Adjust an image in a cell. In-cell images fit the space available in their cell. To make one easier to see, increase the column width by dragging the boundary between column letters, increase the row height by dragging the boundary between row numbers, or adjust both. The image remains associated with the cell as its available space changes. If the image looks too small, check that the row and column are not unusually narrow.
- Move or resize an image over cells. Click the image to select it. Drag it to move it, or drag a handle on its edge or corner to change its size. Use a corner handle when you want to preserve the image’s proportions; pulling a side handle can make it look stretched. Click outside the image when finished. Leave enough clear space around it so it does not obscure labels, values, or controls in the sheet.
- Verify and save your work. Google Sheets saves changes automatically, but wait for the saving indicator to finish if it appears. Scroll or zoom out briefly to check how the image sits in relation to nearby data. If the file is shared, consider whether collaborators need access to the image source as well; a picture that came from a restricted Drive file may not be accessible to everyone in the same way.
Common Mistakes
- Picking the wrong image mode: An image over cells can cover spreadsheet contents and may not behave like a cell value when the table is sorted. An image in a cell is a better fit for a row-based list where the picture belongs to a specific entry. Undo and insert it again using the other menu option if needed.
- Choosing a web page instead of an image: A normal page URL may lead to a site rather than a picture file, and Sheets may not be able to use it as an image source. If the URL option is available, use a direct image address and make sure it can be opened without signing in. Uploading a permitted local copy or selecting it from Drive is often simpler.
- Assuming an image is a cell value in both modes: An over-cells picture is a floating object, not text or data contained in the cell underneath it. Clicking that cell may not select the picture, and sorting rows may not keep the picture aligned with the matching record. Choose in-cell placement when row association matters.
- Resizing only the picture or only the grid: In-cell pictures depend on cell space, while over-cells pictures have their own handles. Dragging a row boundary will not resize a floating image in the same way as an in-cell image. Identify the mode first, then use the appropriate adjustment.
- Inserting a very large or unsuitable file: Huge images can take longer to load and make a busy sheet harder to use. Resize or compress a copy before uploading if practical, and choose a format that displays correctly in a browser.
Tips
- Use a consistent layout for catalogs. Put product names, descriptions, or IDs in neighboring columns and keep each thumbnail in the same image column. Use similar source-image dimensions so one row does not look much taller than the next.
- Keep images clear without making the sheet unwieldy. Set a practical row height and column width, then check the sheet at its normal zoom. A thumbnail usually does not need to be large enough to show every detail; link to a full-size source separately if readers need it.
- Use descriptive nearby text. Add a name or short description in an adjacent cell rather than relying on the picture alone. This makes a table easier to scan and gives collaborators context if an image fails to load.
- Consider access before sharing. If the source image is in Drive, check the file’s sharing permissions when collaborators report that they cannot see or use it. A shared spreadsheet does not automatically mean every separate Drive file has identical access settings.
- Keep important data visible. Place floating images in an unused section of the sheet or reserve rows for them. This reduces the chance of covering figures and makes the spreadsheet easier to print or review.
Troubleshooting
The Image option is unavailable or insertion is blocked. Check whether you have editor access rather than view-only access. If the sheet is protected, ask its owner whether you are allowed to edit the relevant area. Refresh the browser tab if the menu appears stuck, then reopen the spreadsheet and try again.
The picture does not appear after selecting it. Give Sheets a moment to upload or load the file. Check your internet connection and confirm that the file is an image format the browser can display. If you chose Drive, verify that you selected the intended image, not a folder or document. Try uploading a smaller copy if a large file repeatedly fails.
The image is too small, cropped-looking, or difficult to see. First determine whether it is in a cell or over cells. For an in-cell image, widen the column or increase the row height to provide more room. For an over-cells image, select it and drag a corner handle to enlarge it without distorting its proportions. If the source itself is low-resolution, resizing it larger will not restore missing detail.
The image covers information or will not move as expected. Click the image itself to select a floating, over-cells picture; clicking the grid behind it may select a cell instead. Drag the selected picture to an empty area. If you meant for it to sit inside a data cell, undo and insert it again with Image in cell. When a picture seems attached to a record, check that it was inserted in-cell rather than left as a floating object.
A collaborator cannot see the image. Ask them to reload the sheet and check their internet connection. If the image depends on a Drive file with restricted sharing, review that file’s access settings with its owner. Do not make private files public just to solve the issue; use the least-permissive sharing option that gives the intended collaborators access.
Frequently Asked Questions
Can I put an image directly inside a Google Sheets cell?
Yes. Choose Insert > Image > Image in cell, then select the image source. The picture occupies the selected cell and fits the space provided by that cell’s row and column.
What is the difference between Image in cell and Image over cells?
An in-cell image belongs to a cell and is suited to thumbnails attached to table entries. An over-cells image floats on top of the grid, can be positioned and resized independently, and can cover cell contents if you place it over them.
Can I insert an image from my computer?
Yes. Use Insert > Image, choose the placement, then select the upload-from-computer option in the image picker if it is offered. Browse to the image file and confirm the selection. The exact picker labels can vary as Google updates its interface.
Can I paste an image into Google Sheets?
Copying and pasting an image may work for some sources and browsers, but it is less predictable than using Insert > Image. If pasting does not work or the image lands in the wrong place, use the menu and choose in-cell or over-cells placement deliberately.
Can I add an image on a phone or tablet?
Google Sheets mobile apps have their own menus and may offer image insertion options, but the steps and available sources differ by device and app version. For precise placement and easier resizing, use Sheets in a desktop browser and follow the steps above.
Will an image stay with its row when I sort the sheet?
An image inserted in a cell is the appropriate choice when it belongs to a row’s data. A floating image placed over cells is not a dependable substitute for a cell value during sorting. If matching pictures to records is important, use in-cell images and test the sort on a copy of the sheet first.
Related
- How to Indent in the Same Excel Cell
- How to Indent in an Excel Cell: Steps, Tips and Fixes
- How to Indent in Excel: Shortcuts, Cells, and Options
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation Allow List: Create and Manage OneYes. In Excel for Microsoft 365 on Windows, create an allow list by selecting the cells, choosing Data…
- Compare Two Sheets for Matches in Excel: A Practical GuideTo compare two Excel sheets for matching records, use a shared key such as an ID or email…
- How to Make Columns in Microsoft Word, Step by StepTo make columns in Microsoft Word, place your cursor where the layout should begin, then choose Layout >…
- How to Set Up Auto Forwarding in Microsoft OutlookTo automatically send incoming Outlook email to another address, open Settings > Mail > Forwarding in Outlook on…
- How to Set Out of Office in Outlook 365 WebTo set an out-of-office reply in Outlook 365 on the web, open Settings, go to Accounts > Automatic…
- Creating a Signature in Microsoft Outlook: Setup GuideTo create an Outlook signature, open the signature settings for your version of Outlook, add and format the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.