Google recently released one of their largest updates ever to Google Spreadsheets, bringing some desperately needed features. There’s a lot you need to know about the new Google Sheets, so check out this video before you get started!

First of all, Spreadsheets finally have a feature that was available for Docs, Slides and Drawings for quite a while — offline creation and editing. While this is still only available in the Chrome browser, it’s still a much needed addition.

One major point of contention with Google Spreadsheets was a limit on size limit on cells, functions, columns, etc. Google has removed those limits giving users much more flexibility. It’s important to note that even though the limits have been lifted you still may experience some delays as Sheets grow in size and complexity.

There’s a ton of new features available in this latest update, including:

  • Filter views
  • Enhanced function help
  • New functions
  • Advanced conditional formatting
  • Colored Sheet tabs
  • New find-and-replace features

Click here to watch this video on YouTube.


UP NEXT: Tricks for working with Multiple Nicknames in Google Apps

Leave a Reply

3 Comments on "Guide to the New Google Sheets"

Notify of
Sort by:   newest | oldest | most voted
Warren Wade

How do you enable the new gsheets in Google Apps for business?

Derek Kaufman
Derek Kaufman

Sheets looks awesome, but my biggest concern is accessing the Script Gallery, which appears to not exist in the new Sheets. Any word on when/if this will be added?

The Gooru
The Gooru

Agreed, there are definitely some issues with the new Sheets and not all features being supported at the moment. I don’t have a timeline for when everything will be updated, but I wouldn’t expect it to be too long. On the plus side, it’s fairly easy to switch back and forth between the old and new sheets.



The Ultimate Guide for G Suite Admins