Enable the Developer tab in Excel
Open the Developer tab
Click Record Macro
Enter a macro name
Choose where to store the macro
Assign a shortcut key if needed
Click OK
Perform the actions you want to automate
Click Stop Recording
Open Visual Basic for Applications if you want to edit the macro
Use the Macros button to run the macro
Save the workbook as a macro-enabled file
Use the .xlsm file format
Enable macros when opening the file if prompted