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

This article examines Using Excel macros and explains the main developments, practical implications, and context readers should understand.

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 � Write a Macro in Excel 2007

� 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 � Write a Macro in Excel 2007 (2)

To stop recording Macro:

� Click Macro

� Click Stop Recording

MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 � Write a Macro in Excel 2007 (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 � Macro Implementation in Excell 2007 (4)

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

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

FAQ

What does MS Excel 2007 - Lesson 7: Create Macros in Excel 2007 explain?

This article examines Using Excel macros and explains the main developments, practical implications, and context readers should understand.

Who is most affected by Using Excel macros?

Write a Macro in Excel 2007 To record a Macro: � Click the View tab on the Ribbon � Click Macros � Click Record Macro � Enter a name for Marco (no spaces) � Enter a shortcut � Enter Description to explain or describe To stop recording Macro: � Click Macro �.

What are the key takeaways from this topic?

Or you can view all Macros and execute them by: � Click Macros � Click View Macros � Select a Macro and click Run Next lesson: MS Excel 2007 - Lesson 8: Sort and Filter Previous article: MS Excel 2007 - Lesson 6: Calculation in Excel.