Google Sheets now works offline, faster, and adds features

Google Sheets
Photo credit:

It’s been no secret, that one of the biggest downfalls of the Google Productivity environment (namely, Google Docs) is Sheets. The Microsoft Excel alternative from Google has until recently, been dependent upon internet access to function. My guess is it has to do with how much more complex spreadsheet software is compared to a word processor. Sheets has also lacked many features that are available in Excel, such as SUMIFS, COUNTIFS, and AVERAGEIF.

Well Now Sheets works offline (the new Sheets must be enabled) and has gained a bunch of new features, including the 3 I just mentioned. Here is a list of some of the new features:

  • Offline: Create and edit spreadsheets without an internet connection after setting up offline access in Chrome.
  • Speed: New spreadsheets load and scroll much faster, removing many of the limits for formula complexity and spreadsheet size.
  • Improved formula editing: Check out our new function editing tools to help you build complex formulas.
  • New spreadsheet functions: Now you can use highly requested new functions such as SUMIFS, COUNTIFS, and AVERAGEIF.
  • Filter views: Create, save, and apply multiple filter views without changing what your collaborators see.
  • Advanced conditional formatting improvements: Apply formatting to your spreadsheet based on cell contents or formulas.
  • And many more, including colored sheet tabspaste transpose, improved find and replace, and lots of new number formatting options.

This is exciting, as it makes the transition from Microsoft to Google much easier.

What kinds of features do YOU wish Google Docs would incorporate into their programs?

Google Drive just recently announced some new features for the new Sheets (still need to enable the new Sheets to enjoy these features). Here’s an excerpt from their Google+ page:

It’s now even easier and handier to add links to your spreadsheets. Use the “Insert” menu or click on the link icon in the toolbar to create a link. You can even select from related links pulled in from your Drive and Google Search.

Sometimes you want to make changes to specific cells in a spreadsheet, even when they aren’t in the same column or row, and now you can. Just hold down command on Mac or control on PC and click on the cells you want to update.

These changes are only available in the new Google Sheets, so if you haven’t tried it, find out how here:

About James Welbes

James is a guy who does things. Lots of things. Nothing weird, mostly computer things like blogging, web development, Netflix. He's a total Google fanboy, (despite Allo) and has been recognized as a Google Expert in Google's Chromebook Central product forum.