How to Record Macros in Excel 2013

Macros are extremely useful for users who perform repetitive tasks in spreadsheets. This guide on how to record macros in Excel 2013 will walk you through the process of setting up your own macro for your spreadsheet. A macro is a small program that records your keystrokes while you are performing tasks. When you run a recorded macro, it will repeat those keystrokes and in doing so, it will do your tasks for you. If you learn how to record macros in Excel 2013, you can save a whole lot of time when doing repetitive tasks.

Step 1: Launch Excel 2013

Step 2: In a new spreadsheet, press Alt + FT

Step 3: In the Excel Options menu that appears, click on the Customize Ribbon tab

 

Step 4: Under the Main Tabs section, select the Developer checkbox and click OK

How to Record Macros in Excel 2013 1How to Record Macros in Excel 2013 2

Step 5: Click on the newly appeared Developer tab

How to Record Macros in Excel 2013 3

Step 6: Click on Record Macro in the Code Section

How to Record Macros in Excel 2013 4

Step 7: In the menu that appears, enter in a name, a shortcut key and a description of the macro and click OK

How to Record Macros in Excel 2013 5

Step 8: The Macro will now record all the keystrokes you make

Leave a Reply