Recording a basic macro.

.

CREATING A BASIC MACRO


Macro :- Macro is a shortcut to a task we do repeatedly.

Here we have practiced a basic macro which perform a series of actions just with a shortcut key (ctrl+r), now we will go through the process of recording a basic macro in a step by step manner.

STEP 1 :
Open an excel document,

STEP 2 :
On the tools menu click the Macro, and then click record new macro.

STEP 3:
In the name box enter a name for the macro.

STEP 4 :
Now enter a letter in the shortcut key box. The letter can be any key on the keyboard special charecters. (In this practice I have entered R)

STEP 5 :
Now in the storage box, click the location you want to store the macro.

STEP 6:
Click OK.

STEP 7 :
Carry outou want to record.(in this practice sheet we have entered three words in tree cells and recorded the font, bold center and coloring actions.)

STEP 8 :
Now with the stop recording toolbar stop recording.

STEP 9 :
Now save the work sheet.

STEP 10 :Now the macro is saved on the worksheet and whenever I have to perform all these actions , I just need to enter ctrl+r they will be done automatically.

.