Tag Archives: Editors

Sort and filter cells by text or fill color in Google Sheets

Quick launch summary 

We’ve added two additional parameters to filter and sort cells by in Google Sheets:
  • Text color 
  • Fill (background) color 

Along with sorting by values and conditions, these filters make it easier and faster to find and surface relevant data in Sheets. This feature will be available on mobile and web.

Getting started 

Admins: No admin action required for this feature.

End users: This feature will be available by default. To use this feature, select Filter > Filter by Color and then select “Fill color” or “Text color”. Matching cells will be display at the top of the range. Visit the Help Center to learn more. Use our Help Center to learn more about sorting and filtering data in Sheets.

Filtering by fill color, then text color.

Rollout pace

Availability

  • Available to all G Suite customers and users with personal Google Accounts

Resources


Set custom table ranges for charts in Google Sheets

What’s changing 

We’re improving the way data is suggested and how data is selected when creating a chart in Google Sheets. It’s now easier to locate and select the data you need when creating a dashboard over a dataset with slicers, pivot tables, charts, and more.

Who’s impacted 

End users

Why you’d use it 

When creating reports in Sheets, it’s common to create multiple charts from the same data table, but using different column ranges. Previously, all data ranges on a table would be used when creating a chart. Now, you’ll be able to select which columns to use for the chart axis and series. This allows you to quickly customize your charts so that they display the most relevant data.

Getting started

Admins: There is no admin action required for this feature.

End users: This feature will be available by default. In the chart editor, you can select a column as the X-axis and under “Series” you can select additional columns to populate your chart.


Rollout pace


Availability

  • Available to all G Suite customers and users with personal Google accounts

Fix images to a certain location on a page in Google Docs

Quick launch summary 

In Google Docs, you can now position an image in a fixed place, ensuring it stays in a certain spot on the page and is not disrupted by text and other elements.

We’ve also added a new sidebar where you can quickly access other image formatting options such as size, rotation, and brightness and contrast settings.

Getting started 

Admins: There is no admin control for this feature.

End users: This feature will be available by default. To position an image relative to a page, select the image and from the menu bar below it, select “Fix position on page”. To open the “Image options” sidebar, select the overflow menu (three dot), followed by “All image options”. To learn more about formatting images in Google Docs, see this article in our Help Center.


Rollout pace



Availability


  • Available to all G Suite customers and users with personal Google Accounts

Resources




Accessibility improvements for Google Docs

Quick launch summary 

We’re making several improvements to accessibility features in Google Docs. Some enhancements you’ll notice are:

  • Improvements in how screen readers verbalize content, including for non-text information like comments and suggestions. 
  • Improvements in how Braille displays render content, including symbols, emojis, and other glyphs. 
  • Improved support for navigating through elements such as tables, headers, and footers.
  • Improved caret tracking. 
We hope these improvements make it easier for users of assistive technologies to work in Google Docs.

Getting started 

Admins: There is no admin action required for this feature.

End users: These improvements will be automatically available to end users. Visit the Help Center to learn more about accessibility for Docs editors.

Rollout pace 


Availability 



  • Available to all G Suite customers and users with personal Google Accounts 

Resources 



Smart Compose in Google Docs now generally available

Quick launch summary

Last year, we announced a beta for Smart Compose in Google Docs, a feature that helps you compose high-quality content in Google Docs faster and more easily. Smart Compose saves you time by cutting back on repetitive writing, helps reduce the chance of spelling and grammatical errors, and can suggest relevant contextual phrases.

This feature is now generally available and has started rolling out to all G Suite customers. Note that Smart Compose is only available in English at the moment.

Getting started

  • Admins: There is no admin control for this feature.
  • End users: This feature will be ON by default and can be disabled  by going to Tools > Preferences and unchecking “Show Smart Compose Suggestions”. When enabled, you’ll automatically see Smart Compose suggestions. To accept a suggestion you like, press “tab” or right click on your cursor. Visit the Help Center to learn more about using Smart Compose in Google Docs.

Rollout pace

  • Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on February 18, 2020
  • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on March 3, 2020

Availability

  • Available to all G Suite customers
  • Not available to users with personal Google Accounts

Resources

Roadmap


Autocorrect now available for Google Docs on web

Quick launch summary

Last year, we announced improved as-you-type spelling and grammar corrections in Gmail. Now, we’re bringing that functionality to Google Docs on the web.


Autocorrect helps you compose documents quickly and with confidence. Misspelled words will automatically be corrected while typing and denoted with a grey dashed underline. As you continue typing, this dashed line will disappear.

If you need to undo a correction, you can simply hit backspace, select “Undo” while hovering over the autocorrected word, or use keyboard shortcuts like Command+Z.

Getting started


  • Admins: There is no admin control for this feature.
  • End users: This feature will be ON by default and can be disabled by going to Tools > Preferences and unchecking “Automatically correct spelling”. Visit the Help Center to learn more about using autocorrect in Google Docs.

Rollout pace

  • Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on February 18, 2020
  • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on March 3, 2020

Availability

  • Available to all G Suite customers and users with personal Google Accounts

Resources

Roadmap

Edit your new Google Sites faster with a revamped Settings menu

Quick launch summary 

We’ve made some improvements to the “Settings” menu in new Google Sites. Specifically, we’ve consolidated the location of several settings into one place, making it easier for site editors to access and configure different options for their sites.

For example, you can now now add a favicon to your site by going to Settings > Brand images. Or, to add Google Analytics tracking to your site, go to Settings > Analytics.



We’ve also given site editors the new option to hide anchor links from site viewers on a published site. Currently, anchor links appear by default when site viewers hover over headings on a page. With this new setting, found in Settings > Viewer tools, site editors now have even more control over how a published site looks. Visit the Help Center to learn more about using anchor links in new Google Sites.

Getting started 

End users:

  • Settings menu: The new Settings menu will be available by default. In the “Resources” section below, you’ll find a list of features that can now be accessed in the Settings menu.
  • Anchor links: Use our Help Center to learn more about adding or disabling anchor links in new Google Sites. 

Rollout pace 




Availability 


  • Available to all G Suite customers 


Resources 


Update to Sheets API v4 migration timeline

Quick launch summary 

Earlier this year, we announced the retirement of the Sheets v3 API. At that time, we stated that you’d need to migrate any applications built on the v3 API to the v4 API by March 3, 2020 to ensure they continue working properly.

We’re extending our timeline to allow developers additional time to migrate their applications: 
  • Starting on April 9, 2020, the spreadsheet and spreadsheets.readonly scopes can no longer be used to list a user’s spreadsheets in the v3 API. 
  • On September 30, 2020, the remainder of the v3 API will be turned down.

For information on transitioning your apps, check out our migration guide.

Smart Compose for Google Docs launching in beta

This announcement was made at Google Cloud Next ‘19 UK. Check out Next OnAir to tune into the livestream or watch session recordings following the event.

What’s changing 

Last year, we introduced Smart Compose for Gmail, a feature that uses artificial intelligence to help you draft emails faster. We’re now bringing Smart Compose to Google Docs with a new beta. This feature is available on the web.


Who’s impacted 

Admins and end users

Why you’d use it 

Smart Compose helps you compose high-quality content in Google Docs faster and more easily. It saves you time by cutting back on repetitive writing, helps reduce the chance of spelling and grammatical errors, and can suggest relevant contextual phrases.

How to get started 

  • Admins: Sign up for the Smart Compose for Google Docs beta. 
  • End users: Once your domain is whitelisted into the beta, you’ll see Smart Compose suggestions as you type. When you see a suggestion you like, press “tab” or right click on your cursor to use it. To turn off Smart Compose, go to Tools > Preferences and uncheck “Show Smart Compose Suggestions”. 

Additional details 

Note that this beta will only be available in English.

Helpful links 

Availability 

G Suite editions 
  • Available to all G Suite editions 
  • Not available to personal Google Accounts 

On/off by default? 
  • Once your domain has been accepted into the beta, this feature will be ON by default and can be disabled by the user. 
  • End users can turn off Smart Compose by going to Tools > Preferences and unchecking “Show Smart Compose Suggestions”. 

Stay up to date with G Suite launches

Data Connector for Zendesk now available as an add-on for Google Sheets

What’s changing 

You can now import and analyze data from Zendesk in Google Sheets with a new data connector. This add-on is now available in the G Suite Marketplace.

Who’s impacted 

End users

Why you’d use it 

Many organizations rely on Zendesk for capturing and taking action on support, customer service, and customer engagement. With the Data Connector for Zendesk, you can use it to configure and save valuable query configurations and load corresponding data into Google Sheets for analysis.


With the add-on, you can search against tickets in Zendesk (and return data to Sheets from that search), list tickets and metrics, load previous searches, and refresh query results already in your spreadsheet.

When creating a new search, you can select the fields you’d like to import to Sheets and set query conditions.

How to get started 

Additional details 

This add-on will use the Zendesk API to extract data into Sheets. At the moment, any changes to the data will not be reflected in Zendesk.

Helpful links 

Availability 

Rollout details 


G Suite editions 
  • Available to all G Suite editions 

On/off by default? 
  • This add-on can be whitelisted at the domain level. This add-on can be installed from the G Suite Marketplace.

Stay up to date with G Suite launches