Writing Macros in Microsoft Excel

Save
Next Video:
Using a Remote Desktop....5

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.

Part of the Video Series: Computer Software & Tech Support
Promoted By Zergnet

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.

Featured

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!