Google Sheets shares many of the characteristics of Microsoft Excel that have helped to make it such a popular application. Along with the ability to store, sort, and manipulate data, Google Sheets lets you add pictures to your spreadsheets too.
But if you are mainly familiar with Excel and new to Google Sheets, you may be having trouble determining exactly how to put your images into your spreadsheets. Our guide below will show you where this option is located so that you can generate the data and image layout that you require.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
How to Put a Picture in a Cell in Google Sheets
The steps in this article are going to show you how to add a picture to a spreadsheet that you are editing in Google Sheets. This specific guide is going to focus on adding a picture that is saved to your computer’s hard drive, but you are also able to add pictures from your Google Drive, or with a URL from a picture you found online.
Note that you might have better luck with your layout if you merge a few cells and insert the picture into that merged cell.
Step 1: Open your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet file to which you want to add a picture.
Step 2: Click the Insert tab at the top of the window, then click the Image option.
Step 3: Select the type of picture that you want to add from the options at the top of the pop-up window, then follow the instructions for that tab.
Step 4: Choose the picture that you wish to add to the spreadsheet. If you are adding one from your computer, then click the Open button after selecting the picture.
Step 5: You can resize the picture by clicking on it, then dragging the blue handles on the border of the image. You can also click on the picture and drag it to the desired place in the spreadsheet.
You can use a similar method to insert a picture in Google Docs. The process is nearly identical for both applications.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.