Sunday, September 27, 2009
We're still working to make Google Docs a better place, and we're listening closely to your suggestions. If you have anything you'd like to tell us, don't hesitate to let us know, and keep checking back for additions and improvements.
Print footnotes as endnotes
Choose to print your footnotes as endnotes through the 'print settings' page. Learn more
Find the definition of a word in a given language and then translate the word and the corresponding definitions into an alternate language. Learn more
Insert and edit mathematical equations and symbols in documents. Learn more
We've added a new question type (grid), support for right-to-left languages in forms, and a new color scheme for the forms summary. Also, you can now pre-populate form fields with URL parameters, and if you use Google Apps, you can create forms which require sign-in to access. Learn more
You can now translate an entire document into over 40 languages. Learn more
Now your target cell can include the =sum() and =sumproduct() functions. Learn more
Export images into .xls files
Description: Now you can export images from spreadsheets when exporting in .xls format. Learn more
Email as an attachment
From the share button you can now email your Google Spreadsheets workbook out directly as an attachment in .xls, .csv, .ods, .pdf and other popular formats. Learn more
Snap to grid
Auto-align text, images, shapes, and tables within your slides. Learn more
Insert an image into your drawing and add scribbles, shapes, lines, arrows, and text boxes on top of the image. Learn more
You can now add tables to Google Docs presentations. Learn more
Automatically cycle through slides
You can automatically cycle through slides in presentation mode and enable time delay, autostart, and loop. Learn more
With Solve, you can easily optimize linear equations by specifying a target cell for the result and adding constraints to help you reach your answer. Learn more
Converting numbers into Roman numerals as easy as I, II, III. Learn more
We're adding section headers to allow you to divide your form in sections and provide more information for your respondents within the form. Learn more
You can now import Word 2007 files (.docx) into Google Docs. Learn more
What's been keeping us busy
New publish dialog for spreadsheets
We've improved the sharing dialog to make it easier for you to publish your spreadsheet into different formats! Using the new publishing dialog, it's easy to get an html snippet, pdf file, or published link and share it with your friends, family, or colleagues. Learn more
Themes for forms
Add a splash of color to your surveys and questionnaires. When you create and edit a form, simply apply one of the 70 themes. Learn more
Spreadsheet owners can use the sheet protection feature to lock sheets so they can only be edited by collaborators the owner chooses. Learn more
List View and Mobile View Improvements
Now you can see your spreadsheets with all their formatting in List View and on your mobile device, this includes background/foreground colors, borders and text formatting! Learn more
Drawings and diagrams
Create your own drawings and diagrams in Google Docs and use them in your text documents, spreadsheets and presentations. As with the rest of Google Docs, your drawings are auto-saved and you can edit them collaboratively. To get started, open a document and select Insert > Drawing. Learn more
Find and replace toolbar for text documents
The "Find and replace" feature in the text document Edit menu has gotten a makeover and an upgrade. Now it's a slick toolbar that sports case matching, whole word matching as well as regular expression-style matching. Learn more
You can now import supporting cell data, formatting, formulas, font style, background color, named ranges, frozen panes, and horizontal merges from Excel '07. Learn more
Google Apps automatic identity in Forms
This feature enables the collection of the user's email address when filling out a form on a Google Apps domain. Learn more
Form summary page
The form summary page can now be printed. Learn more
List view in the desktop version of Google spreadsheets
You can now use list view's simple design and powerful filtering and sorting on your desktop or notebook computer. Learn more
Google Tournament function
The GoogleTournament() function allows users to query NCAA data (including team names, records, scores, seedings, game times, etc) in a Google spreadsheet (ideal for creating automatic brackets). Learn more
With two levels of validation, strict and lenient, you can now control what you and your collaborators enter into a spreadsheet. Learn more
This 'lightweight' version of Google Spreadsheets will allow you to do quick edits when you are accessing Google Spreadsheets from select mobile devices (Android, iPhone and Nokia S60), when you are on a slow Internet connection or when there are more than 50 people accessing your spreadsheet at the same time. Learn more
Form Summary for your collaborators
You can now let your collaborators or form respondents see a summary of the form responses. Learn more
Offline access in 40 languages
You can now view & edit text documents offline and view spreadsheets, forms, and presentations offline in 39 more languages. To get started, you'll first need to enable offline access for Google Docs.
Need to see how many pages your document is or check on how your footnotes look at the bottom of the page? Go to File > Print preview for quick look at how your document will appear when printed.
Forms in the templates gallery
We've added 13 spreadsheet forms to the Templates Gallery under a new document type "Forms". Browse the new forms.
Footnotes for your school assignments
You can now annotate your documents with footnotes. Use Insert > Footnote to add a footnote into the right margin. When printed, the footnotes will appear at the bottom of the page. Learn more.
New UI for spreadsheets!
Just like our other editors in Google Docs, spreadsheets now has an updated interface. Menus make it easy to find all of our great and unique spreadsheet editing features.
Sharing spreadsheets has also been updated. Now, it's simpler to invite people and manage access. As always, stay tuned as we continue to make this all-important action of sharing as simple as possible while giving you complete control over who sees and edits your content. Learn more
Add a table of contents to your documents
Use the heading styles to title sections of your document (from the format menu, select Minor Heading, Sub-Heading, Heading). Then add a table of contents that will refer to those titled sections (from the Insert menu, select Table of contents). Learn more.
"Look up word" (U.S. English only)
Select any word in your document, then go to the Tools menu to look up the word in your choice of U.S. English dictionary, thesaurus or encyclopaedia. Learn more.
Google search integration
Again via the Tools menu, search the web for the word or words you have selected - either a regular text Google search or a Google image search. Learn more.
New UI in presentations!
Google presentations now has a completely new interface, increasing the size of the slide during editing and visibility of thumbnails.
Zoom in and out of your slides to see your content in detail. Learn more.
Create forms in a jiffy
Choose New > Form to create new forms straight from Docs Home. We've also improved form editing, starting with drag-and-drop to reorder questions. Learn more.
Autosave for forms
You don't have to lift a finger to use this new feature. Now, your form edits are automatically saved.
Find and replace
Use Ctrl + F to search for and replace text across your entire spreadsheet. Learn more.
Two powerful new functions
IMPORTRANGE() can reference data from any of your spreadsheets. SPLIT() cleans up text in a cell by splitting it into multiple cells at any delimiter you choose. Learn more about the importrange() function and the split() function.
Bullet and Object Reveals in presentations
Pace your presentations with the new reveals feature. Set objects to appear in a certain order and advance through them by clicking. Set textboxes to reveal one bullet/paragraph level at a time. Learn more.
Create professional documents, spreadsheets, and presentations in Google Docs. Get a jump start with one of hundreds of templates. Browse the templates gallery or learn more. Google Apps user? Learn how to use templates in your Apps account.
Analytics tracking on published documents
You can now track how much traffic a particular published document is getting through Google Analytics. Learn more.
A new "Form" tab gives quick access to tools for creating, sending, and embedding spreadsheet forms. Learn more.
Scientific Notation Format
Use Scientific Notation to represent bigger numbers - for example, enter 1.23E+15 when you want 1,230,000,000,000,000 or format large numbers ending in 000's explicitly in this format using the new option on the Format dropdown. Learn more.
Expand gadgets to a full sheet
Give your gadgets more love. A whole window's worth of love. Now, you can use the "Move to own sheet" feature to give a gadget as much breathing room as it needs. (You can publish this separately, too!) Learn more.
We've finally added functions to convert between decimal, binary, hexadecimal and octal - known as dec2bin, dec2oct, dec2hex, and, well, if you know these, you know the rest. Learn more.
Custom colors in presentations
Can't find that specific shade of blue you need for your presentations? Now you can define colors in the color picker, creating your own palette for backgrounds, text and shapes in your slides. Learn more.