Learn what's new in Google Sheets

Stay informed on the latest updates in Google Sheets.

August 2021

Open Microsoft Office files in Drive faster

When you create shared links, you can open Microsoft Office files in Google Drive directly in:

  • Docs
  • Sheets
  • Slides 

Previously, Office files opened in preview mode. Now you can open files in edit mode and collaborate sooner. Learn more about working with Office files in Drive. 

Use Smart Compose to comment in Google Slides, Sheets, and Drawings

Smart Compose can help you comment faster and more accurately in:

  • Slides
  • Sheets
  • Drawings 

Learn more about Smart Compose in Google Docs, Sheets, Slides, and Drawings.

July 2021

Perform basic actions in multiple tabs in Google Sheets

Work in Google Sheets faster and with more confidence as you perform basic actions on multiple sheets.

You can select, then join, delete, duplicate, copy, color, or hide multiple tabs.

Learn more about editing Google Sheets.

Google Workspace Business Starter and Frontline users can invite people without Google Accounts to collaborate on Drive files and folders

You can send visitors a pin code to allow them to view, comment, or edit content in:
  • Drive
  • Docs
  • Sheets
  • Slides
  • Sites 
Learn more about sharing documents with visitors.

June 2021

Find new ways to navigate comments in Google Sheets

In Google Sheets, you can:

  • Review comments and conversation threads in a sidebar.
  • Apply filters to find the most relevant comments.
  • Page through comment threads in the comment overlay.

Learn more about using comments in Google Sheets.

May 2021

Present Google Sheets directly to a Google Meet meeting

Present a spreadsheet from Google Sheets to a Google Meet meeting you attend. Learn how to present a doc, sheet, or slide directly in Google Meet.

Learn how to customize line and fill options in Google Sheets

Enjoy more line and fill customization options for series and series items. You can modify: 

  • Color 
  • Opacity 
  • Line dash styles 
  • Line thickness 

For column-shaped series, you can add and style borders. Learn more about adding and editing a chart or graph.

April 2021

Find more ways to analyze BigQuery data with Connected Sheets

Learn more ways to work with, display, and organize your BigQuery data when you use Connected Sheets. The new features and improvements include: 
  • Column stats 
  • Filter by value 
  • Calculated fields for pivot tables 
  • Pivot table grouping 
  • Slicers 
Learn more about working with BigQuery data using Connected Sheets. 

January 2021

Use the range name box to improve navigation in Google Sheets

Use the range name box to navigate to active cells and ranges in Google Sheets. 

Learn more about naming a range of cells. 

Was this helpful?
How can we improve it?
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu
Search Help Center