Macros get Involved on Google Sheets, Google’s online spreadsheet


For its Google Sheets online spreadsheet, the Alphabet affiliate has announced that you can now save macros that replicate a specific set of user interface interactions that you define. “Suppose you need to import new data that you want to put in the same format, or you want to create the same graph on several quarterly spreadsheets. Manual repetition of the same steps can take hours, but the Sheets macro recorder allows you to record these actions and read them without having to write any code, “says Google as an example to remind them importance of macros. Once you have saved a macro, you can link it to a keyboard shortcut in the form Ctrl + Alt + Shift + Number. You can use this shortcut to quickly execute the exact macro steps, usually in a different location or on different data. You can also enable the macro from the Google Sheets> Macros Tools menu. When you save a macro, Google Sheets will automatically create an Apps Script function (the macro function) that replicates the macro steps. The macro function is added to an Apps Script project linked to the sheet in a file called In case there is already a project file linked to the sheet with this name, the macro function is added to it. Google Sheets also automatically updates the script project manifest, saving the name and keyboard shortcut assigned to the macro. As each recorded macro is fully defined in Apps Script, you can edit them directly in the Apps Script Editor. You can even write macros from scratch in Apps Script, or take functions that you have already written and turn them into macros.

The tool is based on Apps Script, the name of the programming language that the American group derived from JavaScript to allow to add features to its various software. At Microsoft, the equivalent for Office is called Visual Basic for Applications and already allows you to save macros, in Excel among others. In both cases, the macros can be modified and imported from the built-in script editor. “The best part about Macros on Sheets is that they are designed for use in cloud-based files, which means that teams can run macros at the same time as others work in the sheet without interrupting them.” . For example, a finance team with a budget meeting can run macros while examining the same spreadsheet. It also means that colleagues or customers will not be forced to download sensitive files to use your macros. Because your Sheets files are in the cloud, you can more closely control who can view and share your data, “says Google. Google took the opportunity to talk about other features that have been added to his spreadsheet: “Today, we’re adding features that are requested regularly, including the ability to add page breaks, define custom paper sizes, more options for grouping rows and columns, and adding boxes.” check in the cells. We also allowed you to group your data by period (for example, week, month, or year) when you create PivotTables. ” source: Google And you ? Have you ever used Google Sheets? What do you think ? In your opinion, are these features sufficiently convincing to allow the tool to compete with its Excel counterpart?


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.