LIFE=JOY.

Google Docs – What’s new?

What’s new in Google Docs?

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.

Just launched!

Connectors in drawingsNewly created lines can be connected to shapes and will stay connected when you move those shapes. Learn more.

New charts editorThe chart editor in spreadsheets has been redesigned from the ground up with new chart types and more. Learn more.

Image drag and dropIf you use Google Chrome, Firefox, or Safari you can now drag images from your desktop and drop them directly into a document. Learn more

Improved revisions in documentsSeeing the complete history of your document just got easier. You can now navigate between revisions and drill down to get more granular changes. Each editor’s changes are shown in that editor’s color. Learn more

More import options in spreadsheetsYou can now choose where your upload goes, preview the spreadsheet before import and more. Learn more

New fonts in documentsWe’ve added six new web fonts to documents: Droid Serif, Droid Sans, Calibri, Cambria, Consolas and Corsiva. Learn more

Selection and gridless printing in spreadsheetsCustomize your printouts with new printing options. Learn more

Real-time collaborative highlighting in documentsYou can now see when a collaborator highlights text. Learn more

In-cell dropdown and cell validationCreate dropdown lists in individual cells using the data validation tool in Google spreadsheets. Learn more

Show all formulasReveal all formulas in your spreadsheets with one click. Learn more

Spell checker in spreadsheetsYou can now check spelling in your spreadsheets using the tools menu. Learn more

More page sizesExecutive (7.25” x 10.5”), statement (5.5” x 8.5”) and more are now available in Google documents. Learn more

Auto-linking in documentsNow when you type something that documents recognizes as a link, it will become a link automatically. Learn more

A new curve tool in drawingsCreate smooth curves based on a series of points with this new tool. Learn more

Convert files in the document listYou can now convert files in the document list to a Google Docs format at any time. Learn more

Add words to dictionaryYou can now add words to the documents dictionary. Learn more

Draggable rows and columns in document tablesChange row heights and column width in tables using sliders. Learn more

Document translationYou can now translate a document into any of the 53 Google Docs supported languages. Learn more

Improved page navigation in formsUse the page navigation feature to direct respondents to relevant pages on your form. Learn more

Search improvementsFour new search operators (before:YYYY-MM-DD, type:document, and more) make it easier to find files in your documents list. Learn more

Format painter in spreadsheetsYou can now apply formatting or conditional formatting rules you’ve used on one set of cells to another separate set of cells using the Paint Format tool. Learn more

Optical character recognition (OCR)You can now upload and convert PDF or image files to text. Learn more

New sharing interfaceWe’ve streamlined the interface, added new visibility options, made access viewable at a glance, added resettable doc URLs and enabled bulk changes in the docs list. Learn more

A keyboard shortcut pop-up and more in drawingsYou can now view pop-up keyboard shortcut help, center drawings on the page, view thumbnails of drawings in the docs list, and search through all the text in your drawings. Learn more

Faster Google spreadsheets graduatesThe new Google spreadsheets is now the default for everyone. Columns can be dragged and dropped, the formula bar is editable, auto-complete speeds up data entry, and you can link directly to sheets. Learn more

New Google documents graduatesAll new documents are now created with the new version of documents by default. Take advantage of the new chat, character-by-character real time co-editing, sidebar comments and more. Learn more

Drawings in the template galleryCreate a drawing from the templates in the gallery or share your favorite drawing with the world. Learn more

Formula highlightingCell references and the corresponding cells are now highlighted to make it easier to keep track of your formulas. Learn more

Advanced sorting rulesSort a range of cells according to rules set for one column or across multiple columns. Learn more

New form themesChoose from 24 new themes which take advantage of the new Google Font API. Learn more

Comment scrolling in documentsWhenever you click on a comment it will scroll so that it’s directly beside the associated text. Learn more

Copy sheetYou can now copy sheets from one spreadsheet to another, separate spreadsheet. Learn more

What’s been keeping us busy

Re-size imagesAfter you insert an image into a document, click on the image to bring up controls that let you scale the image’s size in any direction. Learn more

Introducing Google drawingsGoogle Docs now has a collaborative drawings editor that makes it easy to build organizational charts, flow charts, design diagrams and much more. Learn more about Google drawings

New version of Google documentsWe’re previewing a totally re-built version of Google documents that adds a lot of new features and makes editing much snappier. The new version has chat, character-by-character real time co-editing, and makes imports and exports much better. Learn more about the new version and how to start using it

Faster Google spreadsheetsWe’re previewing a slicker interface that adds new features and makes Google spreadsheets faster and easier to use. In the new version, columns can be dragged and dropped, the formula bar is editable, auto-complete speeds up data entry, and you can link directly to sheets. Click New version to get started, or learn more in the Help Center.

Upload any fileOver the next couple of weeks, we’re rolling out the ability to upload, store, and share any file in Google Docs. Your files will be stored in their original format and downloadable from anywhere. Uploading files to the cloud allows them to be safely stored and accessible at all times. Learn more

Shared foldersNow you can simultaneously share a group of docs with your friends, coworkers, or family, by sharing an entire folder with them. Learn more

Drawings improvementsChoose ‘Insert Drawing’ in any document, spreadsheet, or presentation to check out these new features.

Snap to guidesSnap to guides helps you easily align objects with the drawings canvas and other objects. Learn more

PolylinesCreate continuous lines or even enclosed custom filled shapes composed of multiple segments. You can close shapes, fill them, and even move around points on a line by double-clicking the line. Learn more

Draw multiple linesIt’s now easier to quickly draw a sequence of related lines. Now when you finish drawing a line, arrow, or scribble, you stay in line drawing mode so you can start a new line immediately. Learn more

Translate and detect languages in Google spreadsheets=GoogleTranslate(“Hola, ¿cómo estás?”,”es”,”en”) gives “Hi, how are you?” (or leave out “en” and we’ll automatically choose the default language of your spreadsheet) What if you don’t know the language? =DetectLanguage(“Hola, ¿cómo estás?”) gives “es” Learn more

Forms: Add pages and allow navigation to a specific page within a formWhether it’s showing a different set of food questions for vegetarians and meat-etarians or building a Choose Your Own Adventure game, Google forms can take care of it all. Add page breaks to your form and let people fill out only the sections that are relevant to them. Learn more

Print footnotes as endnotesChoose to print your footnotes as endnotes through the ‘print settings’ page. Learn more

Dictionary translationFind the definition of a word in a given language and then translate the word and the corresponding definitions into an alternate language. Learn more

Equation editorInsert and edit mathematical equations and symbols in documents. Learn more

Forms improvementsWe’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

Translate documentYou can now translate an entire document into over 40 languages. Learn more

Solve improvementsNow your target cell can include the =sum() and =sumproduct() functions. Learn more

Export images into .xls filesDescription: Now you can export images from spreadsheets when exporting in .xls format. Learn more

Email as an attachmentFrom 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 gridAuto-align text, images, shapes, and tables within your slides. Learn more

Insert imagesInsert an image into your drawing and add scribbles, shapes, lines, arrows, and text boxes on top of the image. Learn more

New publish dialog for spreadsheetsWe’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 formsAdd 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

Sheet ProtectionSpreadsheet 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 ImprovementsNow 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 diagramsCreate 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 documentsThe “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

Data ValidationWith two levels of validation, strict and lenient, you can now control what you and your collaborators enter into a spreadsheet. Learn more

List ViewThis ‘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 collaboratorsYou can now let your collaborators or form respondents see a summary of the form responses. Learn more

Print previewNeed 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. Learn more