Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Excel
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
« Performing Calculations Macros Sort and Filter »

Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet. They record sequences of menu selections that you choose so that a series of actions can be completed in one step.

Recording a Macro
To record a Macro:

  • Click the View tab on the Ribbon
  • Click Macros
  • Click Record Macro
  • Enter a name (without spaces)
  • Enter a Shortcut Key
  • Enter a Description

Record Macro Dialog Box

  • Perform the Macro
  • Click Macros
  • Click Stop Recording

Stop Recording Macro Button

Running a Macro
To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the Macro.  Or you can view all macros and run by:

  • Click Macros
  • Click View Macros
  • Choose the Macro and click Run

View Macros Dialog Box

« Performing Calculations Macros Sort and Filter »


Office 2007 Tutorials · Word · Excel · PowerPoint · Access

FGCU does not provide personal support for Office 2007 programs to outside parties.


© FGCU 2007. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory