How to create a Macro in Excel 2013

Description: Here is a quick guide on how to create a Macro in Excel 2013.

  1. With Excel open, click on the Developer Tab and select Macros.
    Excel Developer Tab, Macros
  2. If you do not have the Developer Tab available follow this guide to enable it.
  3. Fill in the chosen name of the Macro and select Create.
    Macro Name Field
  4. Once in the Macro page you can go ahead and write the VBA code for your macro.
    VBA Macro Code
  5. To go back to your Excel Spreadsheet, select File and Close and Return to Microsoft Excel.
    Close and Return to Excel