Creating macros in Excel is a great way to automate repetitive tasks.
To get started, here’s a list of helpful steps:

1. Open the Excel workbook or spreadsheet
2. Press Alt + F11 to open the Visual Basic Editor (VBE) which is where you can create the macro code
3. Record your macro by pressing Alt + F8 and under Macro recording settings, you can give the macro a name, description, and custom shortcut key.
4. Start carrying out the task you want to record and the VBE will start typing up the codes for your macro as you perform the commands.
5. Press Alt + F8 to stop the recording and save the macro.
6. Test the macro to make sure it functions properly.