Creating Macros for Excel XP

Video Transcript

"Hi my name is Dave Andrews, today I'm going to show you how to create macros in Excel. Let's begin by opening up Excel. Click on the start button go to all programs, select Microsoft Office, let's just open up Excel. Now what we have to do is record a new macro. To do so click on tools at the top, click on this arrow at the very bottom to expand it to make you get all the options, highlight macro, and we're going to say record new macro. This brings up the record macro interface where you can name your macro. I'm just going to name it simple macro. I'm going to give it a shortcut key of control plus K, and I'm just going to click okay. Oh well you can't have a space in your name, so let me delete that space and say okay. Now I'm going to do, it's currently recording my macro, so I'm going to do the actions that will occur in my macro. I'm just going to type the numbers one, two, three, and four across the top, and the I'm going to do some formatting on them. I think I'm going to bold it, and make the text larger. Now that I've got my macro actions done, I want to click down here and just say stop recording in this little window that appeared when I began recording. My macro is completed, and to show that it's working I'm going to delete the data that I've just entered. And I'm going to press my shortcut key of control plus K to show that it re-enters it. This process is the same whether you're using Excel 2003 or XP. My name is Dave Andrews, and I've just showed you how to record macros in Excel."