Friday, February 28, 2014

New Google Sheets are faster and have many added features, including offline editing

Switch to the new version of Google Sheets for faster and larger spreadsheets, plus many new features. Sheets are now available for editing when offline.

Bigger and faster
Sheets now supports millions of cells and addresses many size and complexity challenges associated with the previous version of Sheets. Scrolling, loading and formulas work faster and cleaner as well.

New features added based on user requests 
Filter views is a new feature unique to Google Sheets that lets you quickly name, save and share different views of your data. This is important when collaborating, because 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.
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.

No internet connection? Work offline with Chrome 
You shouldn’t have to think about whether you have a WiFi connection when you want to work. So just 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.

Ready to try it out? 
Turn on the new Sheets by checking the “Try the new Google Sheets” box in Google Drive settings. From then on, all new spreadsheets you create will work offline and include these new features. Google will be adding a small list of missing features in the coming months, so if you rely on any of them, you may want to wait a little longer before opting in.

We hope you enjoy these and the many other updates that come along with the new Google Sheets, including colored sheet tabscustom number formattingpaste transpose and more. Let us know what you think on ourGoogle+ page!