Updates to Google Sheets include:
- Better spreadsheet printing
- Group rows and columns in a spreadsheet
- Add checkboxes to a list in Sheets
- New chart types
- More control over chart data labels
- Intelligent pivot tables
- Improved date-based pivot tables
- Record macros in Sheets
- Additional spreadsheet functions
Better spreadsheet printing
Google has added new features to make it easier to print spreadsheets. Specifically, you can specify custom paper sizes and set custom page breaks. This makes it easier to get the right content from a spreadsheet on a printed page. See the Help Center for more about how to print from Google Sheets.
Group rows and columns in a spreadsheet
There’s a new option to group rows or columns in Sheets. This makes it easier to collapse or expand several rows and columns at once to customize your view. See the Help Center for more on how to manage rows, columns, and cells.
Add checkboxes to a list in Sheets
You can turn a list of items into a checklist with the new checkbox feature. See the Help Center to learn how to add and use checkboxes.
New chart types
New chart types include waterfall and 3D charts. Currently Google Sheets offers 31 different charts and graphs. View all Chart and graph types here!- More control over chart data labels
- Show totals in stacked charts. You can now add total data labels in stacked charts, which show the sum of all content in a data set.
- Choose the alignment of your data labels
Intelligent pivot tables
Google recently added intelligent pivot tables to help analyze and find new insights, no matter how skilled you are at data analytics.
Improved date-based pivot tables
Google is making it easier to work with dates in pivot tables by adding an option to create groupings by time and date, including hour, day, month, quarter, year, and more. How to add and use pivot tables.
Record macros in Sheets
To help save your team time when completing repetitive tasks, you can now record macros in Sheets. When you record a macro, it’s saved as an Apps Script that you can run in the cloud whenever you need to perform the task. You can also edit the script to change it, or import existing Apps Scripts as new macros. How to record macros in Sheets