Free Online Storage

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Tuesday, 30 November 2010

Tips and Tricks: Images in cells

Posted on 13:11 by Unknown
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
Email ThisBlogThis!Share to XShare to Facebook
Posted in Google Apps Blog, spreadsheets | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • More Google Experiments That Hide Results URLs
    There are at least two other versions of the Google experiment that removes search results URLs . The first alternate version places site na...
  • Merge cells vertically in Google spreadsheets
    There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting to...
  • Add a Keyboard Shortcut for Chrome's App Launcher
    I'm not sure why Chrome's app launcher doesn't have a keyboard shortcut, but it's pretty easy to add one. For Windows XP, r...
  • What's The Right Answer?
    Sometimes the same question can have multiple answers, even when you're looking for a simple fact. I've searched for [ny population]...
  • Google Quick View
    Google Search for mobile has a new feature called " Quick View ". Right now, it only shows up for Wikipedia results and it allows ...
  • Online Office Hours with Google Docs
    Cross-posted on the Google Student Blog Guest Post: Alex is a senior at Harvard University, and interned this summer on Google's marketi...
  • Give us your feedback with Product Ideas for Google Docs
    With Google Docs, we've learned that some of our most valuable insights come from our users, and we are always excited by what you have ...
  • More In-Depth Articles in Google Search
    For general queries like [ global warming ], [ love ], [ Mandela ], [ China ], Google shows some in-depth news articles at the bottom of th...
  • A completely new look for Drive on iOS
    One of the features you’ve told us you want on Drive for iOS is the ability to effortlessly browse and preview files, just like you can on A...
  • We launched Table of Contents, too
    I'm writing this from the Phoenix Sky Harbor airport, just 5 minutes before I hop on a plane back to Google in California. I spent the d...

Categories

  • Acquisitions
  • Ads
  • Android
  • Annoyances
  • April Fools Day
  • attachments
  • back to school
  • Blogger
  • charts
  • chat
  • Chrome
  • Chrome extensions
  • chrome web apps
  • Cloud Connect
  • collaboration
  • comments
  • community
  • discussions
  • DMCA
  • docs
  • document list
  • documents
  • documents list
  • drawings
  • drivebacktoschool
  • Easter Egg
  • education
  • Faces of Docs
  • forms
  • gmail
  • gone google
  • Google Alerts
  • Google Analytics
  • Google Apps Blog
  • Google Apps Script
  • Google Calendar
  • Google Cast
  • Google Checkout
  • Google Chrome
  • Google Chrome OS
  • Google Cloud Connect
  • Google Contacts
  • Google Dictionary
  • Google Docs
  • Google Docs Viewer
  • google documents
  • google drive
  • Google Earth
  • Google Goggles
  • Google Hangouts
  • Google Instant
  • Google Keep
  • Google Latitude
  • Google Local
  • Google Maps
  • Google Music
  • Google News
  • Google Notebook
  • Google Now
  • Google Pack
  • Google Photos
  • Google Play
  • Google Plus
  • Google Reader
  • Google Sites
  • Google Suggest
  • Google Takeout
  • Google Talk
  • Google Toolbar
  • Google Translate
  • Google Trends
  • Google Voice
  • Google Wallet
  • Google+
  • googlenew
  • Greasemonkey
  • Guest Post
  • holiday
  • iGoogle
  • Image Search
  • images
  • InOut
  • iOS
  • Keep
  • Knowledge
  • mobile
  • OCR
  • offline
  • OneBox
  • paperless
  • pdfs
  • photo
  • photos
  • Picasa Web Albums
  • presentations
  • product ideas
  • profiles
  • quickoffice
  • Reddit
  • research
  • save to drive
  • scripts
  • Security
  • sharing
  • sheets
  • shortcut
  • slides
  • spell check
  • spreadsheets
  • stock photos
  • storage
  • students
  • tables
  • teachers
  • templates
  • Tips
  • User interface
  • videos
  • Viewer
  • Visualization
  • Voice Search
  • Web Search
  • Yahoo
  • YouTube

Blog Archive

  • ►  2013 (519)
    • ►  December (33)
    • ►  November (44)
    • ►  October (64)
    • ►  September (50)
    • ►  August (63)
    • ►  July (60)
    • ►  June (57)
    • ►  May (62)
    • ►  April (49)
    • ►  March (33)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (34)
    • ►  December (4)
    • ►  November (4)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (5)
  • ►  2011 (80)
    • ►  December (4)
    • ►  November (1)
    • ►  October (7)
    • ►  September (10)
    • ►  August (11)
    • ►  July (8)
    • ►  June (9)
    • ►  May (1)
    • ►  April (8)
    • ►  March (8)
    • ►  February (8)
    • ►  January (5)
  • ▼  2010 (118)
    • ►  December (11)
    • ▼  November (16)
      • Tips and Tricks: Images in cells
      • Improving team collaboration and productivity with...
      • New this week in Docs: Drag and drop upload and co...
      • A bridge to the cloud: Google Cloud Connect for Mi...
      • Tips & Tricks: Creating new Google Docs from your ...
      • Editing your Google Docs on the go
      • Faster typing, fewer mistakes
      • New this week in Docs: auto-corrections, LaTeX in ...
      • Tips & Tricks: Moving my files to the cloud
      • Tips & Tricks: Our favorite shade of beige, the ruler
      • Google Docs on Twitter
      • Writing a campaign speech with Google Docs
      • Join the Docs Community on YouTube
      • Recapping the Google Sites webinar
      • New in Google Docs and Google Sites
      • Guest post: Writing a book using Google Docs
    • ►  October (6)
    • ►  September (13)
    • ►  August (13)
    • ►  July (7)
    • ►  June (15)
    • ►  May (11)
    • ►  April (7)
    • ►  March (7)
    • ►  February (6)
    • ►  January (6)
  • ►  2009 (82)
    • ►  December (14)
    • ►  November (4)
    • ►  October (10)
    • ►  September (10)
    • ►  August (4)
    • ►  July (6)
    • ►  June (6)
    • ►  May (5)
    • ►  April (4)
    • ►  March (8)
    • ►  February (7)
    • ►  January (4)
  • ►  2008 (97)
    • ►  December (6)
    • ►  November (4)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (7)
    • ►  June (11)
    • ►  May (20)
    • ►  April (13)
    • ►  March (6)
    • ►  February (6)
    • ►  January (5)
  • ►  2007 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (10)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
Powered by Blogger.

About Me

Unknown
View my complete profile