How to Use Macros in Excel on Mac


This post will present a way to master a very convenient function provided by Microsoft Excel. More specifically, Macros basically are small programs which help you to accomplish your complicated work like calculating formulas or generating charts without requirements of knowledge about programming. In addition, you will be able to save a lot of your time when you apply the Macros on your tasks which have the same structure. Now let’s find out this awesome feature of Microsoft Excel on Macintosh.

Enabling Macros

  • Step 1. First off, launch Excel on your machine . Then open a blank workbook.

If you have a specific file which you want to open in Excel, you can launch it.

Recording a Macro

  • Step 1. In order to record a Macro, you need to firstly Enter any necessary data.

It means you can open your specific Excel file you desire to use Macros on it. If you opened a blank workbook, enter any data which you want to use before proceeding.

  • Step 2. Now, click the Developer tab at the top of the Excel window.

  • Step 3. Then Click Record Macro in the toolbar

  • Step 4. After that, there will be a pop-up window. On this window, 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.

  • Step 5. Create a Macro record.

    • You can generate a shortcut key combination as you desire.
      On a Mac, the shortcut key combination will end up being ⌥ [Option]+⌘ [Command] and your key (e.g., ⌥ Option+⌘ Command+T). By doing that, you can use this keyboard shortcut to perform the macro later.

    • Later on, Click the Store macro in" drop-down box in the middle of the window.

    • Now, select This Workbook in the drop-down menu. Your macro will be stored inside your spreadsheet.

    • Next, hit OK to save your macro settings and begins recording.

  • Step 6. Now it’s time to Operate 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:

    • Click and drag your mouse across the data to select it.
    • Click Insert
    • Select a chart shape.
    • Click the chart that you want to use.
  • Step 7. Once you get it done, click Stop Recording . It’s in the Developer toolbar. This will save your macro.

Saving a Macro-Enabled Spreadsheet

  • Step 1. Understand why you have to save the spreadsheet with macros enabled. Ensure that you already saved your spreadsheet as a macro-enabled spreadsheet (XLSM format) otherwise, the macro won’t be saved as part of the sheet. This leads to the fact that people cannot use your macro on their computers once they receive your workbook.

  • Step 2. After that, Click File in the upper-left corner of the Excel

  • Step 3. There will be a drop-down menu, Click Save As .

  • Step 5. Customize saving file details

    • Then you can Enter a name for your Excel file. In the "Name" text field, enter the name for your Excel spreadsheet.
    • Next up, replace the “xlsx” at the end of the file’s name with xlsm in order to save your worksheet in association with macros feature.
    • Now you can Select a location to save your worksheet by clicking the "Where" drop-down box.
    • In the last step, Click Save to get the job done.

Running a Macro

  • Step 1. In order to run a Macro, launch the macro-enabled spreadsheet. Double-click the spreadsheet that has the macro in it to open the spreadsheet in Excel.

  • Step 2. Next, 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. However, if you don’t see this option, you can skip this step.

  • Step 3. Then hit the Developer tab at the top of the Excel window.

  • You can also just press the key combination you set for the macro. Once you do so, the macro will operate, and you can ignore the following steps of this instruction. However, this is just an option.

  • Step 4. Now, Click Macros . You’ll find it in the Developer tab’s toolbar. A pop-up window will open.

  • Step 5. Later on, Select your macro. Click the name of the macro you prefer to run.

  • Step 6. Then Click Run on the right side of the window to operate your macro.

  • Step 7. Now it’s time to Wait for the macro to be completed. This process will take a while based on the size of your macro.

That’s pretty much it.

Wrapping up…

So, now you know how to use the macros function of Microsoft Excel on your Mac. I hope the instruction above is helpful for you to complete your tasks effectively.