Latest in Gear

Image credit:

Google caters to productivity pros with macro recording in Sheets

It's really exciting if you work on spreadsheets for a living. Really.
Jon Fingas, @jonfingas
April 11, 2018
Share
Tweet
Share

Sponsored Links

Jon Fingas/Engadget

If your work revolves around spreadsheets, there's a good chance you depend on macros -- those automated actions can save you hours upon hours of repetitive effort. They've been a pain in Google Sheets, however, as you've had to rely on complicated scripts. It should be much easier in the next few weeks. Google is adding macro recording to Sheets, making automation just a matter of walking through the necessary steps yourself. You still have to dive into scripts when you want to edit macros, but this should help you spend more time working on budget reports and less time getting ready to work.

Sheets is also receiving a few seemingly minor updates that could be huge in the right circumstances. You can now add printing page breaks, custom paper sizes and checkboxes in cells. You have more options for grouping columns and rows, and you can group data by time in pivot tables. Is this going to be meaningless for most people? You bet -- but Google needs these kinds of niche case features if it's going to lure you away from Excel.

All products recommended by Engadget are selected by our editorial team, independent of our parent company. Some of our stories include affiliate links. If you buy something through one of these links, we may earn an affiliate commission.
Comment
Comments
Share
Tweet
Share

Popular on Engadget

Weber’s SmokeFire smart grills just got a lot better

Weber’s SmokeFire smart grills just got a lot better

View
Inside Indonesia's fight to save its most important soil

Inside Indonesia's fight to save its most important soil

View
Our readers find Nintendo’s Joy-Con controllers a crushing disappointment

Our readers find Nintendo’s Joy-Con controllers a crushing disappointment

View
Atmospheric CO2 hits a record high while emissions drop

Atmospheric CO2 hits a record high while emissions drop

View
The best deals we found this week: 16-inch MacBook Pro, PS Plus and more

The best deals we found this week: 16-inch MacBook Pro, PS Plus and more

View

From around the web

Page 1Page 1ear iconeye iconFill 23text filevr