Enable the Developer tab in Excel
Open the workbook where you want the macro
Click the Developer tab
Click Record Macro
Enter a macro name
Choose where to store the macro
Optionally assign a shortcut key
Click OK
Perform the actions you want to automate
Click Stop Recording
Open the Visual Basic Editor if you want to edit the macro
Modify the VBA code if needed
Save the workbook as a macro-enabled file
Use the macro from the Developer tab, shortcut key, or assigned button