«Google Spreadsheets" now supports macros

News Web Services / by admin / December 19, 2019

click fraud protection

Google released a major upgrade to "Google Spreadsheets». Its main feature was the macros. They allow you to store a sequence of actions that they do not have to continually perform manually.

A new feature is located in the tab "Tools". You need to select the "Macros" and click the "Record Macro". After that, you are doing the whole sequence of actions and save her. Then, to her again, just enough to run a macro.

When you add a macro automatically creates a Google Apps Script. So if you want it can be edited through a script editor in the same tab "Tools".

The company has made to the «Google Spreadsheets" and a number of other changes. Now you can add page breaks for printing tables and transform the cell into the boxes, support for custom size sheets, new options for grouping rows and columns. It is also now possible to group the data in the summary tables for weeks, months and years.