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

3 thoughts on “Guide to the New Google Sheets

  1. Derek Kaufman Reply

    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 Reply

      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.

Leave a Reply

Your email address will not be published. Required fields are marked *


The Ultimate Guide for G Suite Admins