Google announced an update for Google Sheets on 11 April. The new features look very exciting with macros being the headline feature. Macros enable you to record a series of edits to a Google Sheet that you will repeat and then save them in a menu to replay anytime to automate that series of actions. It even generates a script that you can edit without having to re-record the macro. This will eliminate a significant amount of tedium for big users of Sheets. Click the link above to read Google’s update about this and to watch their demo. Currently this is available on G Suite accounts but not regular Google Drive accounts.
Whilst macros were the headline feature, the one I am most excited about is checkboxes. Checkboxes are a significant reason that I still use Apple’s Numbers for some of my spreadsheets. Being able to tick items off in a spreadsheet is, in my opinion, a much more efficient user experience than having to use a drop down menu. I am excited about this but as of yet the feature hasn’t rolled out to users as far as I can see – I can’t access them in my regular Google Drive account nor in my G Suite account. Fingers crossed that it comes soon and is a solid implementation.
What are your thoughts about this update? Do you make/use a lot of spreadsheets? Will these and the other new features tempt you away from Excel and/or Numbers to Google Sheets? Share your thoughts in the comments here, Google Plus or Twitter.