Using Macros in Excel

  
  
  
  
Layout:

Get the Flash Player to see this player.

Mark Video Segment:
begin
end
play
[Hide] Copy and paste this link to an email or instant message:
[Hide] Right click this link and add to bookmarks:
Dock windowSearch
Terms:
 
Loading ...

Metadata
Title:Using Macros in Excel
Creator:Sarah D'Antonio


Dock windowTranscript
This tutorial will teach you how to make a Macro in Microsoft Excel 2010.  It is important to remember that there are some differences between Macs and PCs as well as various version of Excel.  Macros speed up repetitive tasks, and after creating one you may assign it to an object like a toolbar object, graphic, or control, so you may run it even easier.  And when you're done using the macro, you can simply delete it!
To get started:   1. Click FILE   2. Click OPTIONS   3. Then select TRUST CENTER   4. Then click the button for TRUST CENTER SETTINGS   5. Under MACRO SETTINGS, click ENABLE ALL MACROS (NOT RECOMMENDED, POTENTIALLY DANGEROUS CODE CAN RUN), and then click OK   6. Then click OK again
Macros are easy to create.  Just tell Excel when to start recording, perform the actions you want, and then tell Excel when you're done. To start recording:   1. Select the cell that you want to format.  I've created some yearly averages over here and we'll be formatting them to make them easier to interpret.   2. Click on the VIEW ribbon.   3. Click on MACROS   4. Click on USE RELATIVE REFERENCES, otherwise the macro will apply only to the specific cell in which you originally perform the actions   5. After you've selected Use Relative References, please select RECORD MACRO   6. In the dialog box that appears, select a name for your macro.  I will call mine "tutorial."   7. Here you can select a control key to make a short cut for your macro.  I will select the letter, W.  It is important not to select a key that may already be a control command, like C, O, V, or X.   8. Click OK From this point on, every Excel command and keystroke will be recorded in the macro, in the order in which they are entered.
From here I will perform the following functions: I will change the color of the cell, the font size, and bold, for extra emphasis. I will select the cell, N5.  From here I will go to the HOME ribbon, and I can change the color to orange, make it bold, and - how about - 12 point font. Now that I'm done with these activities I will go back to the VIEW ribbon.  Click on MACROS.  And click STOP RECORDING.
To see if our macro worked, I will select cell N8 and press Ctrl + W.  As you can see, the cell has turned orange, and is bold, and is bigger.  So our macro worked, and we can continue to run it whenever we feel like, either by doing Ctrl + W or simply by:   1. Going to MACROS   2. Clicking on VIEW MACROS   3. And then we can select "Tutorial"   4. Click RUN
And that's how you create and run a macro in Microsoft Excel 2010.
Dock windowTable of contents
Introduction
Getting Started
Setting Up
Recording
Using Our Macro
Conclusion