Video 2 – Recording a Simple Macro

Video Highlights – Excel 2010: Macros in Depth


(0:03) – Use the macro recorder to record your actions

The best way to get started creating a macro is by recording your actions. Even power macro users will use this as a fall back method for creating a macro.

Three ways to record a macro

  1. (1:11) Use the status bar button – In the lower left corner of your screen you’ll see the word Ready and to the right of it you might or might not be seeing a button. I’m not seeing a button here, so I’m going to right-click in that status bar. And you’ll notice a lot of selections here including one called Macro Recording. By checking this option, at the bottom of the screen we now have a button.
  2. (1:51) Use the view menu – Another way to start macro recording is to click the view tab in the Ribbon and the right-most button called macros. There’s a drop arrow there. Record Macro.
  3. (2:04) Add a developer tab to the Ribbon – A third way is adding a new tab in the Ribbon called Developer. We don’t really need to do that, but that’s another way.

(2:58) – Give your macro a good name

As you see more and more macros, many many times a good name helps define and describe what a macro does.

(6:24) – Warning – you cannot use Undo!

You cannot use the Undo feature to undo what you just did (i.e. with a recorded macro) and that makes us think about macros that might be deleting data… we want to stay away from those for a while.

(7:20) – Summary of video

We’ve just demonstrated the relatively easy process of recording a macro that’s going to be the dominant but certainly not the only method of creating macros.

Check your inbox for free video #3 – coming soon!