How to Create Macros

A macro is a small program that performs a series of actions within software, such as word processors or spreadsheets. Most programs come with many macros you can access from menus or with a few keystrokes. However, you may find that you can complete the work you do easier and faster if you create macros of your own. Each software package has its own way of creating macros, but most should allow you to create a macro by recording.


  1. Image titled Create Macros Step 1
    Make sure you know how to perform each action you want and where to find all the menu options you need to select so you don't have to search for them while recording. The macro will record every keystroke and mouse click, including those that are mistakes, such as clicking on menu options that aren't what you want. These mistakes will occur each time you run the macro.
  2. Image titled Create Macros Step 2
    Find the macros menu and select the option to record a macro. You will see an icon or other indicator that you are recording. For instance, Microsoft Word will display an icon near your mouse pointer that resembles a cassette tape.
  3. Image titled Create Macros Step 3
    Name the macro. Give it it a name that will make it easy for you to remember what the macro does, and select one or a few keystrokes that you will use to run the macro.
  4. Image titled Create Macros Step 4
    Perform the actions you want the macro to perform automatically for you. Examples are setting margins, fonts and tabs; creating headers and footers; choosing how the pages will be numbered and how you will view the document on the screen.
  5. Image titled Create Macros Step 5
    Stop recording.
  6. Image titled Create Macros Step 6
    Test the macro by using the keystrokes you assigned to it, or by selecting the macro from the menu and running it. See if it performs the functions you intend and that you get the correct result.
  7. Image titled Create Macros Step 7
    Edit the macro if you can; otherwise, re-record it. If you don't know anything about writing programs, you probably will not be able to edit the macro. Instead, re-record the macro to make changes, replacing the existing macro with a new one under the same name.
  8. Image titled Create Macros Step 8
    Save the macro, if prompted to do so as a separate step. Macros are saved in a specific directory with a specific file extension. If you change either of these, the software may not be able to find the macro the next time you want to use it.


  • Consider saving your macro as a button on your toolbar. You may be able to add customized commands to your toolbar, and can choose a unique button that will represent your macro.


  • If you create a macro that has the same name as an existing function in your software, the macro will replace that function. The software may not notify you that you are about to assign the same name to a macro that already exists.

Article Info

Categories: Basic Computer Skills