This week in Docs and Sites: A spreadsheets shortcuts menu, PPTX support and more

This week, we’re introducing a number of enhancements to Google Docs and Sites: a spreadsheets shortcuts menu, support for PPTX conversion, a new RSS gadget, and improved mobile rendering for Sites.

Spreadsheets shortcuts
Although shortcuts have long been available in your Google spreadsheets, we've added a shortcuts menu to spreadsheets to make them easier to find -- saving you even more time. Hit Ctrl+/ (or Cmd+/ on a Mac) to pull up the list of shortcuts and learn new ways to sharpen your spreadsheet skills. Remember that shortcuts can vary depend on the operating system and browser you're using -- the example below is the menu you’d see if you were using a Chrome browser on a Mac.


Support for conversion of PPTX files to Google presentations
Starting today, you can convert PPTX files to Google presentations by either uploading the file from your desktop or converting the file from your documents list. Just follow the same simple steps as you normally would when converting files to Google Docs formats.

Better customization for your RSS Gadget in Sites
We’ve also added a new RSS gadget for Google Sites to our “Featured” gallery.


The new RSS gadget gives you complete control over the appearance of the gadget: You can customize any aspect of the feed, including font, color, size, number of items to display, and post length.

To set your gadget, go to Insert > More Gadgets > Featured, and look for RSS Feed.


Improved mobile rendering
After we released our initial version of Google Sites automatic mobile rendering, you enabled the option for over 50,000 sites, making it clear that you’re looking for a better way to easily publish content for mobile devices.

Based on what you’ve told us, we’re adding the additional behaviors to make automatic mobile rendering on Google Sites even better, including:

• Images and header logos automatically scale in mobile mode
• Gadgets and text boxes have widths that fit mobile devices
• Pages with multi-column layouts stack columns vertically on mobile

Before

After

Thanks for continuing to let us know what you think about our products -- these changes wouldn’t be possible without you.

Posted by: Rajiv Bammi, Software Engineer

ZIP and RAR support now available in the Google Docs Viewer

Downloading files that you only need to preview can create unnecessary clutter on your computer. While you can already use the Google Docs Viewer to view over 15 different file types without downloading them, today we’ve added support for archive file types ZIP and RAR. Now, if someone sends you a ZIP or RAR file in Gmail, you’ll be able to view its contents from within your browser by clicking on View.


This will bring up a view that includes all of the files in the archive, the file types, and the size of those files.


When you hover over the list you can activate a menu by clicking Actions. You’ll be able to View items supported by Google Docs Viewer and Print (PDF) those that we offer PDF support. Save to Google Docs and Download appear for all files.


ZIP and RAR archives that are embedded inside other archives also work. For example, if you have a RAR file inside a ZIP file (like in our example above) you can just click on that file to access the embedded archive.

Go ahead and try the feature by viewing a ZIP file.

This feature extends to Google Docs for mobile, too. For each viewable file (including embedded ZIP or RAR archives) there is a link to view.



We hope this removes the need to download full archives when you only need to work on select items. We’re always adding more file types to the Google Docs Viewer -- let us know what file types you’d like to see support for next in the forums.

Posted by: Avner Aviad, Google Docs Viewer team

The Google Docs Help Center gets a makeover

As Google Docs has developed over the last five years, the Google Docs Help Center has also grown to help you learn how to use hundreds of Google Docs features. With new features and articles being added regularly, however, the help center became hard to navigate, making it difficult to find useful help articles. Today, we’re happy to announce an entirely new help center structure that we’ve worked on for the last few months.

The Google Docs Help Center used to be divided by each individual Google Docs editor. But we've since found that presenting help articles by your intent is more helpful. We hope that this will cut down the time it takes you to find the article you're looking for, make it much easier to find that content, and help you learn about the power of Google Docs.

Here’s a look at the new categories you’ll find on the help center homepage:

• Get started: Information about documents, spreadsheets, and more for new Google Docs users.


• Work in Google Docs: Home to all help articles on editing and formatting, including content about Google documents and spreadsheets.


• Manage, upload, and export: All help articles that were previously categorized as "Documents List." Here, you'll find information about file management, uploading and exporting, and Google Cloud Connect.


• Share, publish, and embed: Information about sharing and publishing all in one place, since sharing is exactly the same no matter which type of doc you're working in.


• Accounts, abuse, and privacy: Home to help articles about your Google Account, Google Docs settings, reporting abuse, and privacy policies.


• Mobile: All help articles that relate to working in Google Docs on a mobile device.


• Template gallery: Information about how to navigate the template gallery, use and submit templates, and report inappropriate templates.


• Fix a problem: Houses information about known issues and how to solve a problem.

In the coming weeks, look out for more design and layout changes that will make your help center experience even better. Combined with the new help center organization, we hope that these ongoing design changes will make your learning experience in the help center more enjoyable, efficient, and useful.

Posted by: Julia Harter, Content and User Education Specialist

Our response to your Product Ideas

Recently we opened our Product Ideas page to gather your feedback about what you’d like to see next in Google Docs. Over a two-week period, nearly 4,000 of you participated, submitting close to 2,000 ideas and casting over 50,000 votes.

Our request for feedback was designed to help us better prioritize the features you want most in Google Docs. We'll be sure to let you know as we roll out new features based on your valuable input. Here are just a few of the top ideas that we’re prioritizing:

• Add better header and footer functionality
• Make Google Docs available offline
• Create vertical merge in spreadsheets

There were many other great ideas - from making Google Docs available as attachments in Gmail to allowing the use of Google Fonts across all Google Docs tools. While we can’t get started on these requests just yet, we’ll be sure to keep them in mind for future improvements.

Thanks to all who participated in our Product Ideas page! We enjoyed reading your product suggestions and look forward to sharing our progress as we move forward with the your ideas.

Posted by: Posted by: Teresa Wu, Community Manager

Hats off to the winners of the inaugural Google Science Fair

Cross-posted on the Official Google Blog

Yesterday, our top 15 Google Science Fair finalists descended on Google’s headquarters and wowed our luminary judges—as well as more than 1,000 local attendees plus Googlers who stopped by to check out the action. Our exhibit hall was buzzing with energy and excitement as everyone wondered which young scientists would go home with our top prizes.

The results are in—and this year was all about girl power. Our top three winners by age category are:

• Lauren Hodge in the 13-14 age group. Lauren studied the effect of different marinades on the level of potentially harmful carcinogens in grilled chicken.
• Naomi Shah in the 15-16 age group. Naomi endeavored to prove that making changes to indoor environments that improve indoor air quality can reduce people’s reliance on asthma medications.
• Shree Bose in the 17-18 age group. Shree discovered a way to improve ovarian cancer treatment for patients when they have built up a resistance to certain chemotherapy drugs.

Winners (from left to right): Lauren Hodge, Shree Bose, Naomi Shah

We also awarded one Grand Prize and the Grand Prize Winner is...Shree Bose; congratulations!

Our judges said the unifying elements of all three young women were their intellectual curiosity, their tenaciousness and their ambition to use science to find solutions to big problems. They examined complex problems and found both simple solutions that can be implemented by the general public—like changing your cooking habits or removing toxins from your home—as well as more complex solutions that can be addressed in labs by doctors and researchers, such as Shree’s groundbreaking discovery, which could have wider implications for cancer research.

The winners took home prizes furnished by Google and our partners CERN, LEGO and National Geographic. Shree received a $50,000 scholarship, a trip to the Galápagos Islands with a National Geographic Explorer and aninternship at CERN. Naomi and Lauren each received $25,000 scholarships and internships at Google and LEGO. All three were awarded lifetime digital subscriptions to Scientific American. Beyond the grand prizes, everyone went home with some pretty cool loot, along with plenty of photos and memories that we hope will last a lifetime. If you’d like to watch last night’s events, including a speech from our chairman, Eric Schmidt, and presentations from judges Dean Kamen and Tierney Thys, you can find video on our YouTube channel.

On behalf of Google, our partners and science lovers everywhere, we’d like to thank all of our finalists and everyone who submitted a project to the inaugural Google Science Fair. We are humbled by your ingenuity, your dedication and your skill. We are heartened to know that our future is in the capable hands of our young scientists—young men and women who tackle big ideas to bring significant, actionable change to the world.

If you’d like information about next year’s Google Science Fair, let us know and we’ll be in touch soon, or keep an eye on the Google Science Fair site for regular updates.

Posted by: Cristin Frodella, Google Education Team

Tonight, watch the Google Science Fair final event live

Cross posted on the Official Google Blog and the Google Students Blog

The young scientists of the world have proven themselves truly impressive people—inventing technologies to improve the accuracy of prosthetic devices, developing video-audio memory aids for dementia patients and improving switch designs to prevent train derailments. These are just three of the top 15 projects competing for the grand prize in the inaugural Google Science Fair final tonight, which we’ll be live streaming at 7pm PDT at youtube.com/googlesciencefair.

Back in January, we launched the first Google Science Fair in partnership with CERN, LEGO, National Geographic and Scientific American. We asked young people from ages 13-18 all over the world to submit projects online that were creative, inspiring and groundbreaking. Ten thousand students from 91 countries submitted 7,500 projects, from which our international team of judges selected the top 15 finalists.

Today, those finalists are at Google headquarters in Mountain View, Calif. where they’ll present their projects to a panel of science luminaries, inventors and Nobel laureates. The winners will receive amazing prizes including $100,000 in scholarships, internships at Google or our partners and a National Geographic Expedition to the Galápagos Islands.

So pull up a chair in your home laboratory and tune in to a live stream of the first Google Science Fair to find out which budding young Einstein will take home the grand prize. The event begins tonight, Monday July 11, at 7pm PDT—watch at youtube.com/googlesciencefair.

Posted by: Cristin Frodella, Google Education Team

This week in Docs: New features for your Google Docs videos

Beginning this week, you’ll be able to go beyond simply playing your videos within Google Docs -- you can now insert your videos into Google Sites, embed them anywhere on the web, and caption them for your viewers.

Embed videos in Google Sites
While on your Google site, go to the Insert menu and select Video > Google Docs Video.


From there, choose from the videos that are in your documents list and click Select to insert the video into your Google site.

Embed videos on the web
You can embed your videos anywhere else on the web by using the HTML snippet that is now available on the video’s page. Keep in mind that whether you’re embedding your video into your Google site or somewhere else on the web, only people to whom you’ve given access will be able to view the video. For example, if the video is set to private and shared with four people, only those four people will be able to view it on your Google site.


Add captions to your videos
You can also caption your videos to make them accessible for deaf and hard of hearing viewers or for speakers of different languages. You can find these videos more easily by searching for any text in the transcript of the video from your documents list. (Only people to whom you’ve given access to the video can find the video using this method.)



To give it a try, choose Manage caption tracks from the Actions menu for your video, then click Upload caption track... Anyone who has edit access can upload a track.

Let us know what you think of these new features by leaving us a comment -- or better yet, a video.

Posted by: Patrick Lacz, Software Engineer

Share your docs on the go with the improved Google Docs for mobile

Google Docs is about collaboration, but as many of us know, others often rely on us even when we’re nowhere near a computer. That’s why we’re excited to bring the features you need to your tablet and mobile device’s browser. Today, we've updated the look of Google Docs for mobile browsers and added the ability to sort, narrow, and share multiple docs in your mobile docs list.

To get started, go to docs.google.com from your supported device’s browser. Press Sort to organize the list of docs visible in the mobile browser, or press Narrow by to specify the subset of docs you’d like to see.


To share from your mobile docs list, select one or more documents, press the Share button, and select Share, Get the link to share for public or unlisted docs, or Email as attachment. Sharing a doc in your mobile browser works the same way as it does on the desktop.


We’re committed to improving the experience of accessing your docs from your mobile device. We’d love to hear what you think is working and what isn’t in our support forums as well as in the comments of this post.

Posted by: Hossein Attar, Software Engineer