A new version of Google Sheets has been released and is faster, supports larger spreadsheets, has a number of new features, and works offline.
The bigger Sheets support millions of cells and kicks many of the old size and complexity limits to the curb. Scrolling, loading and calculation are also snappier, even in more complex spreadsheets.
Filter views is a new feature unique to Google Sheets that lets you quickly name, save and share different views of your data. This comes in handy when you?re collaborating so you can sort a spreadsheet without affecting how others see it.
Whether you're new to formulas or a whiz at running complex functions, it's now easier to set up and perform calculations. New function help and examples guide you as you type, and error highlighting and coloring make it easy to spot and fix mistakes.
As another time-saving improvement, text now automatically flows into empty adjacent cells - no manual merge needed. With the improved conditional formatting, you can add rules to change the colors and styles of cells in your spreadsheet based on custom formulas.
Like Google Docs and Slides, you can now make edits to Sheets offline. When you reconnect to the Internet, your edits will automatically sync. If you've edited Docs or Slides offline in the past, then you?re already set up to edit Sheets offline. If not, follow these one-time instructions for setting up offline in Chrome.
You can turn on the new Sheets by checking the "Try the new Google Sheets" box in Google Drive settings.