eHow launches Android app: Get the best of eHow on the go.

Recording Excel Macros

Video Preview

Summary: When recording a macro in Excel, select the "Record Macros" option from the "Macros" section of the "View" menu. Record a macro in Excel with these tips from a software developer in this free video about computer technology.

Views:
201
Presenter
By Dave Andrews
eHow Presenter

Dave Andrews is a software developer with a business and Web site selling programs and other computer services in Franklin, Tenn. Having worked in the IT industry for more than 8...read more

Post a Comment

Post a Comment

Video Transcript

"Hi my name is Dave Andrews, today I'm going to show you how to record Excel Macros. To begin let's open up Excel. Click on the start button, go to all programs, choose Microsoft Office, let's select Excel. Now to begin recording our macro let's go to the view tab. Under the macros area, click on macros, and say record macros. That brings up your new macro screen. Let's name this macro, my macro. Let's give it a short cut key, let's say control plus K, and press okay. Now what it's currently doing is recording everything that we do within Excel, so that it can be easily redone when we run the macro. So let's enter some data. Let's format this text. That has been recorded by our macro. To stop, let's go back to the view tab, select macros, and say stop recording. Our macro has just been created. To run the macro let's press our short cut key, which was control plus K. As you can see our macro has just been rerun. Let me delete this data, and run it again to show you that it enters the data correctly. Select control K, the data has just been put in. My name is Dave Andrews, and I've just show you how to record macros in Excel."

eHow Article: Recording Excel Macros

Related Ads

  • Have you done this? Click here to let us know.
Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

eHow Computers
eHow_eHow Technology and Electronics