Creating and Modifying Macros

The first step of creating a macro is to plan the process you want to automate. Computers today are quite fast, so adding an extra step that doesn’t affect the outcome of a process doesn’t slow you down noticeably, but leaving out a step means you will need to rerecord your macro. After you plan your process, you can create a macro by clicking the View tab and then, in the Macros group, clicking the Macros button down arrow. From the list that appears, click Record Macro. When you do, the Record Macro dialog box appears.

After you type the name of your macro in the Macro Name box, click OK. You can now perform the actions you want Excel 2007 to repeat later; when you’re done, click the View tab and then, in the Macros group, click the Macros button down arrow. From the list that appears, click Stop Recording to add your macro to the list of macros available in your workbook.