Easily Add Images to Your Google Spreadsheet Using the =IMAGE Function

By

Get Shift Done: Tips and Tricks

You may already know that Google Sheets can insert images into the document using the “Insert Image” option, but it has limitations. In particular, you cannot control the display very well, and the image shows above the cells in the document.

Instead, by using the =IMAGE formula in Google Sheets, you easily can add images within the cell and managing how the image sizes.

Let’s say we have a series of photographs from a recent trip that we’d like to manage. We want to capture each image’s unique date, where the photo was taken, and notes about its purpose. By using the =IMAGE spreadsheet formula, we can display each image in a cell, as well as organize the other information in the rest of the row.

Read More