Tag Archives: Editors

More options for customizing a charts line and fill styling in Google Sheets

Quick Summary 

We’ve added more for line and fill customization options for series and series items. You can now modify: 
  •  Color 
  • Opacity 
  • Line dash styles 
  • Line thickness 
For column-shaped series, we’ve added the ability to add and style borders, a highly requested feature. 



Note: these new options are not available for pie charts, however the ability to change pie slice colors and add borders is already available. 

We hope these new options help you best display important data and create more impactful reports with Sheets. 

Getting started 


Rollout pace 


Availability 

  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers

Resources 

“Show Editors” provides more context on changes made in Google Docs

Quick launch summary 

You can now view richer information on the edit history of a particular range of content in Google Docs. Simply highlight and right-click on a range of text and select “Show Editors” from the dropdown menu. Here, you can view a list of editors and their latest edit along with time stamps. You’ll also have the option to open the Version History of the document. 




This makes it easier to track edits made by multiple collaborators, giving greater insight into who the recent editors were, what changes were made and when. 

Getting started 

Rollout pace 

Availability 

  • Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, and Education Plus customers
  • Not available to Google Workspace Essentials, Business Starter, Enterprise Essentials, Education Fundamentals, Frontline, and Nonprofits, as well as G Suite Basic and Business customers

Edit details in line with Google Tasks on the web

Quick launch summary 

You can now add additional information to your personal tasks without opening the “Details” dialog box. We hope this change makes it faster and easier for you to add descriptions, assign dates and times, and organize your tasks. 


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: There is no end user setting for this feature. Visit the Help Center to learn more about editing tasks on the web. 

Rollout pace 


Availability 

  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers 

Resources 

More ways to work with and analyze BigQuery data using Connected Sheets

What’s changing 

We’re adding several new features that will give you more ways to work with, display, and organize your BigQuery data when using Connected Sheets. Specifically, the new abilities and improvements are: 
  • Column stats 
  • Filter by value 
  • Calculated fields for pivot tables 
  • Pivot table grouping 
  • Slicers 
See below for more details on these features. If you’re new to BigQuery and Connected Sheets, check out this video demo. 

Who’s impacted 

Admins and End users 

Why you’d use it 

Column stats 
This new feature allows easy access to aggregated insights about the data in any column of your BigQuery table. These insights help you understand the shape of your data and include sum, average, median, unique count, max, min, list of most and least frequent values and distribution of the values in the column. 



Filter by value 
In addition to the ability to filter a column “by condition”, you can now filter a column “by value”. Connected Sheets will retrieve the list of values for any column that you can access for your analysis. Use the Help Center to learn more about filtering columns by value when using Connected Sheets. 



Calculated fields in pivot tables 
Calculated fields for pivot tables allow for custom aggregation of formulas in pivot table buckets. Use the Help Center to learn more about how to use calculated fields. 

Pivot table grouping 
You can now group numeric values from your source data into buckets of equal size in Connected Sheets pivot tables. This is useful when you’re working with a pivot table with numerous unique values—grouping can better narrow down your data by a minimum, maximum, and interval. Use the Help Center to learn more about using pivot table grouping in Google Sheets. 



Slicers for Connected Sheets 
You can also use a slicer to filter your Connected Sheets tables, charts, and pivot tables. A slicer is based on a column/field from the BigQuery data source. The slicer influences all the Connected Sheets charts, extracts and pivot tables in the same tab. Use the Help Center to learn more about using slicers with Connected Sheets. 

Additional details 

In the coming weeks, we will introduce improvements for scheduled refresh, allowing you to automate refresh at a specified frequency with more granular scheduling options. These options include: 
  • Hourly refreshes 
  • Specific start dates 
  • Frequency options such as every five days, every two months, etc. 



When this feature becomes available, we’ll provide an update on the Workspace Updates Blog. 

Getting started 

Rollout pace 


Availability 

  • Available to Google Workspace Enterprise Essentials, Enterprise Standard, Enterprise Plus, and Education Plus customers 
  • Not available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Education Fundamentals, Frontline, and Nonprofits, as well as G Suite Basic and Business customers 

Resources 

Add and manage four new types of citations in Google Docs

Quick launch summary

Now you can add these four new citation source types in Google Docs:
  • Film
  • TV Series
  • TV Episode
  • Miscellaneous
This will make writing academic papers easier, since you won’t have to copy citations from other tools. The four new citation source types come in addition to the types you already have available, including books, websites, journal articles, and newspaper articles.


Adding a film as a citation source

Getting started


Rollout pace


Availability

  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers.

Resources

Present with confidence with the improved presenter toolbar in Google Slides

Quick launch summary 

We’re updating the presenter toolbar in Google Slides to feature the controls you need while presenting, ensuring a better, less intrusive experience for presenters and presentation viewers. 


When presenting, now you’ll see options for: 
  • Selecting the previous or next slide, 
  • Select any slide from the picker, 
  • The three-dot overflow menu, which will open options for opening speaker notes, auto play, caption preferences, and more. 

Additionally, we’ve reduced the size of the trigger zone for the presenter bar in order to minimize distractions or obstruction of your content. 


We heard from our customers that the old presenter toolbar in Google Slides was getting in the way of content and creating a distraction for presenters and their audience. As a result, we have condensed the presenter toolbar down to the controls you need most so that now you can present with confidence, We hope these improvements help you present and engage with your audience more confidently, without worrying about potential disruptions. 



Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: There is no end user setting for this feature. Visit the Help Center to learn more about presenting in Google Slides. 

Rollout pace 


Availability 

  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers 
  • Available to users with personal Google Accounts 

Resources 

Improvements for locating new comments and important conversations in Google Docs

Quick launch summary

We’ve added two new ways that make it easier to find comments that require your attention and action in Google Docs on the web.

New comment activity since the last time you viewed a document will be “badged” with a blue dot. Additionally, when you hover over the blue dot, you’ll see a “New” banner.
A blue dot emphasizes the new comment activity since the last time you viewed the document.



In the Comments history dialog, we added new filtering options. You can sort comments by: “For you”, “All comments”, or “Resolved”.


Select  “For You” in the comment history dialog to view the comment threads and action items involving you.





We hope these improvements make collaboration easier by enabling you to quickly navigate to and take action on important comments and conversations.

Getting started

  • Admins: There is no admin control for this feature.
  • End users: There is no end user setting for this feature. Visit the Help Center to learn more about using comments and action items.

Rollout pace

Availability

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers
  • Available to users with personal Google Accounts 

Resources 


Out of office information will now display when replying to or mentioning a user in a Google Docs comment

Quick launch summary

In Google Docs, you’ll now see out of office information when replying to or mentioning other users in a comment.

When mentioning a single user in a new comment or thread, you’ll see the OOO banner and information on when they plan to return.




For multi-person threads, you’ll see condensed out of office information. You can select the info icon to view more information on each specific person. 


Getting started

Rollout pace


Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers 

Resources 





Quickly navigate to active cells and ranges with the new range name box in Google Sheets

Quick launch summary 

We’re adding a range name box, located to the left of the formula bar, to improve navigation in Google Sheets. Previously, active cells were only indicated by a blue outline and could be located by scrolling or using the arrow keys. Now, you can use the range name box to jump directly to coordinates and named ranges in a sheet. 

Additionally, this box provides a dropdown menu to easily access and manage to create new named ranges in the sheet. 


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: There is no end user setting for this feature. The new range name box can be found at the left of the formula bar. Visit the Help Center to learn more about using named ranges in Sheets.  

Rollout pace 


Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers 
  • Available to users with personal Google Accounts 

Resources 

Quickly navigate to active cells and ranges with the new range name box in Google Sheets

Quick launch summary 

We’re adding a range name box, located to the left of the formula bar, to improve navigation in Google Sheets. Previously, active cells were only indicated by a blue outline and could be located by scrolling or using the arrow keys. Now, you can use the range name box to jump directly to coordinates and named ranges in a sheet. 

Additionally, this box provides a dropdown menu to easily access and manage to create new named ranges in the sheet. 


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: There is no end user setting for this feature. The new range name box can be found at the left of the formula bar. Visit the Help Center to learn more about using named ranges in Sheets.  

Rollout pace 


Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers 
  • Available to users with personal Google Accounts 

Resources