Apr 22, 2015

How to create a macro in sheets?

As far as I know, Sheets doesn't support macros. However, you may be able to use Google's App Script to create a custom function that will do what you want. Here is a link to the guide on how to write custom functions using App Script.

You might also be able to find some 3rd party add-ons to Sheets that will do the trick. You can see the choices by:
1. Opening a spreadsheet in Sheets.
2. Click the Add-ons menu and then Get add-ons.
Answer this