Tag Archives: Google Sheets

Improving the menus in Google Docs editors

Based on usage data and your feedback, we’re making some changes to the menus in the web versions of the Google Docs editors. These are similar to the changes we made in December and in January and will make it easier to find certain items.

Changes that affect all Docs editors menus (including Google Docs, Slides, and Sheets):
  • In the Tools menu, “Spelling” will be renamed “Check Spelling.”
  • In the Edit menu, “Select none” will be removed. 
  • Items in the File, Edit, and Tools menus will be reordered. 


Changes that only affect Google Sheets menus:
  • In the Data menu, “Filter” will be renamed “Create a filter.”
  • In the Data menu, “Validation” will be renamed “Data validation.”
  • Items in the Data menu will be reordered. 
  • Items in the Format menu will be reordered. 


These changes will only affect the visual menu on the web version of these products. All options will still be available via keyboard shortcuts and the search box in the Help menu.


Launch Details
Release track:
Launching to Rapid Release, with Scheduled Release coming in two weeks

Editions:
Available to all G Suite editions

Rollout pace:
Extended rollout (potentially longer than 15 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Keyboard shortcuts for Google Docs
Help Center: Keyboard shortcuts for Google Sheets
Help Center: Docs editors homepage


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Improved accessibility for Google Sheets, Slides, and Drawings

We want to make sure our products work well for everyone. That’s why, as part of our ongoing accessibility initiatives, we’re launching new features for Google Sheets, Slides, and Drawings. Specifically, we’re adding Braille support in Google Sheets, and screen magnifier support in Google Slides and Drawings.

Use Google Sheets with Braille displays

You can already use Braille displays to read and edit text in Docs, Slides and Drawings. Now we’re adding Braille support to Sheets as well. You’ll be able to use a Braille display to read and edit cell contents as well as navigate between cells in a sheet. At the moment, Braille support in Sheets will only be available on Chrome OS with the ChromeVox screen reader. We’re working to add support for other platforms and screen readers.

See our Help Center to find out how to use a Braille display with Sheets.

Use screen magnifiers with Google Slides and Drawings

We recently added screen magnifier support to Docs and Sheets. Now screen magnifiers will also work with Slides and Drawings.

You can use screen magnifiers with Docs, Sheets, Slides, and Drawings on Mac and Chrome OS devices. See our Help Center to learn how to use screen magnifiers with Google Docs editors.

Launch Details

Release track:
Launching to both Rapid Release and Scheduled Release

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (up to 15 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information


Help Center: Accessibility for Docs editors 
Help Center: Use a Braille display to read & enter text


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Improved accessibility for Google Sheets, Slides, and Drawings

We want to make sure our products work well for everyone. That’s why, as part of our ongoing accessibility initiatives, we’re launching new features for Google Sheets, Slides, and Drawings. Specifically, we’re adding Braille support in Google Sheets, and screen magnifier support in Google Slides and Drawings.

Use Google Sheets with Braille displays

You can already use Braille displays to read and edit text in Docs, Slides and Drawings. Now we’re adding Braille support to Sheets as well. You’ll be able to use a Braille display to read and edit cell contents as well as navigate between cells in a sheet. At the moment, Braille support in Sheets will only be available on Chrome OS with the ChromeVox screen reader. We’re working to add support for other platforms and screen readers.

See our Help Center to find out how to use a Braille display with Sheets.

Use screen magnifiers with Google Slides and Drawings

We recently added screen magnifier support to Docs and Sheets. Now screen magnifiers will also work with Slides and Drawings.

You can use screen magnifiers with Docs, Sheets, Slides, and Drawings on Mac and Chrome OS devices. See our Help Center to learn how to use screen magnifiers with Google Docs editors.

Launch Details

Release track:
Launching to both Rapid Release and Scheduled Release

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (up to 15 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information


Help Center: Accessibility for Docs editors 
Help Center: Use a Braille display to read & enter text


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

New categories and languages for templates in Google Docs, Sheets, and Slides

We know how valuable templates can be to a company—they save employees’ precious time, ensure that their work product looks professional, and increase brand consistency across their materials. That’s why we’ve spent the last several months working with partner experts to develop templates in four new categories:

1. Project Management in Sheets, in partnership with Smartsheet



2. Sales in Docs, in partnership with PandaDoc



3. Human Resources (HR) in Docs, in partnership with Zenefits



4. Freelancer Engagement in Docs, in partnership with Upwork



At the moment, these templates are only available in English and on the web.

While the new templates above are English only, our existing templates are now available in several additional languages, including Hindi (hi), German (de), Indonesian (in), Japanese (ja), Dutch (nl), and Chinese (zh-CN). These localized templates will be available in Docs, Sheets, and Slides on the web.

Launch Details
Release track:
Launching to both Rapid Release and Scheduled Release

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Create a file from a template


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Pivot to the cloud: intelligent features in Google Sheets help businesses uncover insights

(Cross-posted from The Keyword)

When it comes to data in spreadsheets, deciphering meaningful insights can be a challenge whether you’re a spreadsheet guru or data analytics pro. But thanks to advances in the cloud and artificial intelligence, you can instantly uncover insights and empower everyone in your organization—not just those with technical or analytics backgrounds—to make more informed decisions.

We launched "Explore" in Sheets to help you decipher your data easily using the power of machine intelligence, and since then we’ve added even more ways for you to intelligently visualize and share your company data. Today, we’re announcing additional features in Google Sheets to help businesses make better use of their data, from pivot tables and formula suggestions powered by machine intelligence, to even more flexible ways to help you analyze your data.

Easier pivot tables, faster insights

Many teams rely on pivot tables to summarize massive data sets and find useful patterns, but creating them manually can be tricky. Now, if you have data organized in a spreadsheet, Sheets can intelligently suggest a pivot table for you.*

In the Explore panel, you can also ask questions of your data using everyday language (via natural language processing) and have the answer returned as a pivot table. For example, type “what is the sum of revenue by salesperson?” or “how much revenue does each product category generate?” and Sheets can help you find the right pivot table analysis.**


In addition, if you want to create a pivot table from scratch, Sheets can suggest a number of relevant tables in the pivot table editor to help you summarize your data faster.

*You can view pivot tables on all platforms, but you can only create and edit them on the web.
**The “Answers” feature in Sheets is only available in English at this time.

Suggested formulas, quicker answers

We often use basic spreadsheet formulas like =SUM or =AVERAGE for data analysis, but it takes time to make sure all inputs are written correctly. Soon, you may notice suggestions pop up when you type “=” in a cell. Using machine intelligence, Sheets provides full formula suggestions to you based on contextual clues from your spreadsheet data. We designed this to help teams save time and get answers more intuitively.

Even more Sheets features

We’re also adding more features to make Sheets even better for data analysis:
  • Check out a refreshed UI for pivot tables in Sheets, and new, customizable headings for rows and columns.
  • View your data differently with new pivot table features. When you create a pivot table, you can “show values as a % of totals” to see summarized values as a fraction of grand totals. Once you have a table, you can right-click on a cell to “view details” or even combine pivot table groups to aggregate data the way you need it. We’re also adding new format options, like repeated row labels, to give you more fine-tuned control of how to present your summarized data.
  • Create and edit waterfall charts. Waterfall charts are good for visualizing sequential changes in data, like if you want to see the incremental breakdown of last year’s revenue month-by-month. Select Insert > Chart > Chart type picker and then choose “waterfall.”
  • Quickly import or paste fixed-width formatted data files. Sheets will automatically split up the data into columns for you without needing a delimiter such as commas between data.
These new Sheets features will roll out in the coming weeks—see specific rollout details below. To learn more about how G Suite can help your business uncover valuable insights and speed up efficiencies, visit the G Suite website. Or check out these tips to help get started with Sheets.

Launch Details
Release track: 
Launching to Rapid Release, with Scheduled Release coming on January 24th, 2018*

*Due to the holidays, the launch to Scheduled Release will occur more than the standard two weeks after the launch to Rapid Release. The rollout to Scheduled Release domains will begin on January 24th, 2018.

Editions:
Available to all G Suite editions

Rollout pace:
Extended rollout (potentially longer than 15 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: See and use suggested charts and analysis in a spreadsheet
Help Center: Create and use pivot tables
Help Center: Customize a pivot table
Help Center: GETPIVOTDATA
Help Center: Chart and graph types
Help Center: Import data sets and spreadsheets
Help Center Separate cell text into columns


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

New languages now supported in Google Docs and Slides files, as well as Docs editors templates

No matter where you or your customers or colleagues are located, we want to make sure Google Docs and Slides work for you at work. That’s why we’re expanding the font catalogue in Docs and Slides to support 62 languages, including non-Latin scripts like Cyrillic and Devanagari (with more coming soon!).

To find these new fonts and others, simply click More fonts at the bottom of the Fonts menu. There you’ll also find suggested fonts, based on your document’s language.


In addition, we’re making Google Docs, Sheets, Slides, and Forms templates available in four new languages: European Spanish, Latin American Spanish, French, and Brazilian Portuguese. Stay tuned for additional languages, including Hindi, coming soon.

Launch Details
Release track:
Launching to both Rapid Release and Scheduled Release

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Change how paragraphs & fonts look


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Copy comments and suggestions in Google Docs, Sheets, and Slides

Google Docs, Sheets, and Slides make it easier than ever to collaborate on great content. Which is why it’s increasingly important not to lose a history of that collaboration when you duplicate a document, spreadsheet, or presentation. With that in mind, we’re making it possible to copy comments and suggestions any time you make a copy of a Docs, Sheets, or Slides file.

To copy your comments and suggestions, simply select “Make a copy” from the File menu and check the box for “Copy comments and suggestions” or “Copy comments.”


These comments and suggestions will then contain a note indicating that they were copied from the original document.


Check it out today, and collaborate—even on copies—with ease.

Launch Details
Release track:
Launching to Rapid Release, with Scheduled Release coming on November 29th, 2017

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Create, view, or save a file


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Turning down the in-app passcode feature in Google Drive, Docs, Sheets, and Slides on iOS

In the past, we’ve heard feedback that customers want more security for the files on their iOS devices, which led us to enable an in-app passcode feature specifically for the Google Drive, Docs, Sheets, and Slides iOS apps. Over time, however, we’ve come to learn that it’s not just the content within Google Drive that’s valuable to you. Your contacts, calendars, and emails—it's important that all of this is secure as well.

As a result, we began putting particular emphasis on supporting mobile device management (MDM) on iOS. For example, recent launches give G Suite admins greater visibility and control over enterprise-deployed iOS devices. In fact, with MDM, admins can enforce a passcode on all iOS devices that access corporate data, and they can wipe account data on a device if it’s compromised.

Owing to this increased investment in security on iOS devices, we’re ending support for the in-app passcode feature in Google Drive, Docs, Sheets and Slides on iOS devices signed in with G Suite accounts. Support will end on December 4th, 2017, and we’ll remove the feature entirely no earlier than January 8th, 2018.

We highly recommend that administrators use MDM to deploy passcode requirements at the system level on all of their iOS devices by following these instructions. This will provide better security than the in-app passcode feature in two key ways:
  • These passcode policies protect all of the content on your managed devices, including photos, contacts, and other content besides Google Drive, Docs, Sheets, and Slides content.
  • These passcode policies give you more control over passcode type, strength, expiration, and failure cases. See this Help Center article for more details.

Beginning on December 4th, 2017, any user signed in with a G Suite account who has this feature will see a message asking them to either acknowledge and turn off the functionality, or to ignore the message temporarily. Beginning on January 8th, 2018, all new versions of the Google Drive, Docs, Sheets, and Slides iOS apps will no longer contain in-app passcode functionality.


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Create custom headers and footers in Google Sheets

To create professional-looking spreadsheets, it’s often critical that you can append them with certain information—for instance, your company’s name, a confidentiality notice, and any other important details. With this launch, we’re making it easier to do just that. Going forward, you can customize the headers and footers in your Google Sheets documents with the text of your choosing. In addition, you can select from many more pre-defined options (for date, time, etc.) and move those options around within your header and footer. Simply choose “EDIT CUSTOM FIELDS” from the Print settings menu to get started.



As a bonus, we’re also introducing saved print settings with this launch. Just modify your settings once, and they’ll be retained the next time you—or a collaborator—opens that same spreadsheet.

Launch Details
Release track:
Launching to Rapid Release, with Scheduled Release coming in two weeks

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Get on the same page: new Google Docs features help power team collaboration

(Cross-posted from The Keyword, with some additional details)

Getting people on the same page for a project can be tough. It requires managing a ton of opinions and suggestions. The last thing you should have to worry about is making sure your team is literally working on the same document. That’s why we built our powerful real-time editing tools to help with this—Google Docs, Sheets and Slides—so that teams can work together at the same time, using the most up-to-date version.

Today, we're introducing new updates to better help with "version control," to customize tools for your workflows, and to help teams locate information when they need it.

Track changes, make progress

It can take dozens of edits to make a document just right—especially a legal agreement, project proposal or research paper. These new updates in Docs let you more easily track your team’s changes. Now, your team can:

1. Name versions of a Doc, Sheet or Slide on the web.
Being able to assign custom names to versions of your document is a great way to keep a historical record of your team's progress. It's also helpful for communicating when a document is actually final. You can organize and track your team’s changes in one place under “Version history” (formerly known as “Revision history”) on the web. Select File > Version history > Name current version. For even quicker recall, there’s an option to select “Only show named versions” in Docs, Sheets or Slides.

2. Preview “clean versions” of Docs on the web to see what your Doc looks like without comments or suggested edits.
Select Tools > Review suggested edits > Preview accept all OR Preview reject all.

3. Accept or reject all edit suggestions at once in your Doc so your team doesn’t have to review every single punctuation mark or formatting update.
Select Tools > Review suggested edits > Accept all OR Reject all.

4. Suggest changes in a Doc from an Android, iPhone or iPad device.
Click the three dots menu in the bottom right of your Doc screen to suggest edits on the go. Turn on the “Suggest changes” toggle and start typing in “suggestion mode.”

5. Compare documents and review redlines instantly with Litera Change-Pro or Workshare Add-ons in Docs. 


Here’s a quick way to preview and accept all changes (or reject them) and name versions of your document.


Use new templates, add-on time-saving functionality

Teams use templates in Docs and Sheets to save time on formatting. At the same time, developers are building add-ons to customize functionality. We thought, why not bring these two together? That’s why today, we’re introducing new templates with built-in add-ons and the ability to create your own, so your templates not only look good—but they make sure the work gets done.

These templates allow you to customize and deploy tools specific to your organization’s workflows. We’ve launched five examples of this in the general template gallery, like the new Mutual Non-Disclosure Agreement (NDA) template from LegalZoom and DocuSign. With this template, businesses can quickly create an NDA and collect signatures using the DocuSign Add-on for Docs. Bonus: it also automatically detects the required signature fields on the template, which saves even more time when you request signatures. This is just one of a few new templates—we’ve also worked with Lucidchart to create a business process manual, PandaDoc for a consulting agreement, Supermetrics for a website paid traffic report, and EasyBib for an MLA report. Each should help you save time and maximize efficiency throughout your team’s workflows.

In addition, you can create your very own template with built-in add-on customized to your company’s workflows. For example, create a Sheets template paired with an add-on to gather internal approvals or an invoice template in Docs (paired with an add-on) that pulls information from your CRM system.

Admins, if you don’t currently allow your users to install add-ons, you can still use these new templates by deploying specific add-ons only. Or, if you’d prefer to allow your users to install only certain add-ons, you can block specific third-party OAuth scopes and whitelist only those add-ons you trust.

Note that templates paired with add-ons abide by the same Admin console settings as all other templates and are available in English only.


The new Mutual NDA template from LegalZoom and DocuSign lets you collect NDA approvals stat.


Find the information you need, when you need it

Sometimes the hardest part of creating a proposal or client presentation is tracking down the information you need to include in it. Starting today for G Suite Business and Enterprise customers, Google Cloud Search will integrate with Docs and Slides via the Explore feature. Using Machine Intelligence, Cloud Search surfaces relevant information to help you work more efficiently throughout your day.

To get started, open the Explore tab in Docs or Slides and type what you’re looking for. Cloud Search will show you important details from your information across your G Suite apps including Gmail, Drive, Calendar, Sites and more, to help you create top-notch Docs and presentations.


Now you can use Google Cloud Search through the Explore feature in Docs and Slides.


Teams are using Docs to collaborate in creative ways. Check out this post for inspiration, or visit the Docs site to get started.

Launch Details
Release track:
  • Versions and Cloud Search in Explore
    • Launching to Rapid Release, with Scheduled Release coming in two weeks
  • Suggestions
    • Mobile features launching to both Rapid Release and Scheduled Release
    • Web features launching to Rapid Release, with Scheduled Release coming in two weeks
  • Templates
    • Launching to Rapid Release, with Scheduled Release coming in two weeks*
*Templates created by our partners will appear immediately in all template galleries, but the add-on functionality associated with them will launch only to domains on the Rapid Release track. Domains on the Scheduled Release track will see add-on functionality in two weeks.

Editions:
  • Versions, Suggestions, and Templates
    • Available to all G Suite editions
  • Cloud Search in Explore
    • Available to G Suite Business and Enterprise editions with Cloud Search enabled only

Rollout pace:
  • Versions, Suggestions, and Templates
    • Gradual rollout (up to 15 days for feature visibility)
  • Cloud Search in Explore
    • Extended rollout (potentially longer than 15 days for feature visibility)

Impact:
  • Versions and Suggestions
    • All end users
  • Templates and Cloud Search in Explore
    • Admins and end users

Action:
  • Versions and Suggestions
    • Change management suggested/FYI
  • Templates and Cloud Search in Explore
    • Admin action suggested/FYI

More Information


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates