When you start recording a macro, information about each level of a series of commands gets saved. You can run the commands again by running the saved macro.
Steps
To record a macro
- Select View > Macros > View Macros.
Or, click the Record Macro
icon on the status bar.
- In the Record Macro dialog box, type macro name and click OK. In this example, type Macro1.
- Record macro content in the worksheet.
In this example, make borders for the cell A1 with thick lines and change fill colors.
To stop recording a macro
- Select View > Macros > View Macros.
- In the Record Macro dialog box, type macro name and click OK. In this example, type Macro2.
- Record macro content in the worksheet.
- Click View > Macros > Stop Recording.
Or, click the Stop Recordingicon on the status bar to stop recording a macro.