Check out the new Google Sheets
Whether you are trying to create a spreadsheet for keeping track of personal finances or analyzing data in your workplace, the new Google Sheets can help. The new version allows you to create and edit spreadsheets, whether you’re online or not, and 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:
- 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 tabs, paste transpose, improved find and replace, and lots of new number formatting options.
Making the new features mentioned above accessible to everyone is important. You'll notice that brand new features, such as filter views and the new number formatting dialogs, are accessible using screen readers. Learn more about accessibility in Google Sheets.
Try the new Google Sheets
To use the new Google Sheets, you’ll need to opt in:
- Open Google Drive at drive.google.com.
- Click the gear menu in the top right corner of the screen and select Settings.
- Click the Editing tab.
- Select the checkbox next to "Try the new Google Sheets."
There are a few things to consider before switching to the new Sheets. Once switched, all spreadsheets that you create will be created in the new version. All previously created spreadsheets will remain in the older version of Sheets for now. You’ll also see that a few of the features you may be used to using in Sheets aren’t yet available in this new version. Learn more about switching to the old and new versions of Google Sheets.