MyFirstMacro) or separate words with underscores (e.g. Spaces are not allowed, so you should either keep a name single-worded starting each part with a capital letter (e.g. In macro names, you can use letters, numbers, and underscores the first character must be a letter.

Try to make it meaningful and descriptive, so later on you will be able to quickly find the macro in the list.

In the Macro name box, enter the name for your macro.

In the Record Macro dialog box that appears, configure the main parameters of your macro:.

If you prefer working with the keyboard rather than the mouse, press the following key sequence Alt, L, R (one-by-one, not all the keys at a time).

On the Developer tab, in the Code group, click the Record Macro button.Īlternatively, click the Record Macro button on the left side of the Status bar:.

To record a macro in Excel, carry out these steps: So, the first thing you need to do is to add Developer tab to your Excel ribbon. Like other VBA tools, Excel macros reside on the Developer tab, which is hidden by default.

Shortcut to save as xlsb alt+