Excel Effects

Reference guide.

Record a basic macro in Excel – Quick tip

Record a basic macro in Excel - Quick tip

This quick tip shows you how to record a basic macro in Excel. On the whole, a macro lets you perform a set of tasks automatically.


For the purpose of this lesson, we suggest you use Excel 2007 or higher or compatible.


Steps to record a basic macro in Excel

Follow the steps below to record a macro.

Record a macro in Excel - Quick tip

  1. Click Developer from the main menu.
  2. Under the Code group, select Record Macro. The Record Macro dialog box opens.
  3. In the Record Macro dialog box, give your macro a name. If you are okay with the default name, then you can skip this step.
  4. Press OK.

After you press OK, the recorder starts. All in all, almost anything you do will become part of the macro, while the recorder is running.


Text to include in your macro

  1. So, type in some text in a cell and press Enter. In this case, we typed "Hello, is it me you're looking for?"

After you finish all your tasks, you need to stop the recorder.


Stop the recorder

  1. Click Developer from the main menu.
  2. Under the Code group, select Stop Recording.

Test your macro

Now that your macro is saved, we have to test it. Before we test, clear all of your cells. Basically, just press Ctrl-A and press Delete. Although it is not necessary, we want a clean sheet to test on.

Follow these steps to test your macro.

Show macros

  1. Position your cursor on a cell and click Developer from the main menu.
  2. Under the Code group, select Macros. As you see, there is a shortcut (Alt+F8) to view macros.

After you click Macros, the macro dialog box appears.


Macro list to run macro

  1. Select a macro from the Macro name list.
  2. Click Run.

Success!

Finally, there you go! Did it work for you? If you got stuck on something, then go back and try again. It is a fairly quick tip.

Shortcut alert

Press Alt-F8 to show the macro list.

Macro record button

At the bottom-left of your Excel screen, there should be a button next to the word Ready. Clicking this button will allow you to record without using the menu.


Additional resources


Record a basic macro in Excel - Quick tip
by Excel Effects :: October 23, 2020


Home

Techronology

Artplotty Grid

Development Category (English)300x250

Microsoft Surface Book 3