harjotmann
 
  Home
  Contact
  MBA I
  => Exercise 1,2
  => Exercise 3
  => Grouping information
  => Assignment 3
  => Assesment1
  => Tutorial PowerPoint
  => MST performance
  => Assignment PP
  => excel
  => Excel tute I
  => Excel tute II
  => Excel Tute III
  => Excel Tute IV
  => Excel Tute V
  => Assignment Excel2007
  => Assignment Excel II
  => Important Notice
  MBA II
  Tutorial
  MBA III
  Downloads
  Assesment
  BCA V
Excel Tute V

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 Marcos
  • 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

 
 
   
Today, there have been 33 visitors (36 hits) on this page!
This website was created for free with Own-Free-Website.com. Would you also like to have your own website?
Sign up for free