How to Create Macro in Excel: Get Started in No Time!

April 5, 2013 Excel  No comments

Macros in Excel can save you a lot of time, especially if you have repetitive tasks. With this post we will learn how to create macro in Microsoft Excel.

In Microsoft Excel 2007/2010, you can automate frequently used tasks by creating and running macros. A macro is a series of commands and instructions that you group together as a single command to accomplish a task automatically.

Typical uses for macros are:

  • To speed up routine editing and formatting
  • To combine multiple commands — for example, to insert a table with a specific size and borders, and with a specific number of rows and columns
  • To make an option in a dialog box more accessible
  • To automate a complex series of tasks

You can record multiple actions, or you can write your own macro from scratch by entering Visual Basic for Applications (Visual Basic for Applications (VBA).

In this article we will cover easy and fast steps that will show how to create macro in Excel in no time!


How to Create Macro in Excel

Show the developer tab

To start working with Macros we need to add the developer tab to your ribbon in Excel, here is how we do it:

  1. Click the Microsoft Office Button (in the top left corner), and then click Excel Options.
  2. Click Popular.
  3. Under Top options for working with Excel, select the “Show Developer tab” in the Ribbon check box.

how to create a macro photo

Record a Macro

Now that we are all set, we can begin the recording.

In the Developer tab, in the Code group, click Record Macro.

  1. Do one of the following:
  • Begin recording: To begin recording the macro without assigning it to a button on the Quick Access Toolbar or to a shortcut key, click OK.

how to create a macro - recording photo

  • Create a button: To assign the macro to a button on the Quick Access Toolbar, do the following:
    • Click Button.
    • Under Customize Quick Access Toolbar, select the document (or all documents) for which you want to add the macro to the Quick Access Toolbar. (Important: To make your macro available in all documents, be sure to click Normal.dotm.)
    • Under Choose commands from dialog box, click the macro that you are recording, and then click Add.
    • To customize the button, click Modify.
    • Under Symbol, click the symbol that you want to use for your button.
    • In the Display name box, type the macro name that you want to display.
    • Click OK twice to begin recording the macro.

    how to create macro - buttons - photo

The symbol that you choose is displayed in the Quick Access Toolbar. The name that you type is displayed when you point to the symbol.

  • Assign a keyboard shortcut:To assign the macro to a keyboard shortcut, do the following:
    • Click Keyboard.
    • In the Commands box, click the macro that you are recording.
    • In the Press new shortcut key box, type the key sequence that you want, and then click Assign.
    • Click Close to begin recording the macro.

2. Perform the actions that you want to include in the macro.

  • Also note that when you record a macro, you can use the mouse to click commands and options, but not to select text. You must use the keyboard to select text.

3.To stop recording your actions, click Stop Recording in the Code group.


Here are the steps on how to create Macro in Excel, the basic version – if you are looking for more information or details on this topic I think this Excel Macro Basics training could be useful!

Here at Desktop Training Academy we love feedback and suggestions so please comment in the section below or call us!

Vince – Desktop Training Academy

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>