You can add an image to a sheet, or you can use the Image function to add an image to a particular cell. In this video, Jess Stratton shows you how to use the Image function and the parameters that go along with resizing the image.
- [Instructor] You can add an image to a spreadsheet.…Select Insert from the top menu, choose Image,…drag to find your image here,…browse Google Drive or you can also upload an image.…I'll select one from Google Drive…and click the blue Select button.…It's going to add it to your spreadsheet.…You can move it around.…Now, this one's quite large, so I'll also resize it.…It's interesting to note that it doesn't get in the way…of being able to edit cells.…
You can still edit cell contents behind the image.…However, it's not very easy to work with.…With Google Sheets, you can use the Image function…to add images to individual cells.…I'm going to erase this larger image.…Let's first find an image to add to a cell.…I'll click on our Landon Hotel website.…Here's an image.…I'll right-click on it and choose Copy Image Address.…The image function takes a web address for an image.…
I'll go back to my cell,…and we're going to start off a formula…by using the equals sign.…I'm going to put in the Image function in open parentheses.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons