Macros in Sheets
Starting today, you can record macros in Sheets. Now, when you record a macro, Sheets automatically converts the macro actions into an Apps Script. With this feature, if you want to update your macro, you can edit the script directly instead of having to re-record the macro from scratch. You can also write your own Apps Script functions and import them as new macros.
Sheets macros are built for use in cloud-based files, which means that teams can run macros at the same time that others are working in the sheet. It also means that coworkers or clients won’t be forced to download sensitive files to use macros. Because your Sheets files are in the cloud, you can keep tighter controls over who can view and re-share your data.
More updates to Sheets
In addition to the new ways to record macros, Google has added more updates to Sheets based on frequently requested features:
Printing page breaks, custom paper sizes
More options for row and column grouping
Checkboxes in cells
Grouping data by time frame (week, month, or year) when creating pivot tables
Intelligent pivot tables