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
Step 5: Click on the newly appeared Developer tab
Step 6: Click on Record Macro in the Code Section
Step 7: In the menu that appears, enter in a name, a shortcut key and a description of the macro and click OK
Step 8: The Macro will now record all the keystrokes you make