MS Excel 2007 - Lesson 7: Create Macros in Excel 2007

Macros are advanced features, which can speed up editing or formatting that you can do regularly in an Excel spreadsheet. In this Excel lesson, TipsMake.com will show you how to use Macros in Excel 2007.

TipsMake.com - Macros are advanced features, which can speed up editing or formatting that you can do regularly in an Excel spreadsheet. They record the actions you have selected in the menu so that a sequence of actions can be completed in one step. In this Excel lesson, TipsMake.com will show you how to use Macros in Excel 2007.

Write a Macro in Excel 2007

To record a Macro:

• Click the View tab on the Ribbon

• Click Macros

• Click Record Macro

MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 Picture 1MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 Picture 1

• Enter a name for Marco (no spaces)

• Enter a shortcut

• Enter Description to explain or describe

MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 Picture 2MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 Picture 2

To stop recording Macro:

• Click Macro

• Click Stop Recording

MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 Picture 3MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 Picture 3

Macro implementation in Excell 2007

To execute a Macro from the shortcut, simply press the key you selected

to run Macro. Or you can view all Macros and execute them by:

• Click Macros

• Click View Macros

• Select a Macro and click Run

MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 Picture 4MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 Picture 4

Next lesson: MS Excel 2007 - Lesson 8: Sort and Filter

Previous article: MS Excel 2007 - Lesson 6: Calculation in Excel

5 ★ | 2 Vote