Excel macro recording restore cyclic tasks with a couple of mouse clicks or a keyboard mixture. For instance, if you often format cost sheets, you can get a macro to do the formatting for you or you can get Excel to open a exacting file that you frequently use without having to press through a series of sub menus.

Instructions

• Start Excel. A novel workbook is automatically opened for you.

• Unlock the macro soundtrack window. In Excel 2003, press on "Tools > Macro > Record New Macro" and in Excel 2007 press "View > Macros > Record Macro."

• Enter in a meaningful name in the macro box according to what you desire to record: for instance "OpenTaxFile," or "MakeExpenseSheet."

• Enter a shortcut key for your macro in the "Shortcut key" box. For instance, type a "O" to assign the keys "Ctrl" and "O" to your macro.

• Hit on "OK." The macro recorder is currently running.

• Execute the task that you desire the macro to automate. For instance, open a particular file by hit on "File > Open" in Excel 2003, or "Office > Open" in Excel 2007 and then place the file. You can also format a spreadsheet: for instance, make an expense sheet by typing in any information that you desire restricted on the sheet, like mileage and business expenses.

• Discontinue macro recording by pressing on "Macro > Stop Recording." Your macro is currently ready for testing and use.