Recently Google announced the launch of the new Google Sheets. This new version is faster and can support larger spreadsheets.
At the end of April, New School Google Apps users were automatically upgraded to the new Sheets. Spreadsheets created after the upgrade use the new version.
This upgrade did not affect any existing spreadsheets and only relates to any new spreadsheets created. You will not see any prompts about the new Sheets unless your create a new spreadsheet. Feature differences between the old and new sheets are explained in this support article
The new version adds a number of speed improvements, new functions, features and more.
Here is a list of new features in the latest version of Google Sheets:
- 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 tabs, paste transpose, improved find and replace, add-ons, easier linking, and lots of new number formatting options.