Question

what is the use of macros spreadsheet​

Answer 1

Answer:

look into the picture for your answer

hope it helps you

Answer 2

Explanation:

1--Limit the number of actions in a macro for optimum performance.

2--Use macros for frequently repeated operations that don’t need much configuration.

3--Use unique macro shortcuts. You can have up to 10 shortcuts per sheet. Open additional macros from ToolsMacros.

4--Reduce macro duplication by applying a macro created for a single cell to a range of cells by selecting the full range of cells and then activating the macro. 

5--Macro scripts are specific to individual sheets and can only be used in Sheets—they won’t work in Google Docs, Forms, or Slides.