These are the steps for recording or automating macros in Excel: On the Developer tab, in the Code group, click Record Macro. Alternatively, you could press Alt +T +M +R.; Go to the Macro name box to assign a name for the macro; You can create a keyboard shortcut for this macro by typing any letter in the shortcut key box. This has to start with a letter only; Go to Store macro to select the destination for your macro; Use the Description box to describe your macro briefly; Once you click OK, the recording starts; Do the actions that you want recorded; Once done, click Stop recording in the Code group. You could also press Alt +T +M +R again for this.Microsoft has complete details of this Excel action on this page. You can visit it to get more detailed and precise information.