HomeApplicationOffice information

How to Use Macros in Excel

This wikiHow teaches you how to enable, create, run, and save macros in Microsoft Excel. Macros are miniature programs which allow you to perform complex tasks, such as calculating formulas or creating charts, within Excel. Macros can save...
Part 1 of 4:

Enabling Macros

  1. How to Use Macros in Excel Picture 1How to Use Macros in Excel Picture 1
    Open Excel. Double-click the Excel app icon, which resembles a white "X" on a green box, then click Blank workbook.
    1. If you have a specific file which you want to open in Excel, double-click that file to open it instead.
  2. How to Use Macros in Excel Picture 2How to Use Macros in Excel Picture 2
    Click File. It's in the upper-left side of the Excel window.
    1. On a Mac, click Excel in the upper-left corner of the screen to prompt a drop-down menu.
  3. How to Use Macros in Excel Picture 3How to Use Macros in Excel Picture 3
    Click Options. You'll find this on the left side of the Excel window.
    1. On a Mac, you'll click Preferences... in the drop-down menu.
  4. How to Use Macros in Excel Picture 4How to Use Macros in Excel Picture 4
    Click Customize Ribbon. It's on the left side of the Excel Options window.[1]
    1. On a Mac, click instead Ribbon & Toolbar in the Preferences window.
  5. How to Use Macros in Excel Picture 5How to Use Macros in Excel Picture 5
    Check the "Developer" box. This box is near the bottom of the "Main Tabs" list of options.
  6. How to Use Macros in Excel Picture 6How to Use Macros in Excel Picture 6
    Click OK. It's at the bottom of the window. You can now use macros in Excel.
    1. On a Mac, you'll click Save here instead.
Part 2 of 4:

Recording a Macro

  1. How to Use Macros in Excel Picture 7How to Use Macros in Excel Picture 7
    Enter any necessary data. If you opened a blank workbook, enter any data which you want to use before proceeding.
    1. You can also close Excel and open a specific Excel file by double-clicking it.
  2. How to Use Macros in Excel Picture 8How to Use Macros in Excel Picture 8
    Click the Developer tab. It's at the top of the Excel window. Doing so opens a toolbar here.
  3. How to Use Macros in Excel Picture 9How to Use Macros in Excel Picture 9
    Click Record Macro. It's in the toolbar. A pop-up window will appear.
  4. How to Use Macros in Excel Picture 10How to Use Macros in Excel Picture 10
    Enter a name for the macro. In the "Macro name" text box, type in the name for your macro. This will help you identify the macro later.
  5. How to Use Macros in Excel Picture 11How to Use Macros in Excel Picture 11
    Create a shortcut key combination if you like. Press the ⇧ Shift key along with another letter key (e.g., the E key) to create the keyboard shortcut. You can use this keyboard shortcut to run the macro later.
    1. On a Mac, the shortcut key combination will end up being ⌥ Option+⌘ Command and your key (e.g., ⌥ Option+⌘ Command+T).
  6. How to Use Macros in Excel Picture 12How to Use Macros in Excel Picture 12
    Click the "Store macro in" drop-down box. It's in the middle of the window. Doing so prompts a drop-down menu.
  7. How to Use Macros in Excel Picture 13How to Use Macros in Excel Picture 13
    Click This Workbook. This option is in the drop-down menu. Your macro will be stored inside your spreadsheet, making it possible for anyone who has the spreadsheet to access the macro.
  8. How to Use Macros in Excel Picture 14How to Use Macros in Excel Picture 14
    Click OK. It's at the bottom of the window. Doing this saves your macro settings and begins recording.
  9. How to Use Macros in Excel Picture 15How to Use Macros in Excel Picture 15
    Perform the macro's steps. Any step you perform between clicking OK and clicking Stop Recording while be added to the macro. For example, if you wanted to create a macro which turns two columns' worth of data into a chart, you would do the following:
    1. Click and drag your mouse across the data to select it.
    2. Click Insert
    3. Select a chart shape.
    4. Click the chart that you want to use.
  10. How to Use Macros in Excel Picture 16How to Use Macros in Excel Picture 16
    Click Stop Recording. It's in the Developer toolbar. This will save your macro.
Part 3 of 4:

Saving a Macro-Enabled Spreadsheet

  1. Understand why you have to save the spreadsheet with macros enabled. If you don't save your spreadsheet as a macro-enabled spreadsheet (XLSM format), the macro won't be saved as part of the spreadsheet, meaning that other people on different computers won't be able to use your macro if you send the workbook to them.
  2. How to Use Macros in Excel Picture 17How to Use Macros in Excel Picture 17
    Click File. It's in the upper-left corner of the Excel window (Windows) or the screen (Mac). Doing so will prompt a drop-down menu.
  3. How to Use Macros in Excel Picture 18How to Use Macros in Excel Picture 18
    Click Save As. This option is on the left side of the window (Windows) or in the drop-down menu (Mac).
  4. How to Use Macros in Excel Picture 19How to Use Macros in Excel Picture 19
    Double-click This PC. It's in the column of save locations near the left side of the window. A "Save As" window will open.
    1. Skip this step on a Mac.
  5. How to Use Macros in Excel Picture 20How to Use Macros in Excel Picture 20
    Enter a name for your Excel file. In the "Name" text box, type in the name for your Excel spreadsheet.
  6. How to Use Macros in Excel Picture 21How to Use Macros in Excel Picture 21
    Change the file format to XLSM. Click the "Save as type" drop-down box, then click Excel Macro-Enabled Workbook in the resulting drop-down menu.[2]
    1. On a Mac, you'll replace the "xlsx" at the end of the file's name with xlsm.
  7. How to Use Macros in Excel Picture 22How to Use Macros in Excel Picture 22
    Select a save location. Click a folder in which you want to save the Excel file (e.g., Desktop).
    1. On a Mac, you must first click the "Where" drop-down box.
  8. How to Use Macros in Excel Picture 23How to Use Macros in Excel Picture 23
    Click Save. It's at the bottom of the window. Doing so will save your Excel spreadsheet to your selected location, and your macro will be saved along with it.
Part 4 of 4:

Running a Macro

  1. How to Use Macros in Excel Picture 24How to Use Macros in Excel Picture 24
    Open the macro-enabled spreadsheet. Double-click the spreadsheet that has the macro in it to open the spreadsheet in Excel.
  2. How to Use Macros in Excel Picture 25How to Use Macros in Excel Picture 25
    Click Enable Content. It's in a yellow bar at the top of the Excel window. This will unlock the spreadsheet and allow you to use the macro.
    1. If you don't see this option, skip this step.
  3. How to Use Macros in Excel Picture 26How to Use Macros in Excel Picture 26
    Click the Developer tab. This option is at the top of the Excel window.
    1. You can also just press the key combination you set for the macro. If you do so, the macro will run, and you can skip the rest of this method.
  4. How to Use Macros in Excel Picture 27How to Use Macros in Excel Picture 27
    Click Macros. You'll find it in the Developer tab's toolbar. A pop-up window will open.
  5. How to Use Macros in Excel Picture 28How to Use Macros in Excel Picture 28
    Select your macro. Click the name of the macro which you want to run.
  6. How to Use Macros in Excel Picture 29How to Use Macros in Excel Picture 29
    Click Run. It's on the right side of the window. Your macro will begin running.
  7. Wait for the macro to finish running. Depending on how large your macro is, this can take several seconds.
5 ★ | 1 Vote
clickmacroexcelwindow

You should read it

Maybe you are interested

Office information