A macro is an automated input sequence that imitates keystrokes or mouse actions. A macro is typically used to replace a repetitive series of keyboard and mouse actions and are common in spreadsheet and word processing applications like MS Excel and MS Word. The file extension of a macro is commonly .MAC
How to Record a Macro in Excel 2016
- Select a cell.
- Any cell will do. Choose Developer → Code → Record Macro or click the macro recording button on...
- Enter a name for the macro. Excel provides a default name (something like Macro1),...
- Click OK. The Record Macro dialog box closes, and Excel’s macro recorder is turned on.
- Type your name in the active cell.