Video: Writing Macros in Microsoft Excel

This Season: Tailgating; Tech Know; New Year, New You; Tax Time

Macros can be written in Microsoft Excel by using the recording feature, which is found under the "View" tab. Use macros to conduct repetitive tasks in Microsoft Excel with help from a software developer in this free video on Microsoft Excel.

- Sell a Broken Laptop

Comments

Video Transcript

Hi. My name is Dave Andrews. Today I'm going to show you how to write Macros in Excel. In Excel you write Macros by using its recording feature. So I'm going to show you how to use that. Let's open up Excel by clicking on our start button. Let's go to All Programs, Microsoft Office. Let's just select Excel. Now what I'm going to do is record a Macro that does some typing and some formatting for me. Let's go to the view tab. And under Macros let's click on record Macro. Now I'm going to call this easy typer and say okay. Now it is now recording every step that I take within my document and its going to make that into a Macro. So what I'm going to do is I'm going to type just some data in here. You see I'm putting it in different fields. I don't have to that. I could really be doing anything but I'm going to highlight all this. I'm going to change the background color. I'm going to bold these things and make them white here. And also I'm going to make David large like that. So its just recorded every single step that I've taken. So I'm going to go to view and stop recording. Now if I delete all this I can very easily recreate it by running my Macro. Just go back to the view tab under Macros. Click on view Macros and there I have easy typer. I'm going to select it. And just click run. And you can see all that I have done is just been recreated by my Macro. So Macros can be used to very, very easily conduct repetitive tasks. My name is Dave Andrews and I've just showed you how to write Macros in Microsoft Excel.

Follow eHow: Follow @eHow

Writing Macros in Microsoft Excel

Comments

Related Ads

Related Articles & Videos