Google Sheets updates from April 2018
-
Enhanced control over chart data labels, including totals for stacked charts and customizable placement.
Google Sheets is introducing new features to improve how charts represent data. Users can now add total data labels to stacked charts to display the sum of all content in a data set. Additionally, new alignment options for data labels have been added for column, bar, line, point, and area charts, allowing users to position labels in locations such as Center, Inside end, Inside base, Outside end, Left, Right, Above, or Below.
Release: Both • Rapid: 2018-04-23 • Scheduled: 2018-05-07 -
2018-04-11Content & Collaboration
Group data by time frame in Google Sheets pivot tables.
When creating pivot tables in Google Sheets, users can now group their data by specific time frames, such as week, month, or year, to facilitate better temporal analysis of their data.
Release: Both • Rapid: 2018-04-11 • Scheduled: 2018-04-11 -
2018-04-11Content & Collaboration
Ability to add checkboxes in cells in Google Sheets.
Google Sheets has added the ability to insert checkboxes directly into cells, making it easier for users to create checklists and track task completion within their spreadsheets.
Release: Both • Rapid: 2018-04-11 • Scheduled: 2018-04-11 -
2018-04-11Content & Collaboration
Expanded options for row and column grouping in Google Sheets.
Google Sheets now provides more options for grouping rows and columns, enabling users to organize and manage their data more effectively.
Release: Both • Rapid: 2018-04-11 • Scheduled: 2018-04-11 -
2018-04-11Content & Collaboration
Added printing page breaks and custom paper sizes to Google Sheets.
Google Sheets has introduced new printing capabilities, allowing users to add printing page breaks and define custom paper sizes to better control the layout of their printed documents.
Release: Both • Rapid: 2018-04-11 • Scheduled: 2018-04-11 -
Record macros in Google Sheets to automate repetitive tasks.
Google Sheets now allows users to record macros in the cloud to automate repetitive tasks without needing to write code. The macro recorder automatically converts actions into Apps Script, which can be edited directly for updates. Because these macros are cloud-based, teams can run them simultaneously without interrupting other collaborators working in the same sheet.
Release: Both • Rapid: 2018-04-11 • Scheduled: 2018-04-11