Creating a macro


show more Creating a macro provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Creating a macro

Before you begin to create a macro, you want to make sure that you know exactly the steps that you want to take before you begin to record, because once you start recording, it will track every single movement, every single click, every single selection as you go through your list. So you don't want any extraneous information or any extraneous commands in there. And so you really want to do a test run, and that's what I'd done before we've come here. So, let's begin. What I want to do is I want to have a quick way of adding a header to each of the different sheets that I'm going to be working with, and I want to be able to do that online. I don't want it as a header that I only see when I'm printing out, I want it visual on my worksheets when I'm working with them.

So, to do this quickly, I make sure that I have my Developer tab visible, and I click on it. And I'm coming over to my Record Macro area. So each set of the commands that I perform are go...

Creating a macro
Video duration: 4m 31s 5h 13m Beginner

Viewers:

Creating a macro provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...