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.

Hello! Email Subscription Subscription Enter your email address and set your subscription preferences to have Apple news, special offers and product announcements delivered directly to your inbox VINIZIK

0 comments:

Post a Comment