You can automate tedious tasks in Google Sheets using its new macro tool, which allows you to record and run automated functions with just a button click or custom keyboard shortcut. Macros can remove or add formatting, insert rows and columns, fill in tricky functions, clean up data, and more. They are handy for speeding up your own work and even more useful when handing off work to others. To make a macro, you first build it by recording your steps into the macro tool, then save and add a name to the macro. You can also add custom keyboard shortcuts for any Google Sheets feature. However, macros only work on the spreadsheet where they are made, so you need to recreate them or copy them over if you want to use them elsewhere.