Format painter and GoogleLookup function now in the new Google Spreadsheets editor
June 23rd, 2010 | Published in Google Apps, Google Docs
- Format painter allows you to apply the same formatting to other elements more easily.
- GoogleLookup function attempts to find the values for straightforward facts about specific things.
Editions included:
Standard, Premier, Education, Team and Partner Editions
Languages included:
All languages supported by Google Docs
*GoogleLookup function is English-only
How to access what's new:
Format Painter: Apply the formatting that you want to a particular cell/column/row. Click the paintbrush icon to use the format painter, then click your desired cell/column/row to apply the exact same formatting.
GoogleLookup: Enter this formula syntax in the desired cell: =GoogleLookup("entity"; "attribute") where "entity" represents the name of the entity that you want to access, like Kuala Lumpur, Audrey Hepburn, or oxygen, and "attribute" is the type of information that you want to retrieve. An example would be =GoogleLookup("Ireland"; "internet users")
For more information:
http://docs.google.com/support/bin/topic.py?hl=en&topic=15115
http://docs.google.com/support/bin/answer.py?hl=en&answer=54199
Get these product update alerts by email
Subscribe to the RSS feed of these updates