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.
Follow the steps below to record a macro.
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.
After you finish all your tasks, you need to stop the recorder.
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.
After you click Macros, the macro dialog box appears.
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.
Press Alt-F8 to show the macro list.
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.
Record a basic macro in Excel - Quick tip
by Excel Effects :: October 23, 2020