Anybody Can Create a Macro in Excel

Macros are sub-programs within a program. They are compose of a series of steps that are executed on command.

In Excel, macros can be handy tools for automating a series of steps that you repeat all the time.

With a macro you are able to record a set of tasks and automate the process. The process of developing a macro does not have to involve writing code, Excel offers an automated process to record your steps and create a macro. So anybody that is able to click around a screen can develop and use their own macros.

The Developer tab is not by default installed on the Excel tabs. So the next series of steps will show you how to add the Developer tab to the tabs that you have existing in Excel

To install the Developer tab go to your File tab, Select Options.

From the dialogue box presented Select Customize Ribbon.

From the Customize Ribbon dialog box check the box next to the Developer.

Click on the Developer tab that has just been inserted.

On the first section of the ribbon click Record Macro.

The Record Macro dialogue box is then displayed. Enter a name for your macro and select where you would like to use this macro.

• This workbook - Only Available in this workbook
• New workbook - open a new workbook for this macro
• Personal Macro Work Book - available to this and any new workbook you create

The description allows you to write note about what the macro does.

When you are satisfied, click O.K.

Complete a series of steps that you want repeated

For example, we will merge and centre rows 1 and 2 and columns A through L

Next In this space we will type our company name.

The final step we will do is select row 3 columns; A through L and insert a bold line on the bottom.

That will complete our steps.

Go to the Code section of your Developer tab and Select Stop Recording.

Now go to a new sheet

In your Code section of your Developer tab, Click Macros.

Select the Name of the Macro that you just created and click run.

The next page of your Excel document will be formatted in the exact same way.

So that is an an example of how you could record and run a macro to save you from repeating steps.