Docs Blog

January in Review: Styles, Sparklines, Google+ sharing, and more

2012-02-07T10:02:00.000-08:00

One of the best things about working on web apps like Google Docs is that it gives us the flexibility to frequently bring you new features and improvements. Starting this month, we’re going to make some small changes to how we communicate what’s been happening in the world of Docs. Instead of writing blog posts for each and every minor update, we're going to try bundling them together monthly to give you a detailed overview of our favorite features and a short list of other notable changes to make sure you don't miss out on anything new.

On that note, we’ve got a bunch of new features that launched today, as well as some great things that improved over the month of January.

Customizable styles in documents
Giving your document consistent and beautiful formatting should be easy. Before today, if you wanted to update all the Subtitles in your document to look a particular way, you had to change each of them one at a time. That’s too many steps. Now you can restyle all your regular paragraphs, headings, or titles with just a couple clicks. For example, if you want to update all the Subtitles in your document to be a particular size, set one Subtitle to that size, select it, right click and choose Update Subtitle to match selection. This will change all the Subtitles already in your document and automatically update the style for any new Subtitles you create. Plus, with the new Options menu in the styles dropdown, you can set the current document’s styles as the default for new documents or you can load your default styles into the current document.

Sparklines in spreadsheets and more charting options
In Google spreadsheets, we’ve added more charting options and support for sparklines to make it easier to communicate data. The new options give you a bunch of tools to create more sophisticated charts including different Y-axes on either side of the chart, formatting options for the axis and title text, and all sorts of other customization for how your lines, bars, or pies are displayed. We’ve also added sparklines, which let you display line or bar charts inside of cells and are handy for presenting and comparing data in a simple, bite-sized way. In the example below, we’ve used sparklines to plot currency exchange rates over a 30-day period.

Sharing forms on Google+
Sharing the forms you create in Google Docs with the right people shouldn’t be a hassle. Today we added a Google+ share to the form editor so that you can share your forms directly with your circles with just a couple clicks.

And there’s more…
On top of today’s new features, here are some changes from January that you may have missed:

Adding images to your docs from a high quality stock photo gallery. Simply go to Insert > Image, select Stock photos, and then search for the images that you want.

A more streamlined format for document discussion notifications that batches multiple discussions into a single email.
Quickly opening and selecting items from specific menus with keyboard accelerators. For example, when using Google Chrome, Ctrl+Option+E on a Mac and Alt+E on Windows or Linux will open the Edit menu.
Copying and pasting via the context (right click) menu in documents when you have the Chrome App installed.
Easily adding Google drawings or Google Groups discussions to a Google Site from the Insert menu.

Progress bars while uploading files to Google Sites.
Searching for text inside of PDFs in your documents list using Optical Character Recognition.

If you’d like to learn more about what we’ve been up to in January, I’ll be doing a Hangout On Air later this week this to talk about these changes and listen to your feedback. Stop by our Community Manager Teresa’s Google+ page on Thursday, February 9 at 12 p.m. EST to tune in.

Posted by: Jeff Harris, Product Manager

Updates to Google Docs app for Android: Offline access and improved tablet experience

2012-02-01T10:45:00.000-08:00

There may be times when you don’t have an Internet connection on your Android device, but you still want access to a file you’ve saved in Google Docs. Now you can select any file in Google Docs to make it available offline. So regardless of whether you’re connected to the internet, you’re always connected to those files.

Even better, Google Docs automatically updates your offline files when you’re on Wi-Fi. You can also manually update files anytime you have a data connection by opening the file or tapping ‘Update’ from the Offline section of the app.


Make file available offline	Update online file

Make file available offline

Update offline file

For those of you with Android tablets, we’ve also improved the Google Docs reading experience. Now, when you open a Google document on your tablet while online, you’ll get a high-resolution version of the document. Swipe left and right to flip between pages, or use the slider at the bottom to page ahead quickly.

New reading layout on Android tablet

You can learn more about offline capabilities and the new reading layout in our Help Center.

Whether you’re offline or online, these improvements will make it easier to be productive from anywhere.

Posted by: Freeman Liu, Software Engineer

Google Docs and Sites 2011: A Year in Review

2011-12-20T09:00:00.000-08:00

This year, we introduced over 100 new features to Google Docs to make creating, sharing, and collaborating in the cloud an even better experience.

In addition to the features you asked for the most, like page numbers and vertical merge, here are our team’s favorite improvements of 2011:

A new version of Google presentations with character-by-character collaboration - plus new transitions, animations, and themes
Comments in Google documents, followed by improvements including collapsible discussions, better email notifications, and a more detailed discussion pane
A Google Docs Android app available in 48 languages for searching, viewing, and sharing Google Docs on the go in 48 languages
Comment-only access in documents that allows others to view and comment on your doc without editing
Offline viewing for your documents and spreadsheets
Pivot tables in spreadsheets to process and summarize large data sets in seconds
Pagination in documents that provide visual page breaks on the screen
New printing options such as one-click CloudPrint from your mobile device
Page-level permissions in Google Sites for better control over who can view and edit your pages
Improved accessibility including new screen reader support and shortcuts that makes Google Docs more accessible and navigable for blind users
A new look across Google Docs and Sites for a more consistent web experience

Our team also loved hearing from you throughout the year: We had you ask us anything in a Reddit AMA, met our Docs and Sites Top Contributors, and held our first Docs Office Hours Google+ Hangout. Our interactions with you were constant reminders of why we build these products.

Let us know in the comments what your favorite features of 2011 were -- and what you’re wishing for in the new year. Thanks for following along -- we look forward to bringing you more in 2012.

Happy holidays from the Google Docs team!

Posted by: Jonathan Rochelle, Product Management Director

Create and celebrate with Google Docs templates for the holidays

2011-12-15T11:30:00.000-08:00

This season, brighten up your holiday celebrations with some of our fun and festive Google Docs templates.

If you’re hosting a gift exchange with your friends, family, or colleagues, try our new Secret Santa gift exchange template by following these instructions. This template will allow you to quickly send out a form to collect the necessary information from participating guests. Then, using a Google script, the form will assign Secret Santas and send automated emails to guests with all the details - no folded paper scraps necessary.

Here are a couple of other ways to make your holiday planning easier:

Have guests RSVP to your holiday soiree
Organize or budget for your shopping list
Create a sheet of customized gift tags or mailing labels

Browse the template gallery for more ideas, or submit and share your own templates for others to use. Wishing you the best this holiday season!

Posted by: Teresa Wu, Community Manager

College Tips by Google: A new site for students

2011-12-13T09:30:00.000-08:00

Are you applying to college, in the midst of your college years or getting ready for graduation? Wherever you are in your academic journey, Google has tips and tricks to help. Check out our new site, designed just for students, to learn how Google Docs and other Google products can help you stay on your A-game.

Posted by: David Kaufman, Cornell University ‘10 (Go Red!), Product Marketing Manager

Try Google presentations. No login required.

2011-12-09T09:00:00.000-08:00

We recently launched a new version of Google presentations with many new features to help you create beautiful presentations together. We’ve added the new editor to our Docs demos to make it easier to test drive your presentation building skills.

Check out the new animations and transitions, get artsy with drawings, and show off your masterpiece to a friend or colleague. You can share the link in the demo with others and work on the same presentation together. No login required. No Google account needed. Just go to docs.google.com/demo to take it for a spin.

The new Google presentations continues to gradually roll out to all users. You can try it in the demo and if you like it, you can enable it in your Docs settings.

Posted by: Sarah Cooper, User Experience Designer

Bringing the very best of what we do to the veteran community

2011-11-11T06:00:00.000-08:00

We believe that technology can be a force for good; one that builds and binds community. As a Googler, my proudest moments are when we take that technology and put it in the hands of people who can use it to communicate, collaborate, build and explore.

Today, on Veterans Day, I am proud to share a few Google tools and platforms for the military veteran community. They can be accessed on our website, Google for Veterans and Families, which was created by veterans and their family and friends, who work at Google. This single interface brings together Google products and platforms for servicemembers and their families. We believe it will be useful to all veterans, whether still in the service, transitioning out, or on a new path in their civilian lives. Here are some examples of what you’ll find on the site:

VetConnect - This tool helps servicemembers connect, communicate and share their experiences with others who have served using the Google+ platform.
Google Veterans Channel - A YouTube channel for discussion about military service for veterans, their families and the public. Veterans can share their experiences with each other as well as with civilians to help shed light on the importance and complexity of service. If you have not served, this is a great place to offer your thanks by uploading a tribute video.
Resume Builder powered by Google Docs - We found that Docs can be a particularly helpful tool to transitioning service members seeking employment. Resume Builder generates an auto-formatted resume that can be easily edited, saved and downloaded to share with potential employers.
Tour Builder powered by Google Earth (coming soon). A new way to tell your military story. Today, you can view some sample “tours”— 3D maps of veterans’ service histories, complete with photos and videos. Stay tuned for more details and updates on the Google Lat Long Blog.

It’s been a proud month for those of us here at Google who are veterans or family of veterans.

In October, 100 Googlers visited the Soldier and Family Assistance Center at West Point to conduct resume writing workshops for members of the Warrior Transition Unit. And, just two weeks ago, we traveled to Walter Reed National Military Medical Center to teach wounded, ill and injured service members how to use Google tools to stay in touch with their loved ones while in recovery.

Finally, this week, we introduced the Veterans Job Bank in partnership with the Department of Veterans Affairs. The Veterans Job Bank is a customized job search engine in the National Resource Directory (NRD), which is powered by Google Custom Search technology and crawls the web for JobPosting markup from Schema.org to identify veteran-committed job openings.

Even playing a small part to serve those who have served has been an honor.

Carrie Laureno, Audience Evangelist and Founder, Google Veterans Network

Cross-posted from the Official Google Blog

Faces of Docs: Vance Vagell, User Interface Software Engineer

2011-10-28T09:00:00.000-07:00

One of my favorite things about being the community manager on the Google Docs team is working alongside people with a myriad of backgrounds, interests, and talents. From learning of one of teammate’s pro cricket player past or another’s literary aspirations, I’m constantly discovering new things about the people I spend my workdays with. I thought you might enjoy reading about them, too--which is why we’re taking a cue from our friends at Gmail to bring you “Faces of Docs,” a series that will spotlight the people that make up our team.

Photo by: Antonella Pavese

Name:
Vance Vagell

What do you do on the Docs team and how long have you been at Google?
I lead a team of user experience (UX) prototypers. We build realistic-looking prototypes of new Google Docs features, so that our researchers can try them out with people. This lets us improve them before our engineers build the real thing. I’ve been here two years, but things move so quickly it may as well be 10.

What’s your typical day like?
I hop on the subway, read a few chapters of whatever sci-fi novel I’m working through (currently “Olympos” by Dan Simmons), and get to the office in about an hour.

Grab a coffee, then try to tackle my email inbox. Afterwards, I’m usually doing one of three things: building a prototype, preparing for a study, or running brainstorm and design sessions. My mind is usually at least one year in the future, although sometimes people force me to think about near-term problems.

What do you like most about what you do?
Watching someone enjoy a feature I’ve helped revise a few times—once we’ve finally gotten it right. I like being an advocate for what’s truly useful, and what people need. On the other hand, occasionally I get to work on bigger changes that help push technology in new directions, and that’s a blast too.

What’s the most challenging part of your role?
There are so many teams that want to see their ideas prototyped, that sometimes I have to put a few on the backburner. That said, we always prioritize, and then squeeze in a few “blue sky” projects so we keep moving forward and never get stuck in the status quo. We call a project “blue sky” when it’s unrealistic by today’s standards, but could be a great direction tomorrow.

What did you do before joining Google?
I’ve always worked in NYC—love the east coast (as I alienate myself from my west coast colleagues with this post). Started out as an indie game developer, then worked in voice technology for a few years. I was delighted to discover a posting for “User Interface Software Engineer” at Google NYC, and haven’t looked back since. I focus more on UX than engineering these days, but there’s an important intersection between the two that I represent.

What are the three Docs features you wouldn’t be able to live without?
Can I list ones that haven’t launched yet? Probably not. Okay, in that case: @-mentions in document comments that shoot off emails to people, Google Forms to quickly gather feedback, and real-time editing to bang out ideas as a group. These are all critical to my daily work.

What do you do when you’re not working on Docs?
Far too much computer gaming. Some of my favorites: Everquest (original and EQ2), Planetside, Eve Online, and City of Heroes.

Also love to go bird-watching. My favorite spot is Central Park. People are often surprised that you can spot over 20 bird species in a single afternoon there with a pair of binoculars. Did you know there’s a family of red-tailed hawks in the park that has reared several seasons of chicks now? Google “Pale Male”. On one outing, one of those hawks dove not more than a foot above my head to pick up a mouse beneath a tree across from me. Promptly carried it to a nearby branch and … dined. Very cool experience.

What kind of desk flair do you have?
Souvenirs from aquariums and zoos I’ve visited, and a photobooth print out of me and my partner at one of the Google NYC holiday parties. At last year’s, they had caricature artists, but I’m not ready to share that particular image of me yet. :)

What’s your pet peeve?
Apathy. Be passionate about something, and don’t be afraid to stand up for it.

What do you do in your downtime?
Between projects I like to catch up on UX blogs and papers. Some of my favorites are UX Matters, Jakob Nielsen’s Alertbox, and Don Norman’s essays.

What would your last meal be?
Definitely my partner Ray’s vegetable curry, it’s sublime, and you can’t beat home-cooked!

Posted by: Teresa Wu, Community Manager

Celebrating VisiCalc's 32nd birthday with the inventors of the spreadsheet

2011-10-21T12:30:00.000-07:00

On Wednesday, VisiCalc, the first spreadsheet available for personal computers, turned 32. We invited its inventors, Dan Bricklin and Bob Frankston, to Hangout On Air with us to celebrate a product that’s paved the way for much of what the Google Docs team has been able to do today.

Users around the world tuned in to our live public stream as Dan and Bob shared the history of VisiCalc, their thoughts the spreadsheets of today, and their visions for the future. Watch the full video below.

And for you spreadsheets fanatics out there -- you can download and run a working copy of the original IBM PC VisiCalc spreadsheet program from 1981 at Dan Bricklin’s site.

Posted by: Teresa Wu, Community Manager

Another nonprofit shares its Google Sites story

2011-10-20T08:12:00.000-07:00

Last week we told you about Children’s Radio Foundation using Google Docs to act like a file server for their organization. This week, we’re talking about another nonprofit, Grassroot Soccer, that uses Google Sites to host files for their organization. Learn more on the Google's Nonprofit blog.

Posted by: Carolyn Wendell, Consumer Experience Specialist

A fresh start for Google presentations

2011-10-18T08:00:00.000-07:00

A year and a half ago, we released completely new document, spreadsheet and drawing editors. Google Docs has been picking up speed ever since with more than 60 new features and millions of new users. Today we’re rounding out the suite by previewing a new version of presentations with faster collaboration and more features.

A collaborative approach
Presentations are made to be shared—whether it’s presenting your thesis to your professors or inspiring colleagues at a conference. And the best presentations are made together, collaborating with others to build a compelling story that captivates your audience. Creating presentations together is easy because you can:

See exactly what others are working on with colorful presence markers
Edit with your team members simultaneously from different locations
Use revision history to see who made changes or to revert to earlier versions
Say hello, start a conversation or share new ideas using built-in chat

More than 50 new features
In the new presentations, we’ve added many of your most requested features, including:

Transitions to move between slides with simple fades or spicier 3D effects
Animations to add emphasis or to make your slides more playful
New themes to create beautiful presentations with distinct visual styles
Drawings to build new designs, layouts, and flowcharts within a presentation
Rich tables with merged cells and more options for adding style to your data

What’s next
We’re gradually rolling out the new presentations. To get an early start, click on the gear icon in your document list, and select Document settings. Then, from the editing tab, check the box to “Create new presentations using the latest version of the presentation editor.” Learn more about getting started with the new presentation editor over at our Help Center.

Many of the new features were built using technologies that are only available in modern browsers. If you’re using an older browser you’ll be able to view, but not edit, the new presentations.

With today’s launch, the Google Docs suite is now built on a single, solid foundation. Now that the groundwork is in place, you can expect more useful and collaborative features, delivered faster than ever before.

Posted by: Steven Saviano, Software Engineer

South African nonprofit benefits from Google Docs and Sites

2011-10-11T11:00:00.000-07:00

We recently met with two nonprofits to learn more about how they use Google Docs and Sites to better manage and share files across their organizations. Today, we're sharing the story of Children Radio's Foundation (CRF), a nonprofit organization based in South Africa. Tom Henry, a CRF volunteer, sits down with the Google for Nonprofits team and tells us why collections and sharing are two of his favorite features in Google Docs. Learn more on Google's Nonprofit Blog.

Posted by: Carolyn Wendell, Consumer Experience Specialist

An enhanced Google Docs experience on mobile tablets

2011-10-05T09:45:00.000-07:00

Earlier this year, we introduced the Google Docs app for Android. Since then, many users have downloaded the app and enjoyed the benefits of being able to access, edit and share docs on the go.

Today’s update to the app makes Google Docs work better than ever on your tablet. With an entirely new design, we’ve customized the look to make the most of the larger screen space on tablets. The layout includes a three-panel view, which allows you to navigate through filters and collections, view your document list, and see document details, all at once.

Looking at the details panel on the right side, you can see a thumbnail to preview a document and its details before opening it. From the panel, you can see who can view or edit any doc.

New 3-panel view for improved browsing

Autocomplete makes sharing with others on the go even easier

These features are now available in 46 languages on tablet devices with Android 3.0+ (Honeycomb) and above.

You can download the app from the Android Market and let us know what you think in the comments or by posting on the forum. Learn more by visiting the help center.

Posted by: David Loxton, Product Manager

Experience the new look of Docs and Sites

2011-10-03T09:59:00.000-07:00

Starting today, we’re rolling out the new design for Google Docs and Sites to everyone.

We began rolling out these improvements in early August with the documents list and have since upgraded our entire collaboration suite. You may have noticed that our new look matches other recent Google visual updates, which aim to bring a consistent, improved experience across our products.

Your content is what’s important, and we aim to highlight it with this new design. You’ll see clean menus and toolbars, prominent action buttons, and colorful presence that pops when you’re editing with others.

To people who opted-in to try the new look — thank you. Based on your feedback, here are some of the improvements we made:

We made it clearer that your document is always saved, by showing “Saving...” right after you make a change and then “All changes saved” once it’s fully saved.

We added an icon to the Share button so you can tell if your document is shared at a glance.

If you’re looking for options that were previously under the Share button (e.g. “Email as attachment...”), you can now find these in the File menu.

By default, the documents list automatically fits a comfortable number of documents on your screen (large desktop monitors show more, smaller laptop screens show fewer). We also added density options to give you more control:

If you’re not quite ready for the new look, choose Help > Use the classic look (or in the gear menu, for some products). We’ll support the classic look for at least a few more weeks, but encourage you to use the new look, get settled in, and send us any feedback you have.

We hope you enjoy this refreshed experience.

Posted by: Vance Vagell, User Interface Software Engineer

Visualize your data with charts in Google Sites

2011-09-28T06:04:00.000-07:00

Ever since we launched the chart editor in Google spreadsheets, many of you have asked us to integrate charts into Google Sites as well. Today we are making this possible. Now you can display charts in your Sites by going to Insert Menu and choosing Charts in edit mode.

Once you select a spreadsheet, the editor picks existing charts from the spreadsheet to embed into a Site.

You can also create a chart by specifying the sheet and range and customize the chart by changing various properties such as color, axes, labels and more. Choose which chart type best expresses your data or let the chart editor recommend one for you.

You can decide to choose between two modes Live and Snapshot to show the data.

Live provides you with dynamic charts. Whenever the chart is loaded in the Site, the chart will display the most recent data in the spreadsheet. This is very useful in cases when the spreadsheet data is updated manually or using a script.

Snapshot means just that. It’s a snapshot at a point in time, so the chart will store and display the exact same data, regardless of whether you make changes to the underlying data sheet.

Changes made to charts in Sites are independent to the specific chart, so the same spreadsheet data can be applied across multiple charts.

To learn more about how to express your data more visually with Sites, visit the help center. Be sure to let us know what you think in the comments.

Posted by: Hillel Maoz, Software Engineer

Trying on the new Dynamic Views from Blogger

2011-09-27T15:08:00.000-07:00

As you may have noticed, the Docs blog looks a lot different today. That’s because we—along with a few other Google blogs—are trying out a new set of Blogger templates called Dynamic Views.

Launched today, Dynamic Views is a unique browsing experience that makes it easier and faster for readers to explore blogs in interactive ways. We’re using the Classic view, but you can also preview this blog in any of the other six new views by using the view selection bar at the top left of the screen.

We’re eager to hear what you think about the new Dynamic Views. You can submit feedback using the “Send feedback” link on the bottom right of this page.

If you like what you see here, and we hope you do, we encourage you to try out the new look(s) on your own blog—read the Blogger Buzz post for more info.

Posted by Meredith Blackwell, Google Docs Marketing Manager

This week in Docs: Import/export and paste special improvements

2011-09-22T08:04:00.000-07:00

Yesterday, we announced the vertical merge feature in Google spreadsheets, and today we’re happy to share two new features that we hope will make analyzing data a little more efficient.

More import and export support in Google spreadsheets
Now you can convert most pivot tables between Microsoft Excel files and Google spreadsheets for powerful data analysis in whatever file format you prefer. Additionally, filters that help you better visualize and organize your data are now supported in our import and export conversion tools.

To import a pivot table you created in Microsoft Excel, click the File menu in Google spreadsheets, and select import, then select the file from the import options, and click the import button. If you’ve created a pivot table in Google spreadsheets, go to File in the spreadsheet, then click Download As, and choose Excel.

More paste special options in Google spreadsheets
Sometimes you need to copy data in cells that have lots of formatting and formulas, but you don’t always want to paste everything in the cell. For instance, you may want to copy and paste the data in a range of cells, but not the borders that you placed around the cells.

We’ve added four new paste special options including: paste all cell contents except borders, formulas only, data validation only, or conditional formatting only. You can find these new options in a list under “Paste Special” in the Edit menu of Google spreadsheets.

We hope these latest features make working with Google spreadsheets more efficient and productive. As always, let us know what you think in the forum or in the comments.

Posted by: Dan Gundrum, Product Manager

Merge cells vertically in Google spreadsheets

2011-09-21T10:05:00.000-07:00

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 today, we’ve extended the merge functionality to let you create vertical merges across several rows of data.

In the spirit of the NFL season, let’s say you want to host a football tournament for your friends. To make it easier for them to cast their votes on the winning team, you organize the NFL teams by conference and division in a Google spreadsheet. Using vertical merges, you can assign headers to sets of rows. Simply select the set of cells you’d like to merge, then click on the down arrow next to the merge icon, and select Merge vertically.

In the NFL spreadsheet, you’ll see that some of the team names don’t fit on one line in the width of the cells of Column C.

To improve the formatting, select the cells across all the rows of teams in the AFC (rows 2-17) and 2 columns (C and D) and click Merge horizontally. You’ll have 16 merged cells that span 2 columns for better formatting.

After applying vertical merges to all of the conference and division headers and horizontal merges across the team names in each conference, you’re ready to share with your friends for the tournament!

To undo a merge action, select a merged cell and click Unmerge in the drop-down menu.

We hope you enjoy customizing the formatting of your spreadsheets with this feature. Let us know what you think in the comments.

Posted by: Jakov Krolo, Software Engineer Intern

+1 button in Google Sites

2011-09-15T09:21:00.000-07:00

We have been thrilled with the response to the launch of the +1 button on websites all across the web, but we also heard that you’d like a simple way to add the +1 button to your own Google Sites. Adding the +1 button to your site will allow your visitors to recommend it to their friends and contacts, which helps more people discover it via their personalized search results.

Starting today, you can add the +1 button to any individual page by choosing +1 Button from the Insert menu, or you can add it to your site’s sidebar and have it appear on every page instantly by editing your Site Layout under Manage Site.

Try it out and let us know what you think in the forum.

Posted by: Michael Verrilli, Software Engineer

Improved Accessibility in Google Docs and Sites

2011-09-13T18:54:00.000-07:00

Today we announced some of the updates we’ve released recently to make Google’s applications more accessible to the blind community. For Google Docs and Sites, we’re pleased to announce new keyboard shortcuts and better screen reader support for our blind users.

Screen reader support in Google Docs and Sites
To help blind users read, edit and navigate content, Google Docs (including documents list, documents and spreadsheets) and Sites now support two screen readers: JAWS and ChromeVox. Here are a few examples of how screen readers work in Google Docs and Sites:

In documents, you’ll hear feedback when you format text or insert tables, lists or comments in your document.
In spreadsheets, you’ll hear the cell’s location, contents and comments when moving between cells.
In both documents and spreadsheets, you’ll hear feedback as you navigate to areas outside the main content area, such as the menu bar, chat pane and dialog boxes.
In your documents list, you’ll hear feedback when you upload or download a file, organize collections or move between files in your documents list.
In Sites, you’ll hear feedback as you navigate and manage your sites, create and edit pages, and navigate through menus and dialog boxes.

For a complete list of screen reader-supported features and instructions for how to use them, visit the Docs and Sites help centers.

New keyboard shortcuts
We’ve also added new keyboard shortcuts to make it easier to use Google Docs and Sites. In your documents list, for example, you can use the up and down arrow keys to move through the files in the list, and you can open the selected document by hitting Enter. For a complete list of keyboard shortcuts, please refer to the help center articles for spreadsheets, documents, documents list and Sites.

With these new accessibility features, we hope to make it easier for everyone to use Google Docs and Sites. Please use this form to share your feedback directly with the accessibility team so we can continue to improve our products.

Posted by: Jeff Harris, Product Manager

This week in Docs: Format painter, Google Fusion Tables, and drag & drop images

2011-09-13T10:09:00.000-07:00

This week in Docs, we’re introducing three new tools that put the fun in functional.

Format painter in Google documents

First, we’ve added a format painter to help you copy formatting within Google documents. The new format painter allows you to copy the style of your text, including font, size, color and other formatting options and apply it somewhere else in your document. To use the format painter, select the text for the formatting you want to copy, press the paintbrush button in your toolbar, and then select the text where you want to apply that formatting.

If you double-click on the format painter icon, you’ll enter a mode that lets you select multiple sections of text so you can apply the same formatting to each section.

You can also use keyboard shortcuts for format painting. To copy the style of your selected text, press Ctrl+Option+C for Mac or Ctrl+Alt+C for Windows. To apply any copied styles to whatever text you have selected, press Ctrl+Option+V for Mac or Ctrl+Alt+V for Windows.

Google Fusion Tables in documents list

With this week’s update, we’re also integrating Google Fusion Tables into your documents list. Google Fusion Tables is a data management web application that makes it easy to gather, visualize and collaborate on data online. Now you’ll be able to store and share your Fusion Tables with the rest of the files in your documents list.

Recently, people have used Google Fusion Tables to:

Visualize evacuation zones for New York City during Hurricane Irene
Host data sets made public by the State of California
Gather data from local flu shot clinics for Google Flu Vaccine Finder
Map shelters and road status during the tsunami crisis in Japan

Go to Create new > Table from your documents list menu to get started visualizing or sharing tables of data in .csv, .xls or .kml files.

We're working on making Google Fusion Tables available to Google Apps customers and will let you know as soon as they are. Take a tour to learn more about Google Fusion Tables.

Drag & drop images in Google drawings

We also made it easier to add images from your desktop to Google drawings. If you’re using the latest version of Chrome, Safari, or Firefox, you can now drag an image from your desktop and drop it directly in the drawing canvas.

Give these tools a try and let us know what you think in the comments.

Posted by: Micah Lemonick, Software Engineer

Updated 9/13 to add shortcuts for Windows

Comment-only access in Google documents

2011-09-12T09:00:00.000-07:00

In the past several months, we’ve added new discussion and commenting features to improve collaboration in Google documents. As an engineer, I often create docs with design concepts and send them to my team to review and provide feedback, and we use the commenting features to facilitate these discussions. Sometimes, I want to let team members view and make comments without allowing them to directly edit my document.

Over the next several days, we're releasing a new sharing option so that you can let people view and add comments to your documents without giving them edit access. To give comment-only access to your document, click on the Share button. From there, add in the contact you’d like to share your document with, and select Can comment.

You can also choose to give comment-only access to anyone with the link or anyone on the web by changing the sharing settings within the document. To do this, click Change in the sharing settings window and change visibility options to Public on the web or Anyone with the link, then change the access options to Can comment.

Similarly, if you’re using a Google Apps account, click Change in the sharing settings and select either “People at [your domain] who have the link can access” or “People at [your domain] can find and access.” Then change access option to Can comment.

Users that have comment-only access can view your document and add comments throughout -- without being able to change the content of the document directly.

We hope this latest feature in discussions helps you get the feedback you need while providing you with more control over the content in your docs. So comment away and tell us what you think -- below or in the forum.

Posted by: Sarah Wu, Software Engineer

What Happened Wednesday

2011-09-09T08:16:00.000-07:00

Not our best week. On Wednesday we had an outage that lasted one hour and meant that document lists, documents, drawings and Apps Scripts were inaccessible for the majority of our users. We use Google Docs ourselves every day, so we feel your pain and are very sorry.

So what happened? The outage was caused by a change designed to improve real time collaboration within the document list. Unfortunately this change exposed a memory management bug which was only evident under heavy usage.

Every time a Google Doc is modified, a machine looks up the servers that need to be updated. Due to the memory management bug, the lookup machines didn’t recycle their memory properly after each lookup, causing them to eventually run out of memory and restart. While they restarted, their load was picked up by the remaining lookup machines - making them run out of memory even faster. This meant that eventually the servers couldn’t properly process a large fraction of the requests to access document lists, documents, drawings, and scripts which led to the outage you saw on Wednesday.

Our automated monitoring noticed that attempts to access documents were failing at an increased rate, and alerted us 60 seconds later after the failure rate increased sharply. The engineering teams diagnosed the problem, determined that it was correlated with the feature change, and started rolling it back 23 minutes after the first alert. In parallel, we doubled the capacity of the lookup service to mitigate the impact of the memory management bug. The rollback completed 24 minutes later, and 5 minutes after that the outage was effectively over as the additional capacity restored normal function.

Since resolution, we have been assembling and scrutinizing the timeline of this event, and have assembled a list of steps which will both reduce the chance of a future event, decrease the time required to notice and resolve a problem, and limit the scope which any single problem can affect. We intend to take all these steps; some are not easy, but we're committed to keeping Google's services exceptionally reliable. In the meantime, rest assured that we take every outage very very seriously, and as always we'll post a full incident report of what happened to the Apps Dashboard once our investigation is complete. Again, we apologize for the inconvenience and frustration which the outage has caused.

Posted by: Alan Warren, Engineering Director

Tips & Tricks: Using the new Subtotal function in Google spreadsheets

2011-09-01T11:30:00.000-07:00

This week, we added the Subtotal function to our list of functions in Google spreadsheets. One of the benefits of the Subtotal function is that it works well with AutoFilters by only using unfiltered data when performing calculations (other functions such as Sum include filtered data calculations). Subtotal also lets you change what function you’re performing on those values very quickly, by selecting an item from a drop-down list. See our help article for details.

This versatile function is often used by accountants, finance professionals, and business consultants. It can also be extremely convenient for any user -- let’s show you why.

Say that you’re helping to plan your family’s annual Labor Day beach weekend. You want to decide how many hot dogs and veggie dogs to buy. To figure this out, you create a Google spreadsheet that includes all your family members, their meat preferences, and the number of hot dogs everyone ate at the past several family gatherings:

To quickly count how many veggie dogs you need to buy based off the number of veggie dogs eaten last month, add a filter to the columns , sort to “Yes” only in Column C, and type in this Subtotal function underneath the table:

=SUBTOTAL(109, F2:F14)

Cells F2 through F14 show the number of hot dogs each family member ate last month. “109” is the code that references the Sum function (“9” would also work). Typing in a regular Sum function in this case (=SUM(F2:F14)) would have added all dogs, veggie or not, whereas Subtotal ignores hodogs which have been filtered.

Another neat feature of the Subtotal function is that the function code (such as “109” above) can easily be changed to refer to different operations like Average, Minimum, and Maximum. As a result, Subtotal can be used to condense a number of calculations into a small space.

Let’s say you want to see not only the total number of hot dogs eaten each summer month, but also the average number eaten. Rather than creating two different functions (Sum and Average) for each month, you can use Subtotal.

In an open cell -- let’s use B15 -- you would create a drop-down list with the codes for the Sum and Average function (109 and 101 respectively).
And under the column for each month, you would write a Subtotal function, but reference cell B15 instead of typing in a code.

For June, therefore, your function would read: =SUBTOTAL(B15, D2:D14)

Every time you change which code appears in cell B15 through the drop-down, the values under each month will change, showing either the total or the average number of hot dogs eaten by your family with just one click.

We hope the Subtotal function makes your data analysis a lot easier -- and maybe even more fun.

Posted by: Lai Kwan Wong, Software Engineer

Access Google Docs with FedEx Office Print Online

2011-08-31T11:00:00.000-07:00

With Google Docs, you have instant access to your files anytime -- whether you’re at the office on your desktop, on the go with your mobile phone, or at home on your laptop.

When you need to print your documents from anywhere, FedEx Office® is now making it even easier with a Google Docs feature. With FedEx Office Print Online, you can upload and access your Google Docs directly from their site, choose what file types to print and customize your printing options. Once you’ve completed your order, you can choose to pick up the prints at a local FedEx Office retail location or have them delivered right to your door.

So whether you’re creating brochures for your business or a mid-term project to share with classmates, the power of the web helps you access your files from anywhere and even get them into your hands, literally.

Posted by: Teresa Wu, Community Manager