MS Excel 2007 - Lesson 7: Create 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 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 2

To stop recording Macro:

• Click Macro

• Click Stop Recording

MS 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 4

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

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

5 ★ | 2 Vote

May be interested

  • Google shared successful experiencesPhoto of Google shared successful experiences
    the success of google made many people startled, but also from the philosophy and goals that the search giant is pursuing ...
  • MS Excel 2007 - Lesson 8: Sort and FilterPhoto of MS Excel 2007 - Lesson 8: Sort and Filter
    sort and filter are features that allow you to manipulate data in a spreadsheet based on standards. to sort data and filter data in excel 2007 you will use the sort & filter feature. below tipsmake.com will guide you how to filter data, arrange data with this feature in excel 2007.
  • MS Excel 2007 - Lesson 9: Insert images and graphics into a spreadsheetPhoto of MS Excel 2007 - Lesson 9: Insert images and graphics into a spreadsheet
    insert images, clip art, shape, and smartart into spreadsheets to make the data sheet more vivid and intuitive. adding images or other graphic objects in excel 2007 is quite simple, as long as you know where the extra commands are located on the menu. see the instructions for inserting graphics into excel 2007 spreadsheets below.
  • Format Excel 2007 spreadsheetPhoto of Format Excel 2007 spreadsheet
    sometimes you want to split data in one cell into two or more cells. you can do this easily by using the convert text to columns wizard.
  • MS Excel 2007 - Lesson 12: Develop WorkbookPhoto of MS Excel 2007 - Lesson 12: Develop Workbook
    you can rename a spreadsheet or change the colors of tabs if necessary. as well as moving, transferring and deleting sheets in the same workbook.
  • Google Dashboard - Everything Google knows about youPhoto of Google Dashboard - Everything Google knows about you
    on november 5, google officially launched dashboard service, which gathers all the information that users have sent in other google services.