In our
earlier post, we provided an overview of some of the ways we’re making Google Sheets better for business. This included several new feature announcements. This post will provide some more specific feature and rollout information that may be useful to G Suite admins.
Record macros in SheetsTo help save your team time when completing repetitive tasks, you can 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. See the
previous post for more details, or the
Help Center for the specific how-tos.
Group rows and columns in a spreadsheetThere’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 SheetsYou 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.
Improved date-based pivot tablesWe’re 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. See the Help Center to learn
how to add and use pivot tables.
Better spreadsheet printingWe’re adding 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.
Launch DetailsRelease track:Launching to Rapid Release, with Scheduled Release coming in 4 weeks
Editions:Available to all G Suite editions
Rollout pace:Extended rollout (potentially longer than 15 days for feature visibility); rollout to Scheduled Release domains will only start after rollout to Rapid Release domains is complete.
Impact:All end users
Action:Change management suggested/FYI
More InformationThe Keyword: Think macro: record actions in Google Sheets to skip repetitive workHelp Center: Automate tasks in Google SheetsHelp Center: Customize a pivot tableHelp Center: Print from Google SheetsHelp Center: Edit rows, columns, and cells in a spreadsheetHelp Center: Add and use checkboxesLaunch release calendarLaunch detail categoriesGet these product update alerts by emailSubscribe to the RSS feed of these updates
