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.
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.