To record a new Macro in Google Sheets do the following:
On your computer,
A)Open a spreadsheet at sheets.google.com.
B)At the top, click Extensions Macros. Record macro.
C)At the bottom, choose which type of cell reference you want your macro to use: ...
D)Complete the task you want to record. ...
E)Name the macro, create a custom shortcut, and click Save.