Recording a macro is one of the basic features of Excel but a lot of users donâ€™t know how to do it and they donâ€™t even try to learn it. How to record a macro? Macros are a powerful feature in Excel. Macros save you time and spare you headaches by automating common, repetitive tasks.
Record Macro under the Developer tab
Give a name to your macro
Give a shortcut (optional)
save macros to the Personal Macro Workbook
Record a macro with me!