Tips and Tricks: Images in cells

Tips and Tricks: Images in cells: "As we mentioned a couple of weeks ago, you can now insert images into a cell. With the image() formula you can link to a publicly accessible image and control how it will look with optional parameters. This is useful for bringing a visual element to your spreadsheets for things such as a product catalog listing.



For example the formula

=image('http://www.google.com/intl/en_ALL/images/srpr/logo1w.png', 1) will scale the image down in the current cell. With other parameters you can choose from a variety of sizing options including size to fit, stretch, original size, and even specify a custom size.

Try them all out using this template and let us know what you think in the comments.



Posted by: Li-Wei Lee, Senior Software Engineer

"