Tag Archives: Google Sheets

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 

Open Office attachments from Gmail in Google Docs, Sheets, or Slides with one click

What’s changing

We’re making it easier to view, edit, and collaborate on Microsoft Office files sent and received in Gmail using Docs, Sheets, and Slides. With this launch, we’re adding: 
  • Open Office files in Docs, Sheets, or Slides with one click: When you send or receive email with an Office file attached, you’ll see an edit icon that will open the file directly in Docs, Sheets, or Slides while preserving the original file format. 
  • Easily reply to the email from within the file: Once the file is opened, you’ll have new options to respond to the email thread from the File menu in Docs, Sheets, or Slides. 

See images below. 


Who’s impacted 

End users 


Why it’s important 

This provides a fast and convenient way to view, edit, and collaborate on emailed Office files directly in Docs, Sheets, and Slides. Previously, users would have to save a file to Drive before being able to use G Suite’s Office editing features. With this launch, they can open files more quickly and reply to email threads featuring Office files more easily. 


Getting started 


When you receive an Office file in Gmail, click the Edit icon to quickly open the file to view, edit, and collaborate. 

After opening an Office file from Gmail, you’ll see new options in the Docs, Sheets, or Slides File menu to reply with a file, or open the original message. 


Rollout pace 

Availability 

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

Resources 

Use Macro Converter add-on to convert Microsoft Excel files with macros to Google Sheets

Quick launch summary 

We’ve launched Macro Converter for Google Sheets. This Google Workspace add-on will help convert Visual Basic for Applications (VBA) code used in Microsoft Excel macros to Apps Script code that works in Google Sheets. 


Many organizations use macros in Sheets and Excel to automate processes. Google Workspace Enterprise Plus customers can use the Macro Conversion add-on to determine the compatibility of Excel files, and help convert them where possible. This can help teams to recreate Excel macros in Sheets, which can help teams save time through automation while reducing the work needed to convert files.  




Getting started 

Rollout pace 

  • This is available now for all users. 

Availability 

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

Resources 

New comment interface for Google Drive, Docs, Sheets, and Slides rolling out to more devices

Quick Summary 

We’re updating the user interface for comments and action items in the Google Drive, Docs, Sheets, and Slides apps for iOS. These improvements include: 
  • Larger, clearer interface to make it easier to see comments and their context in a document. 
  • Shortcuts and gestures to help you quickly scroll through and respond to multiple comments. 
  • Quick access button to reply, “@” mention someone, and assign action items. 


These updates were previously made available on the Docs, Sheets, and Slides Android apps; they’re now rolling out to the Drive Android app and the Docs, Sheets, and Slides iOS apps. 

They’ll be made available on the Drive iOS app in the future. See below for more details on the rollout.

Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: This feature will be automatically available. To get started, tap on a comment when using the Docs, Sheets, or Slides app on an iOS device. Visit the Help Center to learn more about using comments and action items on iOS devices. 


Rollout pace 

Docs, Sheets, and Slides on iOS 

Drive Android app

Drive iOS app
  • Stay tuned to the Workspace Updates blog for information on when this will launch to iOS devices. 

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 

Office editing on iOS brings Google Workspace collaboration to Microsoft Office files

Quick launch summary 

We’re making Office editing available on iOS. This feature brings the collaborative and assistive features of Google Workspace to your Microsoft Office files when you’re using your iOS device. Already available on the web and Android, it: 
  • Allows you to edit, comment, and collaborate on Microsoft Office files using Google Docs’, Sheets’, and Slides’ powerful real-time collaboration tools. 
  • Improves sharing options, improves sharing controls, and reduces the need to download and email file attachments. 
  • Streamlines workflows by reducing the need to convert file types. 

Office editing will replace Quickoffice (sometimes known as Office Compatibility Mode), which has more limited functionality and collaboration capabilities. See more about Office editing in our announcement for the feature on the web. 

Getting started 

Rollout pace 

  • This feature is available now for all users. 

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 

Changes to Google Workspace storage policies starting June 1, 2021

What’s changing

In 2021, we’ll make some changes to the way we store Google Photos, Docs, Sheets, Slides, Drawings, Forms, and Jamboard content that may impact your domain. Please see below for more details.

Google Photos
Starting June 1, 2021, any new photos or videos uploaded to Google Photos or Google Drive in High quality will count toward the storage limits for users in your domain. Currently, only photos and videos uploaded in Original quality count toward storage quotas. Please note that any photos or videos uploaded in High quality prior to June 1, 2021, will not be impacted by this change and will not count toward storage limits.

Google Docs, Sheets, Slides, Drawings, Forms, and Jamboard
Starting June 1, 2021, any newly created Google Docs, Sheets, Slides, Drawings, Forms, and Jamboard files will also count toward the storage limits for users in your domain. Existing files within these products will not count toward storage, unless they’re modified on or after June 1, 2021.

Who’s impacted

Admins and end users. Storage limits differ across Google Workspace and G Suite editions, but we estimate that the majority of users will not be affected by these changes. See “Getting Started” below for more information on determining how much storage each user in your organization is allotted.

Why it’s important

Over the past decade, Gmail, Google Drive, and Google Photos have helped billions of people securely store and manage their emails, documents, photos, videos and more. Today, people are uploading more content than ever before—in fact, more than 4.3 million GB are added across Gmail, Drive, and Photos every day. These changes to our storage policy are necessary to provide our users with a great experience and to keep pace with the growing demand.

Getting started


Rollout pace


Availability 

  • These changes will apply to all customers with Google Workspace and G Suite licenses. 

Resources

 

Office editing mode is now the default editing mode for Office files in Drive on the web

What’s changing 

We’re changing the default editing mode for Microsoft Office files in Google Drive on the web. Now, when you double-click on an Office file, it will open directly in Office editing mode. 

Previously, double clicking would open a preview of the document, from which users could choose whether to open in Office editing mode or download the file. You can still use the preview mode by right clicking the file and clicking "Preview,” or by pressing ‘P’ on the keyboard while double clicking the file. 



Who’s impacted 

End users 


Why it’s important 

This change makes it quicker to open and start editing documents. Users can directly edit, comment, and collaborate on Office files using the familiar interface of Google Docs, Sheets, and Slides, with changes automatically saved to the file in its existing Office format. 


Additional details 

Note that: 
  • This change will apply to all compatible Office file types, including .docx, .doc, .ppt, .pptx, .xls, .xlsx, .xlsm 
  • Password protected Office files will not open directly in Office editing mode. These files will continue to open in Preview mode. 
  • If the “Office Editing for Docs, Sheets & Slides” Chrome extension is installed, we will redirect to the extension and not to Docs, Sheets, or Slides. This is the same as if you select “Open with” today. 


Getting started 

  • Admins: This feature will be ON by default. There is no admin control for this feature. 
  • End users: This change will take place by default when opening compatible Office files in Drive on the web. You can still use the preview mode by right clicking the file and clicking "Preview," or by pressing ‘P’ on the keyboard while double clicking the file. Visit the Help Center to learn more about working with Office files in Drive. 

Rollout pace 

Availability 

  • Available to Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education, Enterprise for Education, and Nonprofits customers and users with personal Google Accounts 

Resources 

Google Workspace Add-ons now generally available in Google Docs, Sheets, and Slides

Quick Summary 

Google Workplace Add-ons are now available for Google Docs, Sheets, and Slides. Google Workspace Add-ons are already available for Calendar, Gmail, and Google Drive.


Google Workspace Add-ons allow you to use third-party applications within Google Workspace, helping you get work done faster without switching from one app to another. 

Organizations can also create add-ons using Apps Script or alternative runtimes — use the Google Workspace Developer guide for add-ons to learn more about building add-ons. 

Getting started 

Rollout pace 

Availability 

  • Available to Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education, Enterprise for Education, and Nonprofits customers and users with personal accounts.  

Resources 

Use Smart Fill to help automate data entry in Google Sheets

What’s changing 

We’re launching Smart Fill for Google Sheets, which detects and learns patterns between columns to intelligently autocomplete data entry. 


For example, if you have a column of full names, you may want to split it into a column with first names and a column with last names. As you start typing first names into a column, Sheets will automatically look for patterns. If Sheets detects a pattern, it will generate the corresponding formula, and then autocomplete the rest of the column for you. 


We previously announced that Smart Fill for Sheets was coming soon. See more details below. 



Who’s impacted 

End users 


Why it’s important 

We hope that Smart Fill will make it easier to prepare and use data in Sheets. Similar to how Smart Compose in Gmail helps you write faster with fewer mistakes, Smart Fill makes data entry quicker and less prone to error. 


We also recently launched Sheets Smart Cleanup, which uses similar intelligence to help prepare and analyze data in Sheets. By adding new, intelligent features to help automate data preparation and analysis, we hope to empower all users to harness the power of data and quickly make data-backed decisions. 


Additional details 

In addition to using data that’s in a sheet, Smart Fill can also use data from Google’s Knowledge Graph. For example, it can use public data to autocomplete a list of countries where a list of cities are located. 


For Enterprise Plus customers, it can also use information from your company’s people Directory to autocomplete data. For example, it can use organization-only data to fill in email addresses for company employees. 



Getting started 

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on October 15, 2020 
  • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on November 5, 2020 

Availability 

  • Smartfill is available to Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education, Enterprise for Education, and Nonprofits customers, and users with personal Google Accounts 
  • Smartfill integration with people directory is only available to Enterprise Plus customers. 

Resources 


Roadmap 

Use Smart Fill to help automate data entry in Google Sheets

What’s changing 

We’re launching Smart Fill for Google Sheets, which detects and learns patterns between columns to intelligently autocomplete data entry. 


For example, if you have a column of full names, you may want to split it into a column with first names and a column with last names. As you start typing first names into a column, Sheets will automatically look for patterns. If Sheets detects a pattern, it will generate the corresponding formula, and then autocomplete the rest of the column for you. 


We previously announced that Smart Fill for Sheets was coming soon. See more details below. 



Who’s impacted 

End users 


Why it’s important 

We hope that Smart Fill will make it easier to prepare and use data in Sheets. Similar to how Smart Compose in Gmail helps you write faster with fewer mistakes, Smart Fill makes data entry quicker and less prone to error. 


We also recently launched Sheets Smart Cleanup, which uses similar intelligence to help prepare and analyze data in Sheets. By adding new, intelligent features to help automate data preparation and analysis, we hope to empower all users to harness the power of data and quickly make data-backed decisions. 


Additional details 

In addition to using data that’s in a sheet, Smart Fill can also use data from Google’s Knowledge Graph. For example, it can use public data to autocomplete a list of countries where a list of cities are located. 


For Enterprise Plus customers, it can also use information from your company’s people Directory to autocomplete data. For example, it can use organization-only data to fill in email addresses for company employees. 



Getting started 

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on October 15, 2020 
  • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on November 5, 2020 

Availability 

  • Smartfill is available to Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education, Enterprise for Education, and Nonprofits customers, and users with personal Google Accounts 
  • Smartfill integration with people directory is only available to Enterprise Plus customers. 

Resources 


Roadmap