Spreadsheets made their debut about 40 years ago and still remain a favorite among most students as well as professionals. The Spreadsheets have been serving the people in their professional life, be it analyzing quarterly revenue or updating product inventory. When it comes to handling a huge set of data, people still keep faith in Google Spreadsheets.
We’ve been focused on making Google Sheets better for businesses for this reason, which is why we’ve recently added new features to help teams analyze and visualize their data. Today we’re adding more updates to Sheets, including a way to record macros in the cloud to automate repetitive tasks, as well as more formatting options.
Google claims this new version of the spreadsheet will be able to record macros. This will perform the duties of the companies in an automated manner by welcoming a cloud-first approach in Macros. Let’s try to understand how the thing actually works. Let’s assume a person wants to format new data or wants to create multiple copies of the same chart.
The all-new Sheets macro recorder will now record all those previous activities and display them as per your need so that you do not waste your time by doing the same task repeatedly. All this is possible because whenever a macro has been recorded by a user, the Sheets automatically translate those macro actions into an Apps Script. There is also an option to scribble your Apps Script functions and later import them as new macros. As the Sheet Macros have been designed exclusively for cloud-based files, they can be run simultaneously while another person updates the same sheet.
To ensure trouble-free visibility, analyzability, and shareability of data, Google has incorporated a lot of attributes. For example, new chart types (waterfall and 3D), the ability to embed charts while keeping data up-to-date in Docs and Slides, secondary formatting, print options, and much more. Google says they are going to add features like printing page breaks, custom paper sizes, more alternatives for row and column grouping, an addition of checkbox, etc. The intelligent pivot tables included in Sheets will help to analyze data like a pro.